Checked Boxes in PHP form
Posted: Mon Nov 29, 2010 12:26 am
I have a form that allows users to pull up info and check what they want added to the site. How can I change my form so that when a user comes back to the site and enters the info, what has already been added to the DB is checked and what hasn't been added is not checked? Currently when they come back to the site all boxes are left unchecked. Here is my code.
ScrollRead.php
ScrollReadGet.php
ScrollRead.php
Code: Select all
</script>
<script type='text/javascript'>
checked=false;
function checkAll () {
var aa= document.getElementById('lomp');
if (checked == false)
{
checked = true
}
else
{
checked = false
}
for (var i =0; i < aa.elements.length; i++)
{
aa.elements[i].checked = checked;
}
}
</script>
<table border=1px>
<tr>
<th>Image</th>
<th>id</th>
<th>stolen/bred on</th>
<th>parents</th>
<th>gender</th>
<th>type</th>
<th>clicks</th>
<th>views</th>
<th>unique views</th>
<th>hours left</th>
<th>add dragon</th></tr>
<form name="form1" id="lomp" method="get" action="ScrollReadGet.php">
<?php
ini_set("display_errors",false);
$fdd = $_POST['user'];
$user = str_replace(" ","%20","$fdd");
echo ''.$fdd.'';
echo '<input type=hidden value="'.$user.'" name=user><br>';
$young = unserialize(file_get_contents('http://dragcave.net/api/xxxx/serialize/user_young/'.$user.''));
foreach($young['errors'] as $error) {
if($error[0] == 3) {echo '<center>Sorry, we were unable to locate that scroll.</center>'; return;}
}
foreach($young['errors'] as $error) {
if($error[0] == 4) {echo '<center>Sorry, this user has no dragons.</center>'; return;}
}
foreach ($young['dragons'] as $key => $value) {
$data = unserialize(file_get_contents('http://dragcave.net/api/xxxx/serialize/view/'.$key));
echo '
<tr><td><a href="http://www.dragcave.net/view/'.$key.'"><img src="http://www.dragcave.net/image/'.$key.gif.'" border="0"></a></td>';
$data = array_pop($data['dragons']);
if($data['start'] == "0") echo "{$data['id']} is hidden!";
elseif($data['hoursleft'] == -2) echo "<td>{$data['id']} is dead!</td>";
else {
if($data['grow'] != 0) $type = "adult";
elseif($data['hatch'] != "0" && $data['hoursleft'] == -1) $type="frozen hatchling";
elseif($data['hatch'] != "0") $type="hatchling";
else $type="egg";
echo "<td>$key</td>";
echo "<td>{$data['start']}</td>";
echo "<td>Mother- <a href=\"http://www.dragcave.net/view/{$data['parent_f']}\" target=\"blank\">{$data['parent_f']}</a><br>Father- <a href=\"http://www.dragcave.net/view/{$data['parent_m']}\" target=\"blank\">{$data['parent_m']}</a></td>";
echo "<td>{$data['gender']}</td>";
echo "<td>{$type}</td>";
echo "<td>{$data['clicks']}</td";
echo "<td>{$data['views']}</td>";
echo "<td>{$data['unique']}</td>";
echo "<td>{$data['hoursleft']} hours</td>";
echo '<td><input type="checkbox" name="checkboxes[]" value="'.$key.'" border="0"></a></td>';
}
foreach ($data['clicks'] as $help => $me) {
echo '$help';
}
}
?>
</tr>
<td colspan="11"<input type='checkbox' name='checkz' onClick='checkAll();'>Check all/Uncheck all<br>
<input type="submit" name="Submit" class="button" value="Add Dragons"></td>
</tr>
</table>Code: Select all
<table>
<tr><td>
<?php
ini_set("display_errors",false);
$link = mysql_connect('xxxx', 'xxxx', 'xxxx',true); if (!$link) { die('Could not connect: ' . mysql_error()); }
mysql_select_db("thehatch_dragon") or die(mysql_error());
$ids=$_GET['checkboxes'];
$user = $_GET['user'];
$young = unserialize(file_get_contents('http://dragcave.net/api/xxxx/serialize/user/'.$user.''));
foreach ($young['dragons'] as $key => $value) {
$querya = "DELETE FROM hatch WHERE code='$key'";
$queryb = "DELETE FROM er WHERE code='$key'";
$queryc = "DELETE FROM egg WHERE code='$key'";
mysql_query($querya);
mysql_query($queryb);
mysql_query($queryc);
}
echo 'Dragons updated. --<br> ';
echo 'Dragons now entered:<br>';
foreach ($ids as $hey) {
echo '<a href="http://www.dragcave.net/view/'.$hey.'" target="frame1"><img src="http://www.dragcave.net/image/'.$hey.'.gif" border="0"></a></ >';
$data = unserialize(file_get_contents('http://dragcave.net/api/xxxx/serialize/view/'.$hey.''));
$hrsleft = $data['dragons'][$hey]['hoursleft'];
$hatch = $data['dragons'][$hey]['hatch'];
if ($hrsleft < 96) {
$query3 = "INSERT INTO er(code, user) VALUES('$hey', '$user')";
mysql_query($query3);
echo '=>in ER.<br>';
}
else
{
if (! $hatch) {
$query4 = "INSERT INTO egg(code, user) VALUES('$hey', '$user')";
mysql_query($query4);
echo '=>in Nest.<br>';
}
else
{
$query2 = "INSERT INTO hatch(code, user) VALUES('$hey', '$user')";
mysql_query($query2);
echo '=>in Nursery.<br>';
}
}
}
?>
</td></tr>
</table>
<= <a href="main.php" target="mainview">Back</a>