时间戳

首页 > 解决方案 > 输入数据成功但未将数据放入 php admin mySQL 数据库

php - 输入数据成功但未将数据放入 php admin mySQL 数据库

问题描述

我是一个学校项目的 PHP 编码新手，我需要输入数据但检查重复值

现在我正在检查电子邮件地址，它确实找到了重复项，但当我添加附加列 Mobile 和 Date 值时它不接受附加条目，代码停止输入数据但说它是成功的。

当我删除数据库的列并将代码减少为仅是名字姓氏电子邮件ID时，它可以工作。

任何关于如何让它输入移动和日期数据的建议将不胜感激

指数

<html>
<body>
    <form name="form" method="post" action="1process.php">
        <table>
            <tr>
                <td>First Name</td>
                <td><input type="text" name="fname" required pattern="[a-zA-Z]+" /></td>
            </tr>
            <tr>
                <td>Last Name</td>
                <td><input type="text" name="lname" required pattern="[a-zA-Z]+" /></td>

                        <tr>
                <td>Mobile</td>
                <td><input type="text" name="mobile" required pattern="[a-zA-Z]+" /></td>

            <tr>
                <td>Email Id</td>
                <td><input type="email" name="mail" required  /></td>
            </tr>


                        <tr>
                <td>Date</td>
                <td><input type="text" name="date" required pattern="[a-zA-Z]+" /></td>
                  </tr>



            <tr>
                <td></td>
                <td><input type="submit" name="submit" value="submit" /></td>
            </tr>




        </table>
    </form>



</body>


<?php

PHP进程

<?php

$host = "localhost";
$user = "root";
$password = "";
$database = "SurfschoolDB";

$mysqli = new mysqli($host,$user,$password,$database);

$fname = $_POST['fname'];
$lname = $_POST['lname'];
$mobile = $_POST['mobile'];
$email = $_POST['mail'];
$date = $_POST['date'];

// Check connection
if ($mysqli -> connect_errno) {
  echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
  exit();
}

// Perform query 
if ($result = $mysqli -> query("SELECT `email ID` FROM `customers` WHERE `email id` = '$email'")) {
  echo "Returned rows are: " . $result -> num_rows . "\n";
  $count = $result -> num_rows;
  echo $count . "\n";
  If ($count == 0) {
     $mysqli -> query("INSERT INTO `customers`(`First Name`, `Last Name`, 'Mobile', 'Date', `Email Id`) VALUES ('$fname', '$lname', '$mobile', '$date', '$email')");
     echo "Entered data successfully\n";
  } Else {
     echo "User already exists\n";
  $result -> free_result();
  }
}

`enter code here`$mysqli -> close();
?>

标签： phpmysql

解决方案

推荐阅读