注册表格可以';t在phpmyadmin数据库中连接


registration form can't connect in phpmyadmin db

我有一个注册表单,我希望它能连接到我的数据库。我使用phpmyadmin作为我的数据库。我用来连接两者的代码如下:

db.php

<?php
$hostname = "127.0.0.1";
$user = 'root';
$password = '';
$db = 'dbTest';
//connection to db
$conn = mysqli_connect("$hostname", "$user", "$password", "$db")or die(mysqli_error());
mysqli_select_db($conn, "peanat")or die(mysqli_error());

    $username = $_POST['username'];
    $password = $_POST['password'];
    $username =  strtolower(trim($_POST["username"])); 
    $username = filter_var($username, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW|FILTER_FLAG_STRIP_HIGH);
    $checkUsername = mysqli_query($conn, "Select username * FROM users WHERE Username='$username'");
    $numrows = mysqli_num_rows($checkUsername);
        if($numrows!==1) {
        echo "Username not available";
    }else{
        $sql = "INSERT INTO `users` (`Username`, `Password`) VALUES ('$username', '$password')";
        if(!mysqli_query($conn, $sql)) {
            die(mysqli_error());
        } else {
             echo "1 record added";
        }
    }
?>

这是我的注册表格

<form id="register" action="db.php" method="post" >
      <div class="col-4">
        <label>
          Username
          <input placeholder="" id="username" name="username">
        </label>
      </div>
      <div class="col-4">
        <label>Password
        <input type="password" placeholder="" id="password" name="password">
        </label>
      </div>
      <div class="col-4">
        <label>Confirm Password
        <input type="password" placeholder="" id="password2" name="password2">
        </label>
      </div>
      <div class="col-submit">
        <input type="submit" class="submitbtn" name="register" value="Register">
      </div>
</form>

现在我遇到的问题是,每次我点击注册按钮,它都会转到指定的页面,并显示该页面的代码。你认为我的错误在哪里。。。

  1. 将这两个文件(db.php&reg.HTML)放入本地web服务器文件夹中。(例如C:/examplep/htdocs/form/
  2. 打开任何internet浏览器并键入HTML文件的路径。例如,本地host/form/reg.html,然后点击回车键。您应该在浏览器上显示HTML表单,然后就完成了