I'm new to PHP. I learnt how to insert data from a textbox but I am facing a problem now when I have to get data from a checkbox. I checked out other posts but they are either too advanced and most of them are using mysql rather than mysqli.
I have ->> two check boxes and a submit button
I would like insert the value of the check box into the database, when selected(one or both).
Thanks
HTML FORM Code:
<html>
<head>
<title>Insert Data</title>
</head>
<body>
<h1> check box testing </h1>
<form name="form1" method="post" action="checkbox_test.php" >
<fieldset>
<legend> Checkbox Trial </legend>
<h3> Subject selection </h3>
<input type="checkbox" name="PHP" value="php" id="cbsubp1"/> PHP
<br/>
<input type="checkbox" name="ASP" value="course[]" id="cbsub2"/> ASP.NET
<br/>
<input type="submit" value="submit" id="submit"/>
</fieldset>
</form>
</body>
</html>
and PHP code is
<html>
<head>
<title>Insert Data</title>
</head>
<body>
<h1> check box testing </h1>
<?php
$con=mysqli_connect("localhost","root","","chkbox");
//check connection
if(mysqli_connect_errno())
{
echo "Cannot connect to mySQL:".mysqli_connect_error();
}
else
{
echo "Connected to mySQL succesfully";
}
$query= "INSERT into sub(Subject1) VALUES('$_POST[php]')";
if (!mysqli_query($con,$query))
{
die('Error: ' . mysqli_error($con));
}
echo "record added";
?>
</body>
</html>
