php - 使用 SELECT 选项从 PHP 插入外键值

Question

我使用 php 和 php myadmin (InnoDB) 创建一个基于 Web 的库存系统。我想在插入记录时在库存中插入值，我可以在下拉列表中看到(FK)的数据，但是当我将表单数据提交到数据库时，它返回为字段中没有输入值，并且下拉菜单不再存在。我在下拉列表中使用外键的方式是否错误？

我有一个包含多个外键的表。

表库存(id(PK)，姓名，条件_(fk),产品类型(fk))

表条件类型(条件_(pk))

表产品类型(产品类型(fk))

<?php
// Include config file
require_once "../config.php";

// Define variables and initialize with empty values
$name = $condition_ = $producttype = "";
$name_err = $condition_err = $producttype_err = "";


$sql2 = "SELECT * FROM condition_type";
$sql4 = "SELECT * FROM producttype";


// Processing form data when form is submitted
if($_SERVER["REQUEST_METHOD"] == "POST"){
// Validate name
$input_name = trim($_POST["name"]);
if(empty($input_name)){
    $name_err = "Please enter a name.";
}else{
    $name = $input_name;
}

// Validate condition
$input_condition = trim($_POST["condition_"]);
if(empty($input_condition)){
    $condition_err = "Please choose the condition.";     
} else{
    $condition_ = $input_condition;
}

// Validate producttype
$input_producttype = trim($_POST["prodcuttype"]);
if(empty($input_producttype)){
    $producttype_err = "Please enter the product type..";     
} else{
    $producttype = $input_producttype;
}

// Check input errors before inserting in database
if(empty($name_err) && empty($condition_err) && empty($producttype_err)){
    // Prepare an insert statement
    $sql = "INSERT INTO inventory (name, condition_, producttype) VALUES (?, ?, ?)";

    if($stmt = $mysqli->prepare($sql)){
        // Bind variables to the prepared statement as parameters
        $stmt->bind_param("sss", $param_name, $param_condition, $param_producttype);

        // Set parameters
        $param_name = $name;
        $param_condition = $condition;
        $param_producttype = $producttype;

        // Attempt to execute the prepared statement
        if($stmt->execute()){
            // Records created successfully. Redirect to landing page
            header("location: ../application");
            exit();
        } else{
            echo "Something went wrong. Please try again later.";
        }
    }

    // Close statement
    $stmt->close();
}

// Close connection
$mysqli->close();
}
 ?>

-------->这是表格

<div class="form-group <?php echo (!empty($condition_err)) ? 'has-error' 
: ''; ?>">
<label>Condition</label>
</br>
<select id="condition_" name="condition_" class="form-control" value="<? 
php echo $condition_ ;?>">
<option>Please Select Product Condition</option>
<?php
 if($result2 = $mysqli ->query($sql2)){
 while($row = $result2->fetch_array()){
  echo "<option value=".$row['condition_'].">" .$row['condition_']. " 
 </option>";
     }
   }
    ?> 
  </select>
     <span class="help-block"><?php echo $condition_err;?></span>
   </div>
 <div class="form-group <?php echo (!empty($producttype_err)) ? 'has- 
 error' : ''; ?>">
 <label>Product</label>
     </br>
 <select name="producttype" class="form-control" value="<?php echo 
 $producttype ;?>">
  <?php if($result4 = $mysqli ->query($sql4)){
  while($row = $result4->fetch_array()){
  echo "<option value=".$row['producttype'].">" .$row['producttype']. " 
 </option>";
     }
   }
 ?> 
 </select>
<span class="help-block"><?php echo $manufacturer_err;?></span>
  </div>

因此，当我提交它时，它会返回，因为条件和产品类型为空。我认为错误是因为
}

// Close connection
$mysqli->close();
 }

声明已经关闭。但我不知道如何放置它。

PHP 警告:mysqli::query():无法在第 173 行的/home/my-path/application/create_new.php 中获取 mysqli

Answer 1

您应该首先通过右键单击“检查元素”来调试 html 表单，并确保“选择”值正在获取？