multiple values in one field

raouleduke

I am pulling data from legacy unix systems and puting the data into a mysql database, when I pull the data out there are multiple values in each record, how do I use php to search through the multiple records. The data looks like this, and it is stored in one record.

4   RRRP   WB   12B   WPNC   24K   3K   WPAI

I want to be able to search through and find what I need, but how do I make it differentiate between the values, it looks like they have at least one space in them.

One more question of the same nature, when I pull the prices out they are again all stored in the same field, I want to add all them up and store them as one value.
It looks like this.

11.95   27.03   49.95   22.29   62.10

Any Idea's anyone, haven't really run into this before, thanks in advance.

Weedpacket

You've got [man]preg_split[/man], which will turn the line into an array, and [man]array_sum[/man], which can add the elements of an array to give their sum.

dalecosp

Could you explode() using the space? Or perhaps a preg_split()?

raouleduke

How do I use the preg_split, with a space delimiter?

$labor_array = preg_split(" ", $labor);

Thanks in advance.

raouleduke

I am using this,

$labor = $row["LABOR"];
$labor_array = preg_split("/[\s,]+/", $labor);

I when I echo labor_array I get array.

Any ideas,
thanks in advance.

Weedpacket

Originally posted by raouleduke
I when I echo labor_array I get array.

Of, course - it's an array. What should it echo?

raouleduke

No it just echo's the Word Array, it should echo

'11.95','27.03','49.95','22.29','62.10'

So that I can use the add array.

Thanks in advance.

dalecosp

No it just echo's the Word Array, it should echo

Originally posted by Weedpacket
You've got [man]preg_split[/man], which will turn the line into an array,

No, it echoes "Array" because, as he said, it returns an array...

Calling echo() or print() on an array will do this, because echo and print take strings as their argument, not arrays, according to the manual. In practice, PHP is very forgiving, so echo and print may use almost any expression as an argument, but an array is not exactly an expression, either, not without some other magic, anyway....

You might try something like:

foreach($labor_array as $li) {
    echo "'".$li.",'";
}

raouleduke

I got this to break the values apart,

$labor = $row["LABORAMT"]; 
	$labor_array = preg_split('/ /', $labor, -1, PREG_SPLIT_OFFSET_CAPTURE);
	print_r($labor_array);

This shows this:

Array ( [0] => 45.09 [1] => 11.43 )

Now how do I add these together.

dalecosp

Lots of possibilities...

for ($c=1; $c<count($labor); $c++) {
   $total+=$labor[$c];
}

... is one that springs to mind.

raouleduke

This works it adds up the fields, but the sum all at the bottom does not work, can some add some insight.

$query = "SELECT * FROM LUTHERSELLANDRECOMMEND";
	$result = mysql_query($query);
	while ($row = mysql_fetch_array($result)) {
	$rodollar = $row["RO"];
	$str = $row["LABORAMT"]; 
	$chars = preg_split("/ /", $str);
	$str1 = $row["MISCAMT"]; 
	$chars1 = preg_split("/ /", $str1);
	$str2 = $row["PARTSAMT"]; 
	$chars2 = preg_split("/ /", $str2);

print "
<table border=1>
<tr>
<td>$str</td>
<td>sum(labor) = " . array_sum($chars) . "</td>
<td>$str1</td>
<td>sum(misc) = " . array_sum($chars1) . "</td>
<td>$str2</td>
<td>sum(parts) = " . array_sum($chars2) . "</td>
<td>sum(all) = (array_sum($chars) + array_sum($chars1) + array_sum($chars2))</td>
</tr>
</table>";
}

Thanks in advance.

Weedpacket

Originally posted by raouleduke
can some add some insight.

Take the sum out of quotes the way you do for the three lines above it? Put it in () as well in case there are complaints about mixing . and +.