vendredi 22 juillet 2016

pass checkbox data from form to mysql database

I have a admin page where i can edit/delete entry posts. I have just added the checkbox with input name of loest..

In mysql i added a column with the name of loest, and TYPE: TINYINT, and NULL: YES.

I work in Dreamweaver cs6.

My question is: How do i pass the state of the checkbox into my database?

My form looks like this:

 <?php do { ?>
            <tr>
              <td><h5><?php echo $row_insert_data['id']; ?></h5></td>
              <td><?php echo $row_insert_data['fejlmeldt_dato']; ?></td>
              <td><?php echo $row_insert_data['aarsag']; ?></td>
              <td><?php echo $row_insert_data['loest_dato']; ?></td>
              <td><?php echo $row_insert_data['TIMESTAMP']; ?></td>
              <td><a href="update.php?id=<?php echo $row_insert_data['id']; ?>"><img src="images/006-pencil.png" width="16" height="16"></a></td>
              <td><a href="del.php?id=<?php echo $row_insert_data['id']; ?>"><img src="images/glyphicons-17-bin.png" width="15" height="21"></a></td>
              <td><input name="loest" type="checkbox" value=""></td>
            </tr>
            <?php } while ($row_insert_data = mysql_fetch_assoc($insert_data)); ?>




Aucun commentaire:

Enregistrer un commentaire