How to Store Check box in MYsql?

Am Newbie.I have this coding...How to store into Mysq开发者_如何学Cl and How to Retrieve from the Database?

<input type="checkbox" name="like" value="yes"/>Yes
<input type="checkbox" name="like" value="no"/>No 

am doubt with if i select both 2 box means what will happen? Please Explain...Thanks in Advance..

---

If you have no problem with comma separated values

my answer will help you

simple use array name to your field

<input type="checkbox" name="like[]" value="yes"/>Yes
<input type="checkbox" name="like[]" value="no"/>No 

then implode it with comma

implode(","$_POST['like']);

if two box is checked then result will be yes,no

make your column in varchar Then do usual stuff to store

---

yourscript.php:

<?php
include("mysql_connect.php");
if ($_POST['like'])
{
    if ($_POST['like'] != "yes" and $_POST['like'] != "no") die("Hacker");
    mysql_query("INSERT INTO likes ('id', 'like') VALUES ('', '".$_POST['like']."')");
}
?>
<form method="post" action="yourscript.php">
<input type="checkbox" name="like" value="yes"/>Yes
<input type="checkbox" name="like" value="no"/>No 
</form>

retreive.php:

<?php
include("mysql_connect.php");
$likes = mysql_query("SELECT * FROM likes");
while($like = mysql_Fetch_assoc($likes))
{
   echo "ID ".$like['id']." => ".$like['like'];
}

If you select both fields, it will save the latest select. You want radio (probably)

---

You probably don't want to be doing this in the first place. What you really want to be using is radio buttons for yes/no values. Otherwise, you're going to run into problems.

---

you can use like this

<input type="checkbox" name="like[]" value="yes"/>Yes
<input type="checkbox" name="like[]" value="no"/>No 

to store in db use serialize(); function.

unserialize() return the same array with keys.