在一个表单中插入多个Mysqli

Question

我试图保存用户正在以某种形式填写的数据。

问题是，当我按submit按钮时，所有的数据都按我想要的方式保存，但是它保存了多次。(多行数据相同)

    <?php

if($_SERVER['REQUEST_METHOD'] == 'POST'){
        $share = $_POST['share'];
        $date = $_POST['date'];
        $dealtype = $_POST['dealtype'];
        $enter = $_POST['enter'];
        $exitdeal = $_POST['exitdeal'];
        $no1 = $_POST['no1'];
        $no2 = $_POST['no2'];
        $profit = $_POST['profit'];

        if ($share != "")
        {
            if ($date != "")
            {
                if ($dealtype != "" )
                {
                    if ($enter != "" )
                    {
                        if ($exitdeal != "" )
                        {
                            $mysql = "INSERT INTO markettable (share, date, dealtype, enter, exitdeal, no1, no2, profit) 
                            VALUES ('$share','$date', '$dealtype', '$enter', '$exitdeal', '$no1', '$no2', '$profit')";
                        }
                    }
                }
            }
        }
        $mysqli->query($mysql);
        if ($mysqli->query($mysql) === TRUE) {
            echo "New record created successfully";
        } else {
        echo "Error: " . $mysql . "<br>" . $mysqli->error;
        }
        $mysqli->close();
    }

?>

Answer 1

看这儿,

  $mysqli->query($mysql);

  if ($mysqli->query($mysql) === TRUE) {
       echo "New record created successfully";
   } 

$mysqli->query($mysql);首先插入数据，if ($mysqli->query($mysql) === TRUE)再次插入数据。

如果你改变你的代码，

     $result =  $mysqli->query($mysql); // save the result in $result variable
     if ($result === TRUE) { // checks if its successfully inserted
           echo "New record created successfully";
      } 

Answer 2

您可以调用查询两次，第一次在if语句之前执行，第二次在if语句条件内执行。