php记录没有插入

Question

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"; }

Answer 1

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>