[RESOLVED] adding numbers from a text document

soundslammer

I've tried, and searched and lost sleep over this one and I've nearly admitted defeat.

I have a text document with certain details listed which comes from another document which comes from a series of forms.
The document, let's say 'test.txt', has numerical values at lines 5, 11,17, 23 and so on so forth (just add 6 to the last number and you get the next). Each month the numbers in the file will be added together to give a total. Now there could be only a few numerical entries into the file, or there could be a hundred entries.
How can I add the numbers from test.txt lines 5, 11, 17, 23, 29 etc etc together to make a total without having to do the "$lines[5], 1, 4 " + $lines[11], 1, 4" etc etc.

I do hope someone can help me on this before I go demented.

Thanks!

maxpup979

laugh. no problem. when you read the file, use mod to ignore any line but the ones you need. ie if ($linecount%6==0)
and then just add them as you loop through the file.

soundslammer

I think I'll have to read up on this a little more, I've noted what you've said and I'll try and figure out what you mean! lol, thanks for yer help!

soundslammer

I can open up the file no probs, it's just knowing where to put the code, and what the code is too to add up the lines. I can do it easy the long way, but I don't have enough years in my life to carry through to the end... aargh

soundslammer

I'm sorry, I can't get this to work, and in a mad fitted rage I've deleted the shambles I've written and saved the damned file, and my clipboard was empty once I cooled down. Can anyone save my wits? I'd really really really appreciate it.

soundslammer

ok, heres the code I put in, and for some re3ason I didn't use the lil snippet you gave me.

<?php
$month = $POST["month"];
$year = $POST["year"];
$filename = ("$month$year.html");
$lines=file("figures\$filename");
echo "<PRE>\n";
for($i=0
;$i<count($lines);$i++){
echo "$i: ".$lines[$i];
}
echo "</PRE>\n";
?>

maxpup979

I was thinking something along these lines....

<?php
$filename="whatever";
$handle = fopen($filename, "r");
$count=1;#you may need to play with the starting count...dont know
$total=0;
while (!feof($handle)) {
   $buffer = fgets($handle, 4096);
   if(($count%6)==0){
	   echo $buffer;#this is just to check visually that this is the proper line
	   $total=$total+$buffer;
	}
	$count++;
}
fclose($handle);

?>

Now...looking at the code you posted....I would think that these changes should let it work just fine. with some minor adjustments....

<?php
$total=0;
$month = $_POST["month"];
$year = $_POST["year"];
$filename = ("$month$year.html");
$lines=file("figures\\$filename");
echo "<PRE>\n";
for($i=0;$i<count($lines);$i++){
    if($i%6==0){
        echo "$i: ".$lines[$i];
        $total=$total+$lines[i];
    }

}
echo "</PRE>\n";
?>

soundslammer

Thanks, I'll give it a wee shot.

gufmn

Why are using the $count%6 == 0 thing?

Nevermind. Just got it.

maxpup979

the file contains the numbers to be added on every 6th line. so if you mod the line number by 6, and get no remainder...id ($count%6==), then you know that you are on a line that has the numbers you need. Granted, you may need to adjust a few things...ie if the numbers you need are on every 6th line starting with 3 (3,9,15...), but you will still need to do the mod operation.

grin...now you tell me you got it...🙂

soundslammer

Yeah it worked, I needed to change a few things, but nothing major off what you wrote. I've just learned a lil bit more......again!!!
Thanks ever so much for your help, I really do appreciate it.