[RESOLVED] Mysql and checkboxes

Pack

I have created a webpage which enables our website administrator to edit our customers. We sell approx 20 items which I have setup a checkbox per item.

I have created two tables one for the customer data and the other to hold the stock data which the customers stock.

I have created a script which inserts the stock for the customer but am having trouble in creating an edit page.

The edit page consists of check boxes which I would like checked if the customer stocks them. The administartor can then check or uncheck the stock items and update the table!

Has any one got any examples of popualting checkboxes from mysql?

Thanks for your help

benracer

you would use a foreach loop with an update statement...

// create connection
foreach($_POST['checkbox'] as $x){
// run update 
}

<input type="checkbox" name="checkbox[]" value="<?php $id; ?>" />

Pack

Thanks benracer for your reply.

I have used that script to update mysql but the problem is extracting the data from mysql to an array then to check or uncheck the cahckboxes..

For example the table may have 123, 234, 345.

I have created 3 check boxes called 123, 234, 345 so if the array has one of these present then the corresponding check box will be ticked!

Thanks

benracer

I think this would work...

<form action="update.php" method="post">
<?php
$connection = mysql_connect("host", "user","password");
mysql_select_db("user", $connection);

if(!$connection){
echo "<h4>Sorry, There Is An Error On Our Server<br>Please Check Back Later</h4>";
}

$query = "SELECT * FROM table";
$result = mysql_query($query) or die(mysql_error()); 
while($rows=mysql_fetch_array($result)){

echo "<input type=\"checkbox\" name=\"checkbox[]\" value=\"{$rows['id']}\" />";
}
echo "</form>";
?>

on update.php...

<?php
$connection = mysql_connect("host", "user","password");
mysql_select_db("user", $connection);

if(!$connection){
echo "<h4>Sorry, There Is An Error On Our Server<br>Please Check Back Later</h4>";
}
foreach($_POST['checkbox'] as $x){

$query = "UPDATE"; // fill in as needed
$result = mysql_query($query) or die(mysql_error()); 
}
header("location:index.php");
?>

laserlight

benracer, kindly indent your code examples to set a good example for those asking questions 🙂

Also, note that to comply with HTTP 1.1 the location header URL should be an absolute URL, not a relative URL like index.php.

EDIT:
I moved the somewhat off-topic replies to Location Headers and Forum Code Indentation.

Pack

Benracer
Thankyou for your reply.

I have tried your script but cannot get the check boxes checked when the data in the mysql database.

I would like a static 20 checkboxes but when the correlating data is in the database then that checkbox is checked..

benracer

Hi,
i do not understand what you are trying to achieve. What do the static boxes mean? Do you want some boxes to be checked or unchecked if so what would sort the unchecked to checked?

Pack

I have say 20 checkboxes on on the webpage which are always there.

The code you kindly provided creates the checkboxes due to the amount of data extracted from the database.
ie if there was 1 record then 1 checkbox will be created.

in the mysql query the column will retuen the names of the chackboxes so this will let you know that the checkbox needs to be checked or not.

id name
1 a1
2 a2

checkbox name a1 and a2 need to be checked

Hope this makes sense

BlueKai

The way I prepopulate checkboxes is this...

$res = mysql_query("select gender from users limit 1");
$row = mysql_fetch_assoc($res);

$f = "";
$m = "";
if ($row['gender'] == "F")
	$f = "checked";
else if ($row['gender'] == "M")
	$m = "checked";

echo "<form action='wherever.php' method='post'>
	f <input type='checkbox' {$f} />
	m <input type='checkbox' {$m} />
</form>";

benracer

The html to check a box is (checked="checked")

Pack

Thank you both for your replies.

I have now a solution working by using bits of both of your code 🙂

hellmyster

I'm still new at this, and I think i need a bit more of an explanation.
I have several checkboxes in my database indicating a selection of properties about an item. My admin selects these properties when he/she creates these items. When my admin goes back later and wishes to edit these entries, i would like the true/false values from the checkboxes to be passed from my view_list page to the edit page so that any checked boxes will still be checked on the edit page.