HElP insert multiple checkbox data into MySQL
Posted: Mon Apr 06, 2009 12:44 pm
How do I insert multiple checkbox data into MySQL, I tried to put it in the database but it says array or it will only store on piece of data instead of multiple data
Heres my code:
html:
<input type="checkbox" name="tran[]" value="Mon">
Monday
<input type="checkbox"name="tran[]" value="Tue">
Tuesday
<input type="checkbox" name="tran[]" value="Wed">
Wednesday
<input type="checkbox" name="tran[]" value="Thur">
Thursday
<input type="checkbox"name="tran[]" value="Fri">
Friday
php:
$tran = $_POST[tran];
if($_POST['Submit'] == 'Submit')
{
mysql_query("INSERT INTO $usertable(`days`,`time`,`trans`,`subject`,`grade`,`skill`,`oskill`,`status`) VALUES ('$day','$time','$tran','$subj', '$grade', '$skills','$oskill','1')")or die(mysql_error());
}
Heres my code:
html:
<input type="checkbox" name="tran[]" value="Mon">
Monday
<input type="checkbox"name="tran[]" value="Tue">
Tuesday
<input type="checkbox" name="tran[]" value="Wed">
Wednesday
<input type="checkbox" name="tran[]" value="Thur">
Thursday
<input type="checkbox"name="tran[]" value="Fri">
Friday
php:
$tran = $_POST[tran];
if($_POST['Submit'] == 'Submit')
{
mysql_query("INSERT INTO $usertable(`days`,`time`,`trans`,`subject`,`grade`,`skill`,`oskill`,`status`) VALUES ('$day','$time','$tran','$subj', '$grade', '$skills','$oskill','1')")or die(mysql_error());
}