form problem

derksj

I am writing this code and i realy need some help

A user can check a checkbox if a call is private or not
How can i write this code that it parses and shows the checked "private checkboxes" and the amounts to control.php and shows a total amount of the checked "private checkboxes"

$sql  = "EXEC spPHPFiatCalls $persoonsid,$periode";
$result = mssql_query($sql,$connection);
$row = mssql_fetch_array($result); 

echo '
<form method="POST" action="control.php">		
<center><table border=0 width=100%>
<tr>
<td><p align=center><b>Mobilenumber</B></td>
<td><p align=center><b>time</B></td>
<td><p align=center><b>called number</B></td>
<td><p align=center><b>seconds</B></td>
<td><p align=center><b>amount</B></td>
<td><p align=center><b>Private call</B></td>
  </tr>';

  while ($row = mssql_fetch_array($result))
{
echo ' <tr><td><p align=center>'.$row["strMobNbr"].'</td>
	<td><p align=center>'.$row["dtmCallTime"].'</td>
	<td><p align=center>'.$row["strCalledNbr"].'</td>
	<td><p align=center>'.$row["lngSeconds"].'</td>
	<td><p align=center>'.$row["curAmount"].'</td>
	<td><p align=center>
<input type="checkbox" name="prive[".$row["ID"]."] value=""></td>';
  }
  }

echo '</table><p><input type="submit" value="Ok" name="ok"><input type="reset" value="Wissen" name="wissen"></form>';

LordShryku

Change your checkboxes to this

It will create an array with the ID's checked. So on the next page, you reference the $POST['prive'] array. To get your count, you just use count($POST['prive'])

derksj

can i just code the following on control.php

<?php

echo '.$_POST['prive'].';

LordShryku

Using my suggestion? No.

You could do a print_r($_POST['prive']), and you'll see the results

derksj

i am learning
realy cool

there is this for each loop i can use
how should i use that with $_POST['prive']

LordShryku

I don't use foreach too much, but try this

for($i=0;$i<count($_POST['prive']);$i++) {
   echo $_POST['prive'][$i]."<br />";
}

derksj

works great
i hope you not get bored of me
only i still have one problem
now i see the id's but i want to see the amount listed in a row
and at the end of this row the total amount

laserlight

If you want to use LordShryku's code, it is somewhat more efficient to use:

$count = count($_POST['prive']);
for ($i=0; $i < $count; $i++) {
	echo $_POST['prive'][$i] . "<br />";
}

If you want to use foreach, then

foreach ($_POST['prive'] as $value) {
	echo $value . "<br />";
}

To find total amount, declare a variable for it and sum.
For example

$total = 0;
foreach ($_POST['prive'] as $value) {
	echo $value . "<br />';
	$total += $value;
}
echo "Total: " . $total;

That said, you should normally validate incoming variables.