Updating via Checkboxes

kbc1

Hi all,

I am retrieving checkbox value data from my database, storing the values into an array and then 'checking' the appropriate checkboxes on screen if their ID's exist within my array. (My checkboxes are dynamically displayed according to how many results i get from my query)

This is working great. When I tick/check an 'unchecked' box and click to Save, I run this code to update my database which works fine:

if (isset($_POST['appselected'])) {
	$centreid = $_POST['cid'];
	$valueids= $_POST['appselected']; 

foreach ($valueids as $said) { 
	$sqlquery = "UPDATE mytable SET statusid = '4' WHERE myid= '$said' AND centreid = $centreid"; 
	$result = mysql_query($sqlquery);
	}

Now this is fine, but what I would like to do is to be able to 'uncheck' a ticked box at the same time and when I click the Save button, the page will update the statusid value within the database to be lets say '2'.

How is this achieveable? How do i detect which ones to update to statusid 4 and which ones to statusid 2 at the same time?

Thanks in advance.

devinemke

store all of the displayed checkboxes in an array (either in a session or as a hidden form field). when the form is submitted only the checked boxes will be returned. rather than loop thru the returned checkbox array, loop thru the array of all checkboxes. on each loop iteration use [man]in_array[/man] to see if the box is in the array of returned boxes. if it is then UPDATE statusid = '4', if not then UPDATE statusid = '2'.

kbc1

Some guidance with the PHp would be greatly appreciated..

Here I will store the checked records into my session array:

		
$approvalquery = "SELECT DISTINCT field FROM mytable  WHERE centreid = $centreid AND statusid = 4 GROUP BY field";
$searchresult = mysql_query($approvalquery);
while ($_SESSION['S_APPROVAL_IDS'][] = mysql_fetch_array($searchresult)) {
}
mysql_free_result($searchresult);

So the records which match the Query criteria I now need to display on screen.

Is this correct?

		if (in_array($myids, $_SESSION['S_APPROVAL_IDS'])) {
			// if the ID is found within the array, it means it is checked...

		$checkbox = "<input checked name=\"appselected\" type=\"checkbox\" class=\"appcheckbox\" value=\"1\" onclick=\"do stuff...\" />";
	} else {

		$checkbox = "<input name=\"appselected\" type=\"checkbox\" class=\"appcheckbox\" value=\"1\" onclick=\"do stuff..\" />";
	}

I think It is wrong...

Any suggestion would be greatly appreciated.
K

devinemke

i'm not quite understanding your underlying data structure here. is "field" the name of the primary key field in "mytable"? i guess it's not since you are using the DISTINCT keyword in your SELECT query. if it's not the PK field then what is it? a boolean field of some sort?

kbc1

Here is the full query:

// store the ID's of the records which should be displayed as 'ticked' checkboxes...	
$approvalquery = "SELECT DISTINCT approvalid FROM tblapprovals WHERE centreid = $centreid AND statusid = 4 GROUP BY approvalid";
$searchresult = mysql_query($approvalquery, $_SESSION['S_REMOTE_DB']);
		while ($_SESSION['S_APPROVAL_IDS'][] = mysql_fetch_array($searchresult)) {
		}
    	mysql_free_result($searchresult);

The approvalid field is not a Primary Key.

Now I run a 2nd query which also selects the approvalid field (amongst others) but my php code looks like this:

while ($datarow = mysql_fetch_array($result)) {
  $approvalid = $datarow['approvalid'];
  // more values here but its not important...

 if (in_array($approvalid , $_SESSION['S_APPROVAL_IDS'])) {
// if the ID is found within the array, it means it is suspended...
		$checkbox = "<input checked name=\"appselected\" type=\"checkbox\" class=\"appcheckbox\" value=\"1\" onclick=\"CountSelectedApprovals(document.centreapprovals);\" />";
	} else {
		$checkbox = "<input name=\"appselected\" type=\"checkbox\" class=\"appcheckbox\" value=\"1\" onclick=\"CountSelectedApprovals(document.centreapprovals);\" />";
		}

So I am wanting to display ticked checkboxes if the $approvalid from my 2nd query exists in my SESSION array.

Phew!