如何将用户选择选项的值从下拉选择框列表中存储到 mysql 数据库中 - How can I store the value of a user selected option from a drop down select box list into mysql database?

How can I store the value of a user selected option from a drop down select box list into mysql database?

有一个带有下拉选择框列表的表单。如何将用户从下拉选择框列表中的选项的值存储到 mysql 数据库中？谢谢。

形式

<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 文件

<?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));
}

数据库

http://oi60.tinypic.com/9ppc0i.jpg

您需要提交表单。

<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>

它将解决问题。