[RESOLVED] Array problem

Riche

I am trying to add elements in a flat text file and count how many there are!

$filename = "tickets/TICKETS.DAT";
$size = filesize($filename);
$handle = fopen($filename, "r");


while (!feof($handle)) {
        $contents .= fread($handle, $size);
		$ticketcount = preg_match_all('/([0-9]{2,3})\.([0-9]{2})/', $contents,$matches);

	if (preg_match_all('/([0-9]{2,3})\.([0-9]{2})/',$contents,$tickets)){

	$result = array("$tickets");

}

}

echo "Sum of values = ".array_sum($tickets)."<br>";
print "$ticketcount Tickets";

The TICKET.DAT looks like this:

60.00
40.00
20.00
80.00
100.00

The output is looking like this:

Sum of values = 0
5 Tickets

How do add values in the array? if it is an array? ... I hate arrays...
Please help..

kbc1

array_push()

adds to the end of an array

Riche

kbc1 wrote:
array_push() 
adds to the end of an array

Sorry I didnt make myself clear ...

60.00
40.00
20.00
80.00
100.00

The sum of the values should be:

300.00

I didnt want to add value to the array..

But thanks anyway.

bpat1434

Do me a favor, put this line above where you your echo statement:

print_r($tickets);

I'm guessing that it's empty....

Now, to get the sum... you'd need to split the dat file by lines so that you have nothing but numbers....

Try this:

<?php
$filename = 'tickets/TICKETS.DAT';
$info = file_get_contents($filename);

$prices = explode("\n", $info);

$ticketcount = count($prices);

echo 'Sum of values: $' . array_sum($prices) . '<br />' . $ticketcount . ' Tickets.';
?>

EDIT: Okay, so it's not that the array is empty, it's that the prices are a sub-array of the $tickets array.

laserlight

The file format is guaranteed to be as specified, and if it is guaranteed to have no gaps or leading/trailing lines, the solution could be as simple as:

$filename = "tickets/TICKETS.DAT";
$lines = file($filename);
echo 'Sum of values = ' . array_sum($lines) . '<br />'
    . count($lines) . ' Tickets';

Of course, instead of making those assumptions you may want to loop over the $lines array and use only those lines with a number.

Riche

bpat1434 wrote:
Do me a favor, put this line above where you your echo statement:
print_r($tickets);
I'm guessing that it's empty....

Now, to get the sum... you'd need to split the dat file by lines so that you have nothing but numbers....

Try this:
<?php
$filename = 'tickets/TICKETS.DAT';
$info = file_get_contents($filename);

$prices = explode("\n", $info);

$ticketcount = count($prices);

echo 'Sum of values: $' . array_sum($prices) . '<br />' . $ticketcount . ' Tickets.';

Yes I do get nothing returned.

$ticketcount = preg_match_all('/([0-9]{2,3}).([0-9]{2})/', $contents,$matches); I do need this though as the original ticket file will have other data in it as well as the prices

data 80.00 moredata and somemoredata etc
data 60.00 moredata and somemoredata etc
data 40.00 moredata and somemoredata etc
data 20.00 moredata and somemoredata etc

I just need to filter out the prices and then add them up... doh

It is a space delimited file 🙁

Sorry again!
But thanks

bpat1434

Ah, then you can just use $tickets[0] instead of $tickets in the array_sum function 😉

Riche

Thankyou very much 🙂