Updating database checkbox problem

genista

Hi,

I have a form that lest a user update their details, and it has some checkboxes in it. The problem is that the following code producdes an undefined index on all the checkboxes in the script when they are not filled in:

$query = "UPDATE suppliers SET first_name='$first_name', last_name='$last_name', password='$password', address_line1='$address_line1', address_line2='$address_line2', town='$town' , county='$county', postcode='$postcode', daytime_phone='$daytime_phone', mobile_phone='$mobile_phone', email_address='$email_address', test1='$test1', test2='$test2', test3='$test3'";

$result=mysql_query($query) or die("Could not insert data.".mysql_error()); 

//$result represents the status of the operation true if it worked false if it failed 
if($result){ 
    print "Your details have been sucesfully updated. You can go back to the <a href=suppliers.php>index</a> page now."; 
}else{ 
    print "Could not update data."; 
}

What condition would I have to use in this query?

Thanks,

devinemke

unchecked checkboxes and not returned to the form processing script. a simple example:

<?php
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="POST">
	<input type="checkbox" name="boxes[]" value="1"> checkbox #1<br>
	<input type="checkbox" name="boxes[]" value="2"> checkbox #2<br>
	<input type="checkbox" name="boxes[]" value="3"> checkbox #3<br>
	<input type="submit" name="submit" value="submit">
	</form>
	';
}
else
{
	if (isset($_POST['boxes']))
	{
		echo 'you checked ' . implode(',', $_POST['boxes']);
	}
	else
	{
		echo 'you did not check any boxes';
	}
}
?>

genista

Hi the problem I have is that the code I need is in a form that validates the previous page, so there is no html in this page, what I have so far is not working however:

<?php	

if (!isset($_POST['submit'])) 


{ 
    if (isset($_POST['boxes'])) 
    { 
        echo 'you checked ' . implode(',', $_POST['boxes']); 
    } 
    else 
    { 
        echo 'you did not check any boxes'; 
    } 
}   

?> 
<?php

$query = "UPDATE suppliers SET first_name='$first_name', last_name='$last_name', password='$password', address_line1='$address_line1', address_line2='$address_line2', town='$town' , county='$county', postcode='$postcode', daytime_phone='$daytime_phone', mobile_phone='$mobile_phone', email_address='$email_address', checkbox1='$checkbox1', checkbox2='$checkbox2'"; 

    //now we pass the query to the database 




$result=mysql_query($query) or die("Could not insert data.".mysql_error()); 

//$result represents the status of the operation true if it worked false if it failed 
if($result){ 
    print "Your details have been sucesfully updated. You can go back to the <a href=suppliers.php>index</a> page now."; 
}else{ 
    print "Could not update data."; 
} 

//finally close the connection 
mysql_close(); 



?>

Thanks,

devinemke

my ealier post was just an example, nothing relating to your exact code. my point is that you need to run a check on the incoming POST data for the existience of certain fileds that may not exist (like uncheked checkboxes). this is typically done using [man]isset[/man].