php - 通过 php 将日期插入到 php 表失败

Question

我显示了一个购物车，用户必须从日历小部件中选择交货日期，然后单击“确认”按钮。提交后，订单购物车应与输入的交货日期一起填充。

我使用的代码是:

<?php
echo "<form action='' name='form1' >";

//some disaply codes here

    echo "Choose the Date of delivery<input type='date' name='date'>";


                echo "<input type='submit' class='btn btn-default' name='final_submission' value ='Confirm Order'>";
                echo "</form>";      
  ?>

插入代码是:

<?php
if (isset($_POST['final_submission'])){
                    error_reporting(E_ALL);
                    ini_set('display_errors', 1);

                        $IP="my localhost";
                        $USER="my user name";
                        $conn=mysqli_connect($IP,$USER,"","my database name");
                        if (mysqli_connect_errno()) {
                            echo "Failed to connect to MySQL: " . mysqli_connect_error();
                        }


$date = stripslashes($_POST['date']);
$result=mysqli_query($conn, $query);
$query="select * from cart";

while($row = mysqli_fetch_array($result)) {
    $us_id=$row['user_id'];
    $pr_id=$row['prod_id'];
    $qtty=$row['quantity'];

    $query_insert = "insert into orders(user_id, prod_id, quantity, dt_del) values('.$us_id.',
    '.$pr_id.', '.$qtty.','.$date.')";
    $res_ins=mysqli_query($conn,$query_insert);
   }
}

?>     

订单表未填充。我无法指出错误。请指出来

编辑:订单表正在填充，但删除日期字段变为空白...请让我知道如何正确传递日期变量，显然这就是问题

Answer 1

说实话，我不确定你想做什么。你的代码块缺少很多东西。例如:

$query="select * from cart";
while($row = mysqli_fetch_array($result)) {

什么结果？你在哪里定义它们？这是您在那里指定的查询的结果吗，因为您肯定没有执行它。因此结果将为0并且不会被执行。

问题还在于此查询将遍历购物车的每一行，这意味着您还将抓取不属于您的客户的购物车，请指定。

所以你的代码应该是这样的

$query="select * from cart";
$result = mysqli_query($conn,$query);
while($row=mysqli_fetch_array($result)){
// yadi yadi yadi .. code code code

编辑

让我尝试通过适当的缩进为您重新解决这个问题。

if (isset($_POST['final_submission'])){   // check if the button is correct
    // error_reporting(E_ALL);        <-- canceling this out for now
    // ini_set('display_errors', 1);  <-- canceling this out for now

       $IP="my localhost";
       $USER="my user name";
       $conn=mysqli_connect($IP,$USER,"","my database name");
       if (mysqli_connect_errno()) {
           echo "Failed to connect to MySQL: " . mysqli_connect_error();
     }

     $date = stripslashes($_POST['date']);

     if (empty($date) || $date == ''){
          echo 'the date is not set, please check if parameter is filled in';   
     } else { // if it wont pass this point, you wont get an enormous output of unidentified indexes

         $query="select * from cart";
         $result=mysqli_query($conn, $query);
         while($row = mysqli_fetch_array($result)) {
             $us_id=$row['user_id'];
             $pr_id=$row['prod_id'];
             $qtty=$row['quantity'];
             $date = stripslashes($_POST['date']);  // just to play it safe define it again

             if (empty($date) || $date == ''){
                echo 'something went wrong with the date';
             }else{ 
                 $query_insert = "insert into orders(user_id, prod_id, quantity, dt_del) values('.$us_id.','.$pr_id.', '.$qtty.','.$date.')";
                 $res_ins=mysqli_query($conn,$query_insert);
             }
         }    
     }
 }