i am not able to insert record in mysql, here is html & php code
html
<form id="fForm" action="insert_staff_2.php" method="POST" enctype="multipart/form-data">
<select name="gender" id="gender" class="formTxtInput" onkeyup="getStaffId()">
<option>Gender</option>
<option>Female</option>
<option>Male</option>
</select>
php
include '../mysql_connect.php';
$db = new DBConfig();
$conn = $db->getDbPDO();
if(isset($_POST['gender'])){
$gender = $_POST['gender'];
$sql = "INSERT INTO tbl_staff (gender) VALUES (?)";
$query = $conn->prepare($sql);
$query->execute(array($gender));
echo"record enterd";
}else{
echo"record Not enterd"; }
It seems that you are not passing any values from your form. Be sure to set the 'value' attributes in your options tag, like this:
<option value='1'>Gender</option>
<option value='2'>Female</option>
<option value='3'>Male</option>
verify your html form :
<form id="fForm" action="insert_staff_2.php" method="POST" enctype="multipart/form-data">
<select name="gender" id="gender" class="formTxtInput" onkeyup="getStaffId()">
<option value="">Gender</option>
<option value="Female">Female</option>
<option value="Male">Male</option>
</select>
</form>