Showing Checkboxes from db..

joey3002

I am trying display a bunch of check boxes from a database (this part works) the user can then click the boxes and save them to their user preferences (this part works as well) But when i am displaying all the options, I would like the user to see which groups are checked by automatically checking the items he has in his db.

here is my code:

<html>
<head>
<title>Web Interface</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>

<?
require("database.inc.php");
dbconnect();
$keyword = $_POST["search"];

$query = "SELECT ng_id,group FROM groups WHERE group like '%$keyword%' limit 10";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
if($num_rows == 0) {
echo "No results<BR>\n";
} else {
while($row = mysql_fetch_array($result)) {
?>
<form name=checks action=checkboxs.php method=post>
<input type="checkbox" name="checks[]" value="<?php echo $row['0']; ?>" > <?php echo $row['1']; ?><BR>
<?PHP
}
echo" <input type=submit value=Save>";
}

?>
</body></html>

jabi

You will need to query your user table to see which fields he/she has selected. Then, match them to the new checkbox fields. If it is already selected, put the " checked" statement in the input field.

Without knowing how you have the database set up, I can only give you the logic for this, not actual working code.

<input type="checkbox" name="checks[]" value="<?php echo $row['0']; if($user_checkbox_name_matches this) echo " checked";?>" > <?php echo $row['1'];

joey3002

this returns a parse error.

planetsim

You probably want it like this


<input type="checkbox" name="checks[]" value="<?php echo $row['0']; ?>" <?php if (isset($_POST['checks']['0']) { echo "checked=\"checked\"; ?>>

You will probably need to change that to suit what you need to do.

joey3002

i get a parse error with that, i have isolated it to:

<?php if (isset($_POST['checks']['0']) { echo "checked=\"checked\"; ?>

that part of the above line..

planetsim

My Mistake forgot to have } and ) in if

<input type="checkbox" name="checks[]" value="<?php echo $row['0']; ?>" <?php if (isset($_POST['checks']['0'])) { echo "checked=\"checked\""; }?>>

joey3002

heh, that worked to get rid of the parse error, but i still do see the ones from the db that are stored.

It is saving into the db correctly just not re-checking the ones that were check before..

thanks btw for all your help

joey3002

can someone please assist.. im going on about 5 hours now and about to start rocking in my chair..