checkboxes

[Ammaar]

i have a php script that shows a list of records of people who have not been sent an information pack.
each record on the list has a checkbox next to it that I can tick off when an information pack has been sent to them.
what i want to do next is check which records have been ticked off on this list.
so when the user clicks the submit button the database is updated

heres my code so far:

viewInfoPackList.php

<?php
include("dbconnect.php");
$_POST['view']=$view;
echo "<h2>View Information Pack List</h2>";

if ($view == "View"){
  $results = mysql_query("SELECT * FROM Contact WHERE informationPack = 'no'") or die(mysql_error());
  echo "<form method=\"POST\" action=\"updateInfoPackList.php\">";
  echo "<table border= \"1\">\n";
  echo "<tr>\n";
  echo "<td>Contact ID</td>\n";
  echo "<td>Name</td>\n";
  echo "<td>Surname</td>\n";
  echo "<td>DoB</td>\n";
  echo "<td>Address</td>\n";
  echo "<td>Tel No.</td>\n";
  echo "<td>Email</td>\n";
  echo "<td>Information Pack</td>\n";
  echo "</tr>\n";
  $ids = new array();
  while ($row = mysql_fetch_array($results)){
    array_push($row["contactID"]);
    echo "<tr>\n";
    echo "<td>";
    echo $row["contactID"];
    echo "</td>\n";
    echo "<td>";
    echo $row["firstname"];
    echo "</td>\n";
    echo "<td>";
    echo $row["surname"];
    echo "</td>\n";
    echo "<td>";
    echo $row["DoB"];
    echo "</td>\n";
    echo "<td>";
    echo $row["address"];
    echo "</td>\n";
    echo "<td>";
    echo $row["telNumber"];
    echo "</td>\n";
    echo "<td>";
    echo $row["email"];
    echo "</td>\n";
    echo "<td>";
    echo "<input type=\"checkbox\" name=";
    echo $row["contactID"];
    echo " value=\"ON\">\n";
    echo "</td>\n";
  }
  echo "</table>\n";
  echo "<br>\n";
  echo "<input type=\"submit\" value=\"Submit\" name=\"submit\">\n";
  echo "</form>";
  mysql_free_result($results);
}
?>

updateInfoPackList.php i[/i]

<?php
include("dbconnect.php");
$_POST['submit']=$Submit;
$_POST[$ids]=$ids;
$id_size = count($ids);

if ($submit == "Submit"){
  for($ii=0;$ii>=$id_size;$ii++){
    if(<check whether checkbox is ticked or not in here>){
      mysql_query("<update database>") or die(mysql_error());
    }
  }
}
?>

[sfullman]

Some helpful pointers:

1. why in the world to you use ECHO to write everything? Way too hard, see this:

<?php
//query here


?>
<table cellspacing="2" ...>
<?php
//now we declare the rows:
while($r=mysql_fetch_array($result)){
extract($r); //gets everything into variables
$i++; //if you want alternating colors you have integer available
?>
<tr>
<td> CHECK BOX HERE</td>
<td><?php echo $FirstName. ' '.$LastName?></td>
<td><?php echo $whatever_else?></td>
<td><?php echo $whatever_else?></td>
</tr>
<?
}
?>
</table>

//2. here's what I'd suggest for the checkbox:

 
<input type=checkbox name=infoPacket[<?php echo $id_whatever?>] value=1>

Since you're looking for a status of "NO" I won't go into how things should include "checked" in the tag.

When you get the post do this:

 
if(is_array($infoPacket)){
 foreach($infoPacket as $n=>$v){
  $sql="UPDATE table set infoPacket='yes' WHERE ID = '$n'";
  //now execute query

 }

}

[Ammaar]

Originally posted by sfullman

Since you're looking for a status of "NO" I won't go into how things should include "checked" in the tag.

I got the previous one working but now I now need to do exactly what you said above for another script that i'm writing. since im on a deadline i havent changed all the echo's but i'll bear in mind for the future what you said earlier

Anyway, here are the scripts:
viewRespondList.php

