如何通过表单连接php代码？

Question

所以我第一次做了一个单独的登录页面，也是第一次使用 PHP 代码。如您所见，下面是我的表单代码。

<form method="post" action="validate_login.php">

<div class="login-inhoud">

    <h1>Login</h1>

    <div class="login-input">

        <input type="email" id="users_email" name="users_email" size="30" maxlength="30" placeholder="Email">

        <br><br>

        <input type="password" id="users_pass" name="users_pass" size="30" maxlength="30"

               placeholder="Wachtwoord">

    </div>

    <br>

    <div class="login-submit">

        <button type="submit"><b>submit</b></button>

    </div>

</div>

但是，当我添加此 Php 代码时，它不起作用。另外 mysql_connect 和 mysqli_connect 之间有什么区别？

    <?php

// Grab User submitted information

$email = $_POST["users_email"];

$pass = $_POST["users_pass"];

// Connect to the database

$con = mysqli_connect("localhost", "root", "");

// Make sure we connected successfully

if ($con->connect_errno) {

    echo "Failed to connect to MySQL: " . $con->connect_error;

    exit(); }

// Select the database to use

    mysqli_select_db("my_dbname", $con);

    $result = mysqli_query("SELECT users_email, users_pass FROM users WHERE users_email = $email");

    $row = mysqli_fetch_array($result);

    if ($row["users_email"] == $email && $row["users_pass"] == $pass)

        echo "You are a validated user.";

    else

        echo "Sorry, your credentials are not valid, Please try again.";

    ?>

Answer 1

你的代码中有很多错误......试试这个，希望它有效：&nbsp; &nbsp; <?php// Grab User submitted information$email = $_POST["users_email"];$pass = $_POST["users_pass"];// Connect to the database$con = mysqli_connect("localhost", "root", "", "my_dbname"); //Why complicate life?!// Make sure we connected successfullyif (mysqli_connect_errno()) {&nbsp; &nbsp; echo "Failed to connect to MySQL: " . mysqli_connect_error();&nbsp; &nbsp; exit;}$result = mysqli_query($con, "SELECT users_email, users_pass FROM users WHERE users_email = $email");&nbsp; &nbsp; $row = mysqli_fetch_array($result);&nbsp; &nbsp; if ($row["users_email"] == $email && $row["users_pass"] == $pass)&nbsp; &nbsp; &nbsp; &nbsp; echo "You are a validated user.";&nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; echo "Sorry, your credentials are not valid, Please try again.";&nbsp; &nbsp; ?>