update selected checkboxes to mysql database

JennaMay

I've spent most of the morning scouring the web for help on this but just seem to be getting more and more confused! I would be most grateful for anyone's help on this please.

Basically what I want to do is pull selected fields from a MySQL database which I have done using the following code...

===

$query = "SELECT dom_name FROM DOMAIN where status='ON HOLD'";
$result = mysql_query ($query);

$num_results = mysql_num_rows($result);

for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
?><input type = "checkbox" name = "array[]" />
<?
echo stripslashes($row["dom_name"]);

?>

I then want the user to be able to select one or more of the checkboxes and click on a button which will update each corresponding record in the database (i.e. update DOMAIN set status="off hold").

Any help anyone can give me on this would be much appreciated!

Thanks in advance

🙂

drew010

hi, you are very close. but here is my thought:

$query = "SELECT dom_name FROM DOMAIN where status='ON HOLD'";
$result = mysql_query ($query);

while($row = mysql_fetch_array($result))
{
    echo "<input type = \"checkbox\" name = \"array[$row['dom_name']]\" />
    echo stripslashes($row["dom_name"]);
}

then by doing the array that way on the page that they post to you can do this:

//...other code
$arr = $_POST['array'];
foreach($arr as $domain => $checked) {
    //debugging
    echo "Domain: $domain - Checked: $checked<br />";
}

that way you will have an array that will look like this:

$array['domain1.com'] = 'on';
$array['domain3.com'] = 'on';

so since you have the domain name as the key, it will be super easy to identify which domain names were checked. ones not checked will not be sent in the array.
hope that helps. feel free to get in contact if you need further assistance. either on here or thru chat. check my profile.

JennaMay

Thanks for this but I still seem to be having issues....

1) When i put the following code in my script I get an error "parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' ". I have checked the code many times but can't seem to spot the problem.

<= code =>

$query = "SELECT dom_name FROM DOMAIN where ipstag='ON HOLD'";
$result = mysql_query ($query);

while($row = mysql_fetch_array($result))
{
echo "<input type = \" checkbox\" name = \"array[$row["dom_name"]]\" />";
echo stripslashes($row["dom_name"]);
}

2) When i put the following code into the page I post to, i get "invalid argument supplied for foreach()".

<= code =>

mysql_select_db("projektdb");

$arr = $_POST['array'];
foreach($arr as $domain => $checked) {
//debugging
echo "Domain: $domain - Checked: $checked";
}

What am I doing wrong?! 🙂 Any help anyone can give me would soooo appreciated!

Thanks in advance.

drew010

the line
echo "<input type = \" checkbox\" name = \"array[$row["dom_name"]]\" />";
must be changed to
echo "<input type = \" checkbox\" name = \"array[{$row['dom_name']}]\" />";

if you still get invalid argument to foreach, try putting $_POST['array'] in it instead of assigning that to $arr like i said

JennaMay

Hi again!

Thanks - this works but the checkboxes have now changed into text boxes for some reason! any ideas?

No joy with the invalid argument bit

foreach($_POST['array'] as $domain => $checked) {
//debugging
echo "Domain: $domain - Checked: $checked";
}

makes no change. I meant to put this in my last post but could you pls explain what the first line does as I don't really understand what it does so makes debugging a little hard!!

Thanks so much for this.

drew010

Here is the code I made to test this:

<form method="POST">
<input type="checkbox" name="array[domain1.com]" />Domain 1<br />
<input type="checkbox" name="array[domain2.com]" />Domain 2<br />
<input type="checkbox" name="array[domain3.com]" />Domain 3<br />
<input type="checkbox" name="array[domain4.com]" />Domain 4<br />
<input type="checkbox" name="array[domain5.com]" />Domain 5<br />
<input type="submit" />
</form>

<br /><br />

<?php

if($_POST) {
	foreach($_POST['array'] as $domain => $checked) {
		echo "Domain: $domain - $checked<br />\n";
	}
}

?>

checking boxes 1, 3, and 5 will result in this output:

Domain: domain1.com - on
Domain: domain3.com - on
Domain: domain5.com - on