所以这是我的示例代码,它从select标签和文本框中获取输入 . 问题是,我在google上看到的大多数示例只使用表单标记中的单个选择标记并将数据发布到php变量 . 我需要同时将这两个值同时提供给查询 . 我应该使用javascript来获取select标签的值,还是有办法发布文本框中的数据和单个表单中的select标签?
employee.php
<form name = "AddEmployee"method="post" action ="php/employeetabsubmit.php" >
<input type="text" name="surname" id = "surname" placeholder="Surname Here">
<select name="empStanding">
<option value="ADMIN">ADMIN</option>
<option value="EMPLOYEE">EMPLOYEE</option>
<option value="SUPERVISOR">SUPERVISOR</option>
</select>
<button class="add" type="submit" name="add">Add</button>
</form>
employeetabsubmit.php
<?php
$conn=mysqli_connect('localhost','root','','employee');
if(!$conn){
die('Could not Connect My Sql:' .mysql_error());
}
else{
echo '<script>console.log("Connected to DATABASE")</script>';
}
if (isset($_POST['add'])){
$surname_string = mysqli_real_escape_string($conn, $_POST['surname']);//sample input
$employee_standing = $_POST['empStanding'];
$sql="INSERT INTO employee_table (emp_surname, emp_standing) VALUES ('$surname_string','$employee_standing');
if (!mysqli_query($conn,$sql)) {
die('Error: ' . mysqli_error($conn));
}
echo "1 record added";
mysqli_close($conn);
}
?>
2 回答
将按钮放在select标签之外,它应该正常工作 - 其他一切看起来都是正确的
在表单属性中添加enctype =“multipart / form-data” .