I want to store the multiple checkbox values to store in a single field. I use that link http://www.mindfiresolutions.com/Storing-array-data-to-MySQL-using-PHP-1296.php. But i dont get the result.Give Help to find that problem.
9
-
1What result do you get?eggyal– eggyal2012-12-26 10:23:12 +00:00Commented Dec 26, 2012 at 10:23
-
what result is getting inserted?Ganesh RJ– Ganesh RJ2012-12-26 10:24:10 +00:00Commented Dec 26, 2012 at 10:24
-
Can you post your code so we that we can check where's the problem?J.K.A.– J.K.A.2012-12-26 10:26:19 +00:00Commented Dec 26, 2012 at 10:26
-
show us your checkbox code pleaseGanesh RJ– Ganesh RJ2012-12-26 10:26:37 +00:00Commented Dec 26, 2012 at 10:26
-
I want to display the selected checkbox values andall the values must be stored in the single field itself.manoranjani– manoranjani2012-12-26 10:27:35 +00:00Commented Dec 26, 2012 at 10:27
|
Show 4 more comments
2 Answers
Set your column as 'set' (specify the all possible values.) data type and than run the below query.
$comma_separated = implode(",", $values);
$insert_query = "INSERT INTO TABLE_NAME(col_name) VALUES('$comma_separated')";
$result_insert = mysql_query($insert_query);
I hope this will solve your problem.
Comments
I hope this will helpful
<html>
<body>
<form action="" method="post">
<p><input type="checkbox" name="color[]" value="red" />Red</p>
<p><input type="checkbox" name="color[]" value="blue" />Blue</p>
<p><input type="checkbox" name="color[]" value="orange" />orange</p>
<input type="submit" value="submit" name="sub" />
</form>
<?php
if(isset($_POST['sub']))
{
mysql_connect("localhost","root","") or die("Server Could not be connected");
mysql_select_db("gobinath") or die("database connection problam");
$color=implode(',',$_POST['color']);
mysql_query("insert into mcheck values('','$color')") or die("insert problam");
}
?>
</body>
</html>
