php - 使用 POST 和 php 写入 mysql 表

Question

我正在尝试将用户在我的表单中输入的电子邮件注册到我的 SQL 表中。但我没有收到任何错误，数据也没有保存!

 <?php
 echo "I was here !!!";
if(!empty($_POST['mail']))
{
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mailing";
echo "I was here !!!";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
 // Check connection
 if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 

$sql = 'INSERT INTO contact VALUES ("","'.$_POST['mail'].'")';
 if ($conn->query($sql) === TRUE) {
  echo "New record created successfully";
   } else {
   echo "Error: " . $sql . "<br>" . $conn->error;
    }

  $conn->close();
}
?>

和我的html代码:

    <div class="form">
        <p>Rester notifié par toutes les nouveautés !</p>
        <form method="post" action="index.php" class="mainform">

            <div class="field"><input type="text" class="field"  name="mail"  /></div>
            <div class="submit"><input class="submit" type="button" value="Envoyer" /></div>    

           </form>      
    </div>

你能告诉我出了什么问题吗？

Answer 1

更改您的按钮类型。因为如果您想通过表单提交数据，那么按钮类型应该像这样提交

<input class="submit" type="submit" value="Envoyer" />