php checkbox

[c_owl]

i have a website and i would like to add a checkbox for each record. so if i select the checkbox the page updates the database .

how can i do this please, not sure were to start


regards craig

[kows]

you'll have to be a bit more descriptive about what you already have done and what you're actually trying to do. post some of your code.

also -- step 1: make a checkbox.

<input type="checkbox" name="myCheckbox" value="myCheckboxValue" />

[c_owl]

hi kows
i used your posted and now i have a checkbox on my page There is now text next to it and its not getting the value from my DB.
i also need the checkbox if selected to change the value in the db please

thanks for your help in advance

</tr>
<tr>
  <td width="20%" rowspan="1" height="120" BORDERCOLOR=white><input type="checkbox" name="WantToWatch" value=<?php echo $row['WantToWatch']; ?></td>
   <td width="80%" height="38" colspan="4" BORDERCOLOR=white><?php echo $row['filmplot1']; ?></td>
  </tr>
<tr>

[kows]

well, your syntax is wrong -- you need to fix your <input> so that it looks like this:

<input type="checkbox" name="WantToWatch" value="<?php echo $row['WantToWatch']; ?>" />

where is the code you're using to update your database now?

[c_owl]

hi kows.
i corrected the syntax but im still not getting the check box checked. in the db "wanttowatch has the value of "true" or "false"

[c_owl]

hi kows i have had a play around with checkboxs and come up with this. but im stuck with it i cant get the true value from the wanttowatch colom of the db to change the checkbox to checked

i have posted the full table to try and show my working

     $sql = "SELECT vidnumber, titleid, hd, year,starring1,videotitle,starring2, directedby, filmplot1,dirid,starrid1,starrid2, trilogy,age, Runningtime,WantToWatch FROM videolist WHERE WantToWatch LIKE '".mysql_real_escape_string("True")."' LIMIT $offset, $rowsperpage";
     $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

     // while there are rows to be fetched...
     while ($row = mysql_fetch_assoc($result)) {

   //  <td><?php echo $row['vidnubmer']; ?></td>

 <td width="20&#37;" rowspan="3" height="120" BORDERCOLOR=white><p align="center"><img border=0 src="/vidpics/<?php echo $row['videotitle'];?>web.jpg" <?php</p></td>

    <td width="20%" height="19" BORDERCOLOR=white><p align="center">ID:<?php echo $row['vidnumber']; ?></td>
    <td width="60%" colspan="3" height="19" BORDERCOLOR=white><p align="center"><b><?php echo $row['videotitle']; ?></b></td>
</tr>
<tr>
  <td width="20%" height="14" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/title/<?php echo $row['titleid']; ?>" target="_top"><?php echo $row['titleid']; ?></a></td>
    <td width="20%" height="14" BORDERCOLOR=white><p align="center">Age <?php echo $row['age']; ?></td>
    <td width="20%" height="14" BORDERCOLOR=white><p align="center"><?php echo $row['year']; ?></td>
    <td width="20%" height="14" BORDERCOLOR=white><p align="center"><?php echo $row['Runningtime']; ?>mins</td>
</tr>
<tr>
  <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['dirid']; ?>" target="_top"><?php echo $row['directedby']; ?></td>
    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['starrid1']; ?>" target="_top"><?php echo $row['starring1']; ?></td>
    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><a href="http://imdb.com/name/<?php echo $row['starrid2']; ?>" target="_top"><?php echo $row['starring2']; ?></td>
    <td width="20%" height="25" BORDERCOLOR=white><p align="center"><?php echo $row['hd']; ?></td>
</tr>
<tr>
      if <?php echo $row['WantToWatch']; ?>="true" {
      <td width="20%" rowspan="1" height="120" BORDERCOLOR=white><input type="checkbox" name="WantToWatch" value="<?php echo $row['WantToWatch']; ?>" checked/>Watch</td>
            } else {

         <td width="20%" rowspan="1" height="120" BORDERCOLOR=white><input type="checkbox" name="WantToWatch" value="<?php echo $row['WantToWatch']; ?>" />Watch</td>

   }
  <td width="80%" height="38" colspan="4" BORDERCOLOR=white><?php echo $row['filmplot1']; ?></td>
  </tr>
<tr>
  <td width="80%" height="38" colspan="5" BORDERCOLOR=white><p align="center">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</p></td>

 </tr>
      <?php

  }
?>

</table>

[kows]

you have a random IF statement there which won't do anything; you haven't actually opened a PHP tag, so you're literally just printing an IF statement. change it to something like this:

<?php if($row['WantToWatch'] == "true"){ ?>
  <!-- something if the value is true -->
<?php }else{ ?>
  <!-- something is the value is not true -->
<?php } ?>

you don't have to put the entire <input> again, however. you could shorten this immensely (this would replace your entire if statement, and produce the same result):

<input type="checkbox" value="<?php echo $row['WantToWatch']; ?>"<?php if($row['WantToWatch'] == 'true') echo ' checked="checked"'; ?> />

[c_owl]

hi kows.
thanks for your help i used the longer version so i can better understand what im doing while im learnng

<?php if($row['WantToWatch'] == "true"){ ?>
  <!-- something if the value is true -->
<?php }else{ ?>
  <!-- something is the value is not true -->
<?php } ?>

i now want tobe able to update my db if a checkbox is selected.. ????
but i dont know were to start

[kows]

you need to have a form, and then you need a button that will submit the form.

<form method="post">
  <!-- your entire table should go here -->

  <input type="submit" value="Submit" />
</form>

then, you'll need to modify your checkbox, because you need to keep track of whatever ID you're on (all of your checkboxes can not be named "WantToWatch"). I would suggest an array:

<input type="checkbox" name="WantToWatch[<?php echo $row['vidnumber']; ?>]" value="<?php echo $row['WantToWatch']; ?>" />

then, at the very top of your script you should put the following:

<?php
  if($_SERVER['REQUEST_METHOD'] == "POST"){

    echo '<pre>';
    print_r($_POST);
    echo '</pre>';

  }
?>

then, whenever you submit your form, you should see a big array holding all of the values that you'll need to update. keep in mind: checkboxes are NOT SET when they are submitted on a form and unchecked! this means that when you submit this form, you will have a list of all the checkboxes that were checked, but not a list of which ones were not checked. this shouldn't be a problem for updating your database table, though.

let me know when you get all of that working properly.

[c_owl]

hi kows
thanks. for the advice and help. im off to work now.

im away for 3 days so will get straight on it when im back and let you know

thanks again for your help

craig