html+表单不保存,从HTML表单的下拉列表中选择的值不会保存到表格中

最新推荐文章于 2022-10-22 23:29:47 发布

weixin_39623244

最新推荐文章于 2022-10-22 23:29:47 发布

阅读量296

点赞数

文章标签： html+表单不保存

我在服务器上有HTML表单，PHP文件和表格。按下表单上的提交按钮后，除了SELECTED VALUE FROM DROPDOWN以外，所有内容都保存到后台。 Link to the Table picture:从HTML表单的下拉列表中选择的值不会保存到表格中

HTML FORM CODE;

Name:

CNIC :

Date:

Ocassion:

Barat

Walima

option3

option4

option5

option6

Address:

Phone-No:

Bride-Mobile:

Groom-Mobile:

Family-Mobile:

E-mail:

Who may i thank for refering you?:

Do you provide consent to share images on our official web page:Yes

If yes:

With identity: Yes

PHP代码：

$server="localhost";

$user="root";

$password="";

$database="camouflage_studio";

$con = mysqli_connect($server,$user,$password,$database);

if (mysqli_connect_errno())

{

echo "Connection Error: " . mysqli_connect_error();

}

// prepare and bind

$stmt = $con->prepare("insert into personal_detail (Name, CNIC, Date, Ocassion, Address, Phone_No, Bride_Mobile, Groom_Mobile, Family_Mobile,EMail,Referring,Share,Permission) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");

$stmt->bind_param("ssssssiiissss", $_POST['name'], $_POST['cnic'], $_POST['booking-date'], $_POST['ocassion'], $_POST['address'], $_POST['phone-no'], $_POST['bride-mobile'], $_POST['groom-mobile'], $_POST['family-mobile'], $_POST['email'], $_POST['refering'], $_POST['share'], $_POST['permission']);if(mysqli_stmt_execute($stmt))

{

echo "New records created successfully";

}

else

echo "Prepare Error: ",$con->error;$stmt->close();

$con->close();

你的选项值是空的。这就是他们在POST中传递的方式。 –