php - 使用phpMyAdmin在php中将用户添加到MySQL数据库

Question

我认为我通过以下方式成功连接到我的数据库:

<?php
    $user = 'root';
    $pass = '9KSroMDjEqNmEYY4';
    $db = 'chatservice';
    $host = '127.0.0.1';

    $conn = new mysqli($host, $user, $pass, $db, 3306) or die("Unable to connect");
    if ($conn->connect_error){
        die("Connection failed: " . $conn->connect_error);
    }
?>

我的问题是如何使用注册码成功地将用户添加到数据库中。输入表单时，我按注册键，但没有收到任何表明注册未成功的错误消息。似乎在初始连接后未到达 php 代码。我是 php 和 mySQL 的新手，所以任何有关格式化的提示也很好!

<?php
    require('connect.php');
    if(isset($_POST['user']) && isset($_POST['password'])){
        $user = $_POST['user'];
        $id = $_POST['IDNUM'];
        $password = $_POST['password'];

        $query = "INSERT INTO 'users' (user ,IDNUM ,password) VALUES('$user', '$id', '$password')";
        $result = mysqli_query($query);
        if($result){
            $msg = "Registered Sussecfully";
            echo $msg;
        }
        else
            $msg = "Error Registering";
            echo $msg;
    }
?>


<div class="register-form">
    <title>Chat Page Start</title>
    <form action="" methods="POST">
        <p>
        <label>Username: </label>
        <input id="user" type="text" name="user" placeholder="user" />
        </p>

        <p>
        <label>ID: </label>
        <input id="IDNUM" type="text" name="IDNUM" placeholder="ID number" />
        </p>

        <p>
        <label>Password: </label>
        <input id="password" type="password" name="password" placeholder="password" />
        </p>

        <a class="btn" href="login.php">Login</a>
        <input class="btn register" type="submit" value="Register" />
    </form>
</div>

另一件事是我如何检查我的数据库连接的状态以及我应该在哪里检查这个状态？

Answer 1

你的数据库连接是mysqli_connect，你在mysql_query中执行查询是不正确的。

 <?php
    require('connect.php');
    if(isset($_POST['user']) && isset($_POST['password'])){
        $user = $_POST['user'];
        $id = $_POST['IDNUM'];
        $password = $_POST['password'];

        $query = "INSERT INTO 'users' (user ,IDNUM ,password) VALUES('$user', ' $id ', '$password')";
        $result = mysqli_query($query,$conn);
        if($result){
            $msg = "Registered Sussecfully";
        }
        else
            $msg = "Error Registering";
    }
?>