Databases
StackOverflow2013
Postsdbo
POPresenting/editing checkbox values?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPresenting/editing checkbox values?
    primarykey
    data
    text
    <p>Hi this is baffling me because the checkboxes are in a form with textboxes also. I enter the following into the database as a new record:</p> <pre><code>&lt;form action="processmem.php" method="post"&gt; &lt;table width="800" align="center"&gt; &lt;tr&gt; &lt;td width="99" height="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;td width="100" height="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;td width="100" height="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;td width="100" height="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;td width="100" height="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;td width="100" height="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;td width="100" height="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;td width="100" height="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="3" align="right" height="30"&gt; Name&amp;nbsp;&amp;nbsp; &lt;/td&gt; &lt;td colspan="2" align="left"&gt; &lt;input type="text" name="textfield[childname]" /&gt; &lt;/td&gt; &lt;td colspan="3"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="3" align="right" height="30"&gt; Age&amp;nbsp;&amp;nbsp; &lt;/td&gt; &lt;td colspan="2" align="left"&gt; &lt;input type="text" name="textfield[age]" /&gt; &lt;/td&gt; &lt;td colspan="3"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="3" align="right" height="30"&gt; Parent Name&amp;nbsp;&amp;nbsp; &lt;/td&gt; &lt;td colspan="2" align="left"&gt; &lt;input type="text" name="textfield[parentname]" /&gt; &lt;/td&gt; &lt;td colspan="3"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="3" align="right" height="30"&gt; Email Address&amp;nbsp;&amp;nbsp; &lt;/td&gt; &lt;td colspan="2" align="left"&gt; &lt;input type="text" name="textfield[email]" /&gt; &lt;/td&gt; &lt;td colspan="3"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="3" align="right" height="30"&gt; Contact Number&amp;nbsp;&amp;nbsp; &lt;/td&gt; &lt;td colspan="2" align="left"&gt; &lt;input type="text" name="textfield[contactno]" /&gt; &lt;/td&gt; &lt;td colspan="3"&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="8" height="30"&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td height="15" colspan="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;td colspan="3" align="right"&gt;&amp;nbsp;&amp;nbsp;&lt;/strong&gt; Check box if this member is a Ninja! &lt;/td&gt; &lt;td align="center"&gt; &lt;input type="checkbox" name="checkbox[ninja]" value="checkbox" /&gt; &lt;/td&gt; &lt;td colspan="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="8" height="30"&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td height="15" colspan="2"&gt;&amp;nbsp;&lt;/td&gt; &lt;td colspan="4" align="center"&gt; Which subjects has this member attended? &lt;/td&gt; &lt;td colspan="2"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td height="5" colspan="8"&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td height="15"&gt;&amp;nbsp;&lt;/td&gt; &lt;td colspan="2" align="center"&gt;Scratch&lt;/td&gt; &lt;td colspan="2" align="center"&gt;App Inventor&lt;/td&gt; &lt;td colspan="2" align="center"&gt;HTML&lt;/td&gt; &lt;td&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td height="15"&gt;&amp;nbsp;&lt;/td&gt; &lt;td colspan="2" align="center"&gt; &lt;input type="checkbox" name="checkbox[scratch]" value="checkbox" /&gt; &lt;/td&gt; &lt;td colspan="2" align="center"&gt; &lt;input type="checkbox" name="checkbox[appInventor]" value="checkbox" /&gt; &lt;/td&gt; &lt;td colspan="2" align="center"&gt; &lt;input type="checkbox" name="checkbox[html]" value="checkbox" /&gt; &lt;/td&gt; &lt;td&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; </code></pre> <p>It's execeuted by this script:</p> <pre><code>&lt;?php include("connect.php"); require_once("logincheck.php"); if(isset($_POST)){ $childname=mysql_real_escape_string($_POST['textfield']['childname']); $age=mysql_real_escape_string($_POST['textfield']['age']); $parentname=mysql_real_escape_string($_POST['textfield']['parentname']); $email=mysql_real_escape_string($_POST['textfield']['email']); $contactno=mysql_real_escape_string($_POST['textfield']['contactno']); $ninja=isset($_POST['checkbox']['ninja'])?'yes':'no'; $scratch=isset($_POST['checkbox']['scratch'])?'yes':'no'; $appinventor=isset($_POST['checkbox']['appinventor'])?'yes':'no'; $html=isset($_POST['checkbox']['html'])?'yes':'no'; $sql="INSERT INTO tblmembers (childname, age, parentname, email, contactno, ninja, scratch, appinventor, html) VALUES ('$childname','$age','$parentname','$email','$contactno', '$ninja','$scratch','$appinventor','$html')";mysql_query($sql) or die (mysql_error()); } </code></pre> <p>This all works fine, but I cannot see the value of the checkboxes if I query the record later, as here:</p> <pre><code>$id=$_GET["id"]; $sql="SELECT * from tblmembers WHERE id=".$id; $result=mysql_query($sql); $rows=mysql_num_rows($result); while($row =mysql_fetch_array($result)) { $childname=$row["childname"]; $id=$row["id"]; $age=$row["age"]; $parentname=$row["parentname"]; $email=$row["email"]; $contactno=$row["contactno"]; $ninja=$row["checkbox"]["ninja"]; $scratch=$row["checkbox"]["scratch"]; $appinventor=$row["checkbox"]["appInventor"]; $html=$row["checkbox"]["html"]; print "&lt;p align=\"center\"&gt;&lt;strong&gt;&lt;i&gt;Information for $childname&lt;/i&gt;&lt;strong&gt;&lt;/p&gt;&lt;br&gt;"; print "&lt;table width=\"800\" align=\"center\"&gt;"; print "&lt;tr&gt;"; print "&lt;td width=\"99\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"3\" align=\"right\" height=\"30\"&gt;Name&amp;nbsp;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"left\"&gt;&lt;input type=\"text\" name=\"textfield[childname]\" value='".$childname."'/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"3\"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"3\" align=\"right\" height=\"30\"&gt;Age&amp;nbsp;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"left\"&gt;&lt;input type=\"text\" name=\"textfield [age] "value='".$age."'/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"3\"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"3\" align=\"right\" height=\"30\"&gt;Parent Name&amp;nbsp;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"left\"&gt;&lt;input type=\"text\" name=\"textfield[parentname]\" value='".$parentname."'/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"3\"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"3\" align=\"right\" height=\"30\"&gt;Email Address&amp;nbsp;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"left\"&gt;&lt;input type=\"text\" name=\"textfield[email]\" value='".$email."'/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"3\"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"3\" align=\"right\" height=\"30\"&gt;Contact Number&amp;nbsp;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"left\"&gt;&lt;input type=\"text\" name=\"textfield[contactno]\" value='".$contactno."'/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"3\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"8\" height=\"30\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td height=\"15\" colspan=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"3\" align=\"right\"&gt;&amp;nbsp;&amp;nbsp;&lt;/strong&gt;Check box if this member is a Ninja!&lt;/td&gt;"; print "&lt;td align=\"center\"&gt;&lt;input type=\"checkbox\" name=\"checkbox[ninja]\" value=$row [\"ninja\"]/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"8\" height=\"30\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td height=\"15\" colspan=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"4\" align=\"center\"&gt;Which subjects has this member attended?&lt;/td&gt;"; print "&lt;td colspan=\"2\"&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td height=\"5\" colspan=\"8\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td height=\"15\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;Scratch&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;App Inventor&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;HTML&lt;/td&gt;"; print "&lt;td&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td height=\"15\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;&lt;input type=\"checkbox\" name=\"checkbox[scratch]\" value='".$scratch."' /&gt;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;&lt;input type=\"checkbox\" name=\"checkbox[appInventor] \" value='".$appinventor."' /&gt;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;&lt;input type=\"checkbox\" name=\"checkbox[html]\" value='".$html."' /&gt;&lt;/td&gt;"; print "&lt;td&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;/table&gt;"; } ?&gt; </code></pre> <p>Finally - obviously if I cannot see that a checkbox was checked on entering the database, I cannot edit it or update the record. This is what I'm using for this:</p> <pre><code>$id=$_GET["id"]; include("connect.php"); require_once("logincheck.php"); if($_GET["function"]=='update') { $childname=mysql_real_escape_string($_POST['textfield']['childname']); $age=mysql_real_escape_string($_POST['textfield']['age']); $parentname=mysql_real_escape_string($_POST['textfield']['parentname']); $email=mysql_real_escape_string($_POST['textfield']['email']); $contactno=mysql_real_escape_string($_POST['textfield']['contactno']); $ninja=isset($_POST['checkbox']['ninja'])?'yes':'no'; $scratch=isset($_POST['checkbox']['scratch'])?'yes':'no'; $appinventor=isset($_POST['checkbox']['appinventor'])?'yes':'no'; $html=isset($_POST['checkbox']['html'])?'yes':'no'; $sql2="UPDATE tblmembers SET childname='".$childname."',age='".$age."',parentname='".$parentname."', email='".$email."',contactno='".$contactno."',ninja='".$ninja."',scratch='".$scratch."', appinventor='".$appinventor."',html='".$html."' WHERE id=".$id; mysql_query($sql2) or die (mysql_error()); print "&lt;strong&gt;The member details have been saved. Thank you.&lt;/strong&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;"; } else { $sql="SELECT * from tblmembers WHERE id=".$id; $result = mysql_query ($sql) or die(mysql_error()); $rows=mysql_num_rows($result); while($row =mysql_fetch_array($result)) { $childname=$row["childname"]; $id=$row["id"]; $age=$row["age"]; $parentname=$row["parentname"]; $email=$row["email"]; $contactno=$row["contactno"]; $ninja=$row["ninja"]; $scratch=$row["scratch"]; $appinventor=$row["appInventor"]; $html=$row["html"]; print "&lt;form method=post action='editmember.php?function=update'&gt;"; print "&lt;table width=\"800\" align=\"center\"&gt;"; print "&lt;tr&gt;"; print "&lt;td width=\"99\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td width=\"100\" height=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"3\" align=\"right\" height=\"30\"&gt;Name&amp;nbsp;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"left\"&gt;&lt;input type=\"text\" name=\"textfield[childname]\" value='".$childname."'/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"3\"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"3\" align=\"right\" height=\"30\"&gt;Age&amp;nbsp;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"left\"&gt;&lt;input type=\"text\" name=\"textfield[age]\" value='".$age."'/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"3\"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"3\" align=\"right\" height=\"30\"&gt;Parent Name&amp;nbsp;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"left\"&gt;&lt;input type=\"text\" name=\"textfield[parentname]\" value='".$parentname."'/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"3\"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"3\" align=\"right\" height=\"30\"&gt;Email Address&amp;nbsp;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"left\"&gt;&lt;input type=\"text\" name=\"textfield[email]\" value='".$email."'/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"3\"&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"3\" align=\"right\" height=\"30\"&gt;Contact Number&amp;nbsp;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"left\"&gt;&lt;input type=\"text\" name=\"textfield[contactno]\" value='".$contactno."'/&gt;&lt;/td&gt;"; print "&lt;td colspan=\"3\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"8\" height=\"30\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td height=\"15\" colspan=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"3\" align=\"right\"&gt;&amp;nbsp;&amp;nbsp;&lt;/strong&gt;Check box if this member is a Ninja!&lt;/td&gt;"; print "&lt;td align=\"center\"&gt;&lt;input type=\"checkbox\" name=\"checkbox[ninja]\" value='".$ninja."' /&gt;&lt;/td&gt;"; print "&lt;td colspan=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td colspan=\"8\" height=\"30\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td height=\"15\" colspan=\"2\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"4\" align=\"center\"&gt;Which subjects has this member attended?&lt;/td&gt;"; print "&lt;td colspan=\"2\"&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td height=\"5\" colspan=\"8\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td height=\"15\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;Scratch&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;App Inventor&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;HTML&lt;/td&gt;"; print "&lt;td&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td height=\"15\"&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;&lt;input type=\"checkbox\" name=\"checkbox[scratch]\" value='".$scratch."' /&gt;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;&lt;input type=\"checkbox\" name=\"checkbox[appInventor] \" value='".$appinventor."' /&gt;&lt;/td&gt;"; print "&lt;td colspan=\"2\" align=\"center\"&gt;&lt;input type=\"checkbox\" name=\"checkbox[html]\" value='".$html."' /&gt;&lt;/td&gt;"; print "&lt;td&gt;&amp;nbsp;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;tr&gt;"; print "&lt;td&gt;&lt;input type=hidden name=id value=".$id."&gt;&lt;br&gt;&lt;/td&gt;"; print "&lt;td colspan=\"4\" align=\"center\"&gt;&lt;input type=submit value='&amp;nbsp;Save&amp;nbsp;'&gt;&lt;/td&gt;&lt;/form&gt;"; print "&lt;td td colspan=\"4\" align=\"center\"&gt;&lt;form method='post' name='Cancel' action='memberinfo.php?id=".$id."'&gt;&lt;input type='submit' value='&amp;nbsp;Cancel&amp;nbsp;'&gt;&lt;/form&gt;&lt;/td&gt;"; print "&lt;/tr&gt;"; print "&lt;/table&gt;"; } } ?&gt; </code></pre> <p>I hope someone can help! I've gotten great help here before and I am very much a beginner with PHP. Please forgive typos or errors. </p> <p>I need to be able to display a record as entered, then go in, EDIT and SAVE updated record to the DB. Thanks in advance... </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USf605dcf7dc5542e93ae9cd76f
    1. USGoozer16
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POPresenting/editing checkbox values?
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POPresenting/editing checkbox values?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POPresenting/editing checkbox values?
      1. This table or related slice is empty.
      1. VTDownMod
    1. COYour code seems to have a lot of extra stuff in there that are not really necessary for your question, is there a way you can simplify your code? Possibly only include a single checkbox or table row. I'm too lazy to sift through all that code to figure out what's going on and which parts actually matter when you could probably illustrate the same problem with only a few lines of relevant code instead.
      singulars
      1. POPresenting/editing checkbox values?
      1. USLochemage
    2. COuse PDO forget the mysql extension.
      singulars
      1. POPresenting/editing checkbox values?
      1. USSongo
    3. COI'll abbreviate this code in the hope of getting some help. The issue is in actually displaying a checked checkbox. When it is checked on submission of the form, it populates the database correctly but just won't show when another form queries the database for the record.
      singulars
      1. POPresenting/editing checkbox values?
      1. USGoozer16
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload