[Resolved] Total

Zack

Hey guys. I need some help totaling a list of numbers. I tried while() with bcadd(), but it's not allowed on my server. I can't change my php.ini file and I can't find another way, so I need your help.

the text file looks like this:

I need to go through each line and total the money, but I can't find a way...

Here is my code for the form and display:

<html>
<head>
<title>Tips: Westport Country Playhouse, Summer 2003</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="tips.css" rel="stylesheet" type="text/css">
</head>

<body topmargin="30">

<?PHP

// Write the new tip to a text file...
if($HTTP_POST_VARS['submit']) {
        if(!$HTTP_POST_VARS['date']) {
            echo "You must enter the date you acquired the tip.";
            exit;
        }
		if(!$HTTP_POST_VARS['tip']) {
            echo "You must enter the amount of your tip.";
            exit;
        }
        $fp = fopen('tips.txt','a');
        if(!$fp) {
            echo "Error opening file!";
            exit;
        }
		$line = $HTTP_POST_VARS['tipID'];
        $line .= "|" . $HTTP_POST_VARS['date'];
        $line .= "|" . $HTTP_POST_VARS['tip'];
        $line = str_replace("\r\n","<BR>",$line);
        $line .= "\r\n";
        fwrite($fp, $line);
        if(!fclose($fp)) {
            echo "Error closing file!";
            exit;
        }        

    }

//Display all the tips and the dates...

?>

<table align="center" width="200" border="1" bordercolor="#000000" cellspacing="0" cellpadding="5">
  <tr> 
    <td bgcolor="#E4C389" colspan="2"><center>
        <font size="+4" face="Geneva, Arial, Helvetica, sans-serif"><b>TIPS</b></font></center></td>
  </tr>
  <tr> 
    <td bgcolor="#E3E489" width="50%"><center>
        <font size="+1" face="Geneva, Arial, Helvetica, sans-serif">DATE</font></center></td>
    <td bgcolor="#E3E489" width="50%"><center>
        <font size="+1" face="Geneva, Arial, Helvetica, sans-serif">AMOUNT</font></center></td>
  </tr>
  <?PHP

$i=-1;
$fd = fopen ("tips.txt", "r"); 
while (!feof($fd)) { 
$i++; 
$buffer = fgets($fd, 4096);
}
fclose ($fd);

  $z = $i - 1;
  $data = file('tips.txt'); 
       $e=-1; 
  while ($e<$z) {
	   $e++; 
       $element = trim($data[$e]); 
       $tip = explode("|",$element);

?>
  <tr> 
    <td bgcolor="#9CE489" width="50%"><center>
        <font size="1" face="Geneva, Arial, Helvetica, sans-serif"><?PHP echo $tip[1]; ?></font></center></td>
    <td bgcolor="#89BFE4" width="50%"><center>
        <font size="1" face="Geneva, Arial, Helvetica, sans-serif">$<?PHP echo $tip[2]; ?></font></center></td>
  </tr>
  <?PHP

}

?>

  <tr> 
    <td bgcolor="#E48989" colspan="2"> <center>
        <font size="+2" face="Geneva, Arial, Helvetica, sans-serif"><b>ADD TIP:</b></font>
      </center>
      <FORM ACTION="<?=$PHP_SELF?>" METHOD="POST" NAME="addTip">
        <center>
          <font size="2" face="Geneva, Arial, Helvetica, sans-serif"><b>Date:</b></font>
        </center>
        <center>
          <INPUT class="input" TYPE="text" SIZE="20" NAME="date">
        </center>
        <BR>
        <center>
          <font size="2" face="Geneva, Arial, Helvetica, sans-serif"><b>Amount:</b></font>
        </center>
        <center>
          <INPUT class="input" TYPE="text" SIZE="20" NAME="tip">
          <BR>
        </center>
        <center>
          <input type="hidden" name="tipID" value="<?PHP print $i; ?>">
        </center>
        <br>
        <center>
          <INPUT class="input" TYPE="submit" NAME="submit" VALUE="Add Tip">
          <BR>
        </center>
      </FORM></td>
  </tr>
</table>

</body>
</html>

Thanks in advance...

Galaga

Try trimming the elements after the explode.

Zack

I don't think you read my question correctly. The code above works perfectly. NOW, I need to add something that totals everything with the variable: $tip[2], however, I can't figure it out.

My question is How do I total together all of the $tip[2]'s?

Your recommendation doesn't help. Thanks, though.

kevinsequeira

try this

<?php
.
.

$total_tip2 = 0;
while ($e<$z) {
       $e++; 
       $element = trim($data[$e]); 
       $tip = explode("|",$element);
				 $total_tip2 = $total_tip2+$tip[2];

?>
  <tr>
    <td bgcolor="#9CE489" width="50%"><center>
        <font size="1" face="Geneva, Arial, Helvetica, sans-serif"><?PHP echo $tip[1]; ?></font></center></td>
    <td bgcolor="#89BFE4" width="50%"><center>
        <font size="1" face="Geneva, Arial, Helvetica, sans-serif">$<?PHP echo $tip[2]; ?></font></center></td>
  </tr>
  <?PHP

} 
echo $total_tip2;
.
.

?>

i hope i read your question properly ..

reg
kevin

Zack

great, now how do I round that so that if it's $14.50, it shows up as $14.50 instead of $14.5, like it is now?

round() doesn't work...

Zack

nevermind... i got it..