calculations & re-loading pages

andoi

Hi,
I am currently trying to build a site which displays a list of foods & their various nutritional values per gram of the food. I have all of this data in a database and I can successfully get all of this to appear on a web-page - by using an array to display each row of the table. I now need to provide a method fo the user to enter the amount of each food required (in grams) for each food.

The system must then calculate the total nutritional values (ie: amount of food in grams x nutritional value) and present this for the user to see.

I have very little experience with php and I have been messing around for ages trying to get this to work. I am not sure but I think the way to do it is hold each amount in different variables and have a re-loading page which can make use of them??

Im v stuck! If someone can help, please explain in simple terms coz Ive only been using php & sql 4 a couple of weeks
cheers

example of what I need:

Food------Fat----Energy--amount
Chicken---2------7---------1000 - user enters amount
Beef-------4------8---------100_

(SUBMIT BUTTON)

----Page reloads------

Foods chosen:
Chicken
Beef

Total Fat-------Total Energy
2400------------7800

bastien

post your code

andoi

These are the foods which are in it:
+----+------------+--------+--------+---------+------+-------+---------+------+-
-------+------+------+
| ID | Food | foodId | Energy | Protein | Fat | Carbo | Calcium | Iron |
Sodium | VitA | VitC |
+----+------------+--------+--------+---------+------+-------+---------+------+-
-------+------+------+
| 1 | Cornflakes | 1 | 368 | 8.6 | 1.6 | 85.1 | 3 | 6.7 |
1160 | 0 | 0 |
| 2 | Weetabix | 2 | 340 | 11.4 | 3.4 | 70.3 | 33 | 7.6 |
360 | 0 | 0 |
| 3 | Muesli | 3 | 368 | 12.9 | 7.5 | 66.2 | 200 | 4.6 |
180 | 0 | 0 |
| 4 | Porridge | 4 | 374 | 10.9 | 9.2 | 66 | 52 | 3.8 |
9 | 0 | 0 |
| 5 | Milk | 5 | 65 | 3.2 | 3.9 | 4.6 | 103 | 0.1 |
50 | 56 | 1.5 |
| 6 | Sugar | 6 | 394 | 0 | 0 | 105.3 | 2 | 0 |
0 | 0 | 0 |
+----+------------+--------+--------+---------+------+-------+---------+------+-

This is the code which I have been trying to get to work - There are probably quite a few errors but you should be able to see what I am trying to do. Thanks

HTML>
<BODY>
<?php
if(isset($calc)):
?>
<Table><tr>
<td width=70><B>Energy (Kcals)</B></td>
<td width=70><B>Protein (g)</B></td>
<td width=70><B>Fat (g)</B></td>
<td width=70><B>Carbo (g)</B></td>
<td width=70><B>Calcium (g)</B></td>
<td width=70><B>Iron (mg)</B></td>
<td width=70><B>Sodium (mg)</B></td>
<td width=70><B>VitA (mmg)</B></td>
<td width=70><B>VitC (mg)</B></td></tr>

// IN THESE ROWS I WANT THE RESULTS TO BE SHOWN
<tr>
<td width=70></td>
<td width=70></td>
<td width=70></td>
<td width=70></td>
<td width=70></td>
<td width=70></td>
<td width=70></td>
<td width=70></td>
<td width=70></td></tr>

<?php
else:

// Set the page title and include the HTML header.
$page_title = 'Select the food amounts';
include_once ('templates/header.inc');

$dbcnx = @mysql_connect();
if(!$dbcnx) {
echo("<P>Unable to connect to the server</P>");
exit();
}

//select the food database
if(! @mysql_select_db("Foods")) {
echo("<P>Unable to locate the food database</P>");
exit();
}

$query = "SELECT * FROM breakfast";
echo '<br><table border="1" cellspacing="3" cellpadding="3" align="center"><tr>';

// Display all the URLs.
$result = mysql_query ($query);
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

// Display each record.
echo "<td>{$row['Food']}</td>";

} // End of while loop.

echo '</tr>'; // Close the table row.
echo '<tr><td><input type=text name=cornamount></td>';
echo '<td><input type=text name=food1amount></td>';
echo '<td><input type=text name=food2amount></td>';
echo '<td><input type=text name=food3amount></td>';
echo '<td><input type=text name=food4amount></td>';
echo '<td><input type=text name=food5amount></td></tr></table><br>';

echo '<INPUT TYPE=SUBMIT NAME="calc" VALUE="calc">';

include_once ('templates/footer.inc'); // Require the HTML footer.
?>
</BODY>
</HTML>

bastien

this may help you point to the right direction

