Insert Checkbox Data To Mysql
My problem is as follows. This is my mySQL table, and HTML form. I need to findout a PHP code to insert the checkbox data to mySQL table. If a checkbox is checked I want to fill t
Solution 1:
# Please Try again below code. #
<?phpif($_SERVER['HTTP_HOST'] == 'localhost:8080') {
$servername = "localhost";
$username = "root";
$password = "";
$db = 'test';
}
$conn = mysql_connect($servername, $username, $password);
if ($conn) {
mysql_select_db($db, $conn) ordie('Could not select database.');
}
if(isset($_POST['submit'])){
$monday = isset($_POST['day_name']['monday']) ? $_POST['day_name']['monday'] : 0;
$tuesday = isset($_POST['day_name']['tuesday']) ? $_POST['day_name']['tuesday'] : 0;
$wednesday = isset($_POST['day_name']['wednesday']) ? $_POST['day_name']['wednesday'] : 0;
$thursday = isset($_POST['day_name']['thursday']) ? $_POST['day_name']['thursday'] : 0;
$friday = isset($_POST['day_name']['friday']) ? $_POST['day_name']['friday'] : 0;
//echo "INSERT INTO `available_day` (`monday`, `tuesday`, `wednesday`, `thursday`, `friday`) VALUES ('".$monday."', '".$tuesday."', '".$wednesday."', '".$thursday."', '".$friday."')"; $sql_add = mysql_query("INSERT INTO `available_day` (`monday`, `tuesday`, `wednesday`, `thursday`, `friday`) VALUES ('".$monday."', '".$tuesday."', '".$wednesday."', '".$thursday."', '".$friday."')");
if(!$sql_add)
{
die('could not add data'.mysql_error());
}
$message="Successfully Added ID No: ".mysql_insert_id();
echo"<script type='text/javascript'>alert('$message'); window.location.href='index6.php';</script>";
}
?><formaction="<?phpecho$_SERVER['PHP_SELF']; ?>"method="post"name="contact_form"enctype='multipart/form-data'><divclass="form-group" ><inputtype="checkbox"name="day_name[monday]"value="1">Mon<br><inputtype="checkbox"name="day_name[tuesday]"value="1"> Tues<br><inputtype="checkbox"name="day_name[wednesday]"value="1"> Wed<br><inputtype="checkbox"name="day_name[thursday]"value="1"> Thu<br><inputtype="checkbox"name="day_name[friday]"value="1"> Fri<br><inputname="submit"type ="submit"class="btn btn-default"style="border-radius: 0px; background-color: midnightblue; box-shadow: 2px 2px 2px #888888; color: white;"></div></form>
Solution 2:
1) regForm.php
<formmethod="post"action="regCode.php">
ID: <inputtype="text"name="id"/></br>
Select Available dates: </br>
Monday <inputtype="checkbox"value="1"name='monday'></br>
Tuesday <inputtype="checkbox"value="1"name='tuesday'></br>
Wednesday <inputtype="checkbox"value="1"name='wednesday'></br>
Thursday <inputtype="checkbox"value="1"name='thursday'></br>
Friday <inputtype="checkbox"value="1"name='friday'></br><inputtype="submit"value="Submit"/><br></br></html>
2) regCode.php
<html><bodybgcolor="#FFFCC"><?php$dbhost='localhost';
$dbuser='username';
$dbpass='password';
$conn=mysql_connect($dbhost,$dbuser,$dbpass);
if(!$conn)
{
die('could not connect'.mysql_error());
}
if(isset($_POST['submit'])){
$monday = isset($_POST['monday']) ? $_POST['monday'] : 0;
$tuesday = isset($_POST['tuesday']) ? $_POST['tuesday'] : 0;
$wednesday = isset($_POST['wednesday']) ? $_POST['wednesday'] : 0;
$thursday = isset($_POST['thursday']) ? $_POST['thursday'] : 0;
$friday = isset($_POST['friday']) ? $_POST['friday'] : 0;
$sql="INSERT INTO available_days (monday, tuesday, wednesday, thursday, friday) VALUES ('".$monday."', '".$tuesday."', '".$wednesday."', '".$thursday."', '".$friday."')";
mysql_select_db('testdb');
$retval=mysql_query($sql,$conn);
if(!$retval)
{
die('could not add data'.mysql_error());
}
$message="Successfully Added ID No: ".mysql_insert_id();
echo"<script type='text/javascript'> alert('$message') window.location.href='regForm.php';</script>";
mysql_close($conn);
}
?></body>
If the db columns are INT please replace the with following code
$monday = isset($_POST['monday']) ? 1 : 0;
$tuesday = isset($_POST['tuesday']) ? 1 : 0;
$wednesday = isset($_POST['wednesday']) ? 1 : 0;
$thursday = isset($_POST['thursday']) ? 1 : 0;
$friday = isset($_POST['friday']) ? 1 : 0;
And query like this
$sql="INSERT INTO available_days (monday, tuesday, wednesday, thursday, friday) VALUES ($monday, $tuesday, $wednesday, $thursday, $friday)";
Post a Comment for "Insert Checkbox Data To Mysql"