php - PHP表单为2个不同的字段输入相同的值

Question

所以我有一张桌子，我希望能够选择餐厅 ID 和名称并将其插入到与该餐厅链接的交易的新表格中。

<?php
// First we start a session which allow for us to store information as SESSION variables.
session_start();
// "require" creates an error message and stops the script. "include" creates an error and continues the script.
require "config.php";

$sql = "SELECT * FROM Restaurants";
$result= mysqli_query($link, $sql) or die("Bad Query: $sql");
$row = mysqli_fetch_array($result);

if (isset($_GET['post'])) {
    $Restaurant_ID = mysqli_real_escape_string($link, $_GET['Restaurant_ID']);
    $Name = mysqli_real_escape_string($link, $_GET['Name']);
}   

?>
<select name="Restaurant_ID">
    <?php
    foreach($result as $row)
    {
        $output .=  '<option value ="'. $row['Restaurant_ID'] .'">'. $row['Name'] .'</option>';
    }

echo $output;
?>
</select>
</div> 
<select name="Name">
    <?php
    foreach($result1 as $row1)
    {
        $output .=  '<option '. $row1['Name'] .'>'. $row1['Name'] .'</option>';
    }
echo $output;
?>

</select>

当它将它们放入表中时，它会为 $Name 和 $Restaurant_ID 提供相同的名称，并在两个字段中仅插入 $Restaurant_ID。

网站看看它是如何工作的http://thefoodieapp.co.uk/thefoodieappv1/deal_form.php?signup=success

标签： phpmysql