<?php
include("dbconnect.php");

$results = mysql_query("SELECT * FROM Contact,Enquiry WHERE (Enquiry.live = 'yes') AND (Contact.contactID = Enquiry.contactID)") or die(mysql_error());
echo "<form method=\"POST\" action=\"updateRespondList.php\">";
echo "<table border= \"1\">\n";
echo "<tr>\n";
echo "<td>Contact ID</td>\n";
echo "<td>Name</td>\n";
echo "<td>Surname</td>\n";
echo "<td>DoB</td>\n";
echo "<td>Address</td>\n";
echo "<td>Tel No.</td>\n";
echo "<td>Email</td>\n";
echo "<td>Live Enquiry:Yes/No?</td>\n";
echo "</tr>\n";
while ($row = mysql_fetch_array($results)){
  echo "<tr>\n";
  echo "<td>";
  echo $row["contactID"];
  echo "</td>\n";
  echo "<td>";
  echo $row["firstname"];
  echo "</td>\n";
  echo "<td>";
  echo $row["surname"];
  echo "</td>\n";
  echo "<td>";
  echo $row["DoB"];
  echo "</td>\n";
  echo "<td>";
  echo $row["address"];
  echo "</td>\n";
  echo "<td>";
  echo $row["telNumber"];
  echo "</td>\n";
  echo "<td>";
  echo $row["email"];
  echo "</td>\n";
  echo "<td>";
  //$enquiries[$row["enquiryID"]];
  ?>
  <input type="checkbox" name= liveEnquiry[<?php echo $row["enquiryID"];?>] value="TRUE" checked>
  <?php echo "</td>\n";
}
echo "</table>\n";
echo "<br>\n";
echo "<input type=\"submit\" value=\"Submit\" name=\"submit\">\n";
echo "</form>";
mysql_free_result($results);
?>

updateRespondList.php

<?php
include("dbconnect.php");
$_POST['submit']=$Submit;

if($submit == "Submit"){
  if(is_array($liveEnquiry)){ 
    foreach($liveEnquiry as $n=>$v){
	if($n == FALSE){
		$staffID = $_SESSION['staffID'];
		$history = "INSERT INTO History (Details,timeStamp,applicationID,staffID,enquiryID,contactID) VALUES ('enquiryResponse',NOW( ),NULL,'$staffID','$n','$n')";
      	$update="UPDATE EnquirySET live = 'no' WHERE enquiryID = '$n'";
      	mysql_query($update) or die(mysql_error());
		mysql_query($history) or die(mysql_error());
	}	
    } 
  }
  include("viewRespondList.php");
}
?>

Thanks for all your help 🙂

[sfullman]

well the checked part is easy, just put this in your checkbox tag:

<?php echo $liveEnquery=='yes'?'checked':''?>

But also remember that an unchecked checkbox, when submitted, is treated as if it didn't exist. Therefore, you have to know all the possible checkboxes present on the server side. Suppose you have a checkbox named myEnquiry, value = yes -- If the user uncheckes it, $myEnquiry won't have a value of blank, it WON'T BE SET AT ALL. An important thing to keep in mind with checkboxes

Sam

[Ammaar]

Originally posted by sfullman
well the checked part is easy, just put this in your checkbox tag:

<?php echo $liveEnquery=='yes'?'checked':''?>

But also remember that an unchecked checkbox, when submitted, is treated as if it didn't exist. Therefore, you have to know all the possible checkboxes present on the server side. Suppose you have a checkbox named myEnquiry, value = yes -- If the user uncheckes it, $myEnquiry won't have a value of blank, it WON'T BE SET AT ALL. An important thing to keep in mind with checkboxes

Sam

So how do I know whether a checkbox is unchecked or not?

[sfullman]

Welll, obviously if they post it checked, the value will be in the form post. What I'm saying is, if checkboxes are dynamically generated and you don't necessarily know what checkboxes will be present, you need to list all checkboxes in some kind of hidden field with their default values, otherwise you won't know they exist. Just a word to the wise.

Sam