如何将下拉选择框列表中的用户所选选项的值存储到mysql数据库中?
问题描述:
使用下拉列表选择框列表。如何将用户选择的选项的值从下拉选择框列表中存储到mysql数据库中?谢谢。如何将下拉选择框列表中的用户所选选项的值存储到mysql数据库中?
FORM
<form action="xxx.php" class="well" id="xxx" name"xxx" method="post">
<select name="extrafield5">
<option value="NOW" selected="selected">Submit order now</option>
<option value="REVIEW">Submit my order for review</option>
<button id="btn1" type="submit" value="Submit">Submit</button>
</select>
</form>
PHP FILE
<?php
define('DB_NAME', 'xxx');
define('DB_USER', 'xxx');
define('DB_PASSWORD', 'xxx');
define('DB_HOST', 'xxx');
$connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$connection){
die('Database connection failed: ' . mysqli_connect_error());
}
$db_selected = mysqli_select_db($connection, DB_NAME);
if(!$db_selected){
die('Can\'t use ' .DB_NAME . ' : ' . mysqli_connect_error());
}
echo 'Connected successfully';
if (isset($_POST['extrafield5'])){
$extrafield5 = $_POST['extrafield5'];
}
else {$extrafield5 = '';}
$sql = "INSERT INTO seguin_orders (extrafield5)
VALUES ('$extrafield5')";
if (!mysqli_query($connection, $sql)){
die('Error: ' . mysqli_connect_error($connection));
}
DATABASE
答
您需要提交表格。
<form action="xxx.php" class="well" id="xxx" name"xxx" method="post">
<select name="extrafield5">
<option value="NOW" selected="selceted">Submit order now</option>
<option value="REVIEW">Submit my order for review</option>
</select>
<input type="submit" name="submit" value="Submit"/>
</form>
,并得到它在PHP:
if (isset($_POST['submit'])){
if (isset($_POST['extrafield5'])){
$extrafield5 = $_POST['extrafield5'];
}
else {$extrafield5 = '';}
}
答
你不能进入下一个页面(xxx.php),直到您提交表单。所以请把表单中的提交按钮。
<form action="xxx.php" class="well" id="xxx" name"xxx" method="post">
<select name="extrafield5">
<option value="NOW" selected="selceted">Submit order now</option>
<option value="REVIEW">Submit my order for review</option>
</select>
<input type="submit" name="submit" value="Submit"/>
</form>
它会解决问题。
+0
即时通讯实际上使用一个按钮,我忘了包括...如果即时通讯使用按钮与输入提交按钮,会有所作为? – 2014-12-03 22:48:05
+0
@MarkRodriguez,在'
php文件返回什么? – MMK 2014-12-03 07:29:33
你的表单提交按钮在哪里? – 2014-12-03 07:30:12
put print_r($ _ POST);在数据库连接之前查看你在那个页面上得到了什么.. – MMK 2014-12-03 07:30:27