<BODY> 
<?php 
if(isset($_POST['submit']){
  show_results();
}else{
  show_form();
} 
<?
function show_results()
{
	echo "<Table><tr> 
				<td width=70><B>Energy (Kcals)</B></td> 
				<td width=70><B>Protein (g)</B></td> 
				<td width=70><B>Fat (g)</B></td> 
				<td width=70><B>Carbo (g)</B></td> 
				<td width=70><B>Calcium (g)</B></td> 
				<td width=70><B>Iron (mg)</B></td> 
				<td width=70><B>Sodium (mg)</B></td> 
				<td width=70><B>VitA (mmg)</B></td> 
				<td width=70><B>VitC (mg)</B></td></tr> ";

//get the input from the form
//note the input amounts SHOULD be tested for numeric values, since that is all they should be
//I'll do the first two for you

if (is_numeric(isset($_POST['cornamount']))){
	$fa0 = $_POST['cornamount'];
	$sql_where .= " where food = 'Cornflakes' ";
}else{
  $fa0 = 0;
}

if (is_numeric(isset($_POST['food1amount']))){
	$fa1  = $_POST['food1amount'];
	if (isset($sql_where)){
	  $sql_where .= " and food = 'Weetabix'";
  }else{
  	$sql_where .= " where food = 'Weetabix' ";
  }
}else{
  $fa1 = 0;
}

if (is_numeric(isset($_POST['food2amount']))){
	$fa2  = $_POST['food2amount'];
	if (isset($sql_where)){
	  $sql_where .= " and food = 'Muesli'";
  }else{
  	$sql_where .= " where food = 'Muesli' ";
  }
}else{
  $fa2 = 0;
}

if (is_numeric(isset($_POST['food3amount']))){
	$fa3  = $_POST['food3amount'];
	if (isset($sql_where)){
	  $sql_where .= " and food = 'Porridge'";
  }else{
  	$sql_where .= " where food = 'Porridge' ";
  }
}else{
  $fa3 = 0;
}

if (is_numeric(isset($_POST['food4amount']))){
	$fa4  = $_POST['food4amount'];
	if (isset($sql_where)){
	  $sql_where .= " and food = 'Milk'";
  }else{
  	$sql_where .= " where food = 'Milk' ";
  }
}else{
  $fa4 = 0;
}

if (is_numeric(isset($_POST['food5amount']))){
	$fa5  = $_POST['food5amount'];
	if (isset($sql_where)){
	  $sql_where .= " and food = 'Sugar'";
  }else{
  	$sql_where .= " where food = 'Sugar' ";
  }
}else{
  $fa5 = 0;
}

$query = "SELECT * FROM breakfast ".$sql_where; 
$result = mysql_query ($query) or die ("Can't complete query because ".mysql_error()); 
//we get a result
if ($result){
  //place the results into an array
	while ($rows=mysql_fetch_array($result)){
		$Food[]      = $rows['Food'];
		$Energy[]  = $rows['Energy'];
		$Protein[] = $rows['Protein'];
		$Fat[]     = $rows['Fat'];
		$Carbo[]   = $rows['Carbo'];
		$Calcium[] = $rows['Calcium'];
		$Iron[]    = $rows['Iron'];
		$Sodium[]  = $rows['Sodium'];
		$VitA[]    = $rows['VitA'];
	  $VitC[]    = $rows['VitC'];

	}

 //calc the results
 for($x=0;$x<$count;$x++){
   if ($fa$x!=0){
      $ttl_en = $Energy[$x] * $fa$x;
   		$ttl_pro = $Protien[$x] * $fa$x;
   		$ttl_fat = $Fat[$x] * $fa$x;
   		$ttl_car = $Carbo[$x] * $fa$x;
   		$ttl_cal = $Calcium[$x] * $fa$x;
   		$ttl_iro = $Iron[$x] * $fa$x;
   		$ttl_sod = $Sodium[$x] * $fa$x;
   		$ttl_va  = $VitA[$x} * $fa$x;
      $ttl_vc  = $VitC[$x] * $fa$x;

    	echo "<tr><td>".$Food[$x]."
						<td width=70>$ttl_en </td> 
						<td width=70>$ttl_pro</td> 
						<td width=70>$ttl_fat</td> 
						<td width=70>$ttl_car</td> 
						<td width=70>$ttl_cal</td> 
						<td width=70>$ttl_iro</td> 
						<td width=70>$ttl_sod</td> 
						<td width=70>$ttl_va </td> 
						<td width=70>$ttl_vc </td>
						</tr> ";
}

function show_form()
{


// Set the page title and include the HTML header. 
$page_title = 'Select the food amounts'; 
include_once ('templates/header.inc'); 

$dbcnx = @mysql_connect(); 
if(!$dbcnx) { 
echo("<P>Unable to connect to the server</P>"); 
exit(); 
} 

//select the food database 
if(! @mysql_select_db("Foods")) { 
echo("<P>Unable to locate the food database</P>"); 
exit(); 
} 


$query = "SELECT * FROM breakfast"; 
echo "<br><form name=\"foodtest\" action=\"".$_SERVER['PHP_SELF']."\" method=\"POST\">
			<table border=\"1\" cellspacing=\"3\" cellpadding=\"3\" align=\"center\"><tr>"; 

// Display all the URLs. 
$result = mysql_query ($query) or die ("Can't complete query because ".mysql_error()); 
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) { 

// Display each record. 
echo "<td>{$row['Food']}</td>"; 

} // End of while loop. 

echo '</tr>'; // Close the table row. 
echo '<tr><td><input type=text name=cornamount></td>'; 
echo '<td><input type=text name=food1amount></td>'; 
echo '<td><input type=text name=food2amount></td>'; 
echo '<td><input type=text name=food3amount></td>'; 
echo '<td><input type=text name=food4amount></td>'; 
echo '<td><input type=text name=food5amount></td></tr></table><br>'; 

echo '<INPUT TYPE=SUBMIT NAME="calc" VALUE="calc"></FORM>'; 
}//end show_form function

include_once ('templates/footer.inc'); // Require the HTML footer. 

?> 
</BODY> 
</HTML>