PHP 8 MySQL 教程：构建登录和用户身份验证系统

\-- php-user-authentication
  |-- config
      |--- db.php
  |-- controllers
      |--- login.php
      |--- register.php
      |--- user_activation.php
  |-- css
      |--- style.css
  |-- lib
      |--- 3rd party plugins
  |-- dashboard.php
  |-- header.php
  |-- index.php
  |-- logout.php
  |-- signup.php
  |-- user_verification.php

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `mobilenumber` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `is_active` enum('0','1') NOT NULL,
  `date_time` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 
    // Enable us to use Headers
    ob_start();
    // Set sessions
    if(!isset($_SESSION)) {
        session_start();
    }
    $hostname = "localhost";
    $username = "phpdemo";
    $password = "4Mu99BhzK8dr4vF1";
    $dbname = "positronx_db";
    
    $connection = mysqli_connect($hostname, $username, $password, $dbname) or die("Database connection not established.")
?>

"en">
    "utf-8">
    "viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    "stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
    "stylesheet" href="./css/style.css">
    
    
    
    
    
class="App">
        <div class="vertical-center">
            <div class="inner-block">
                <form action="" method="post">
                    <h3>Registerh3>
                    <div class="form-group">
                        <label>First namelabel>
                        <input type="text" class="form-control" name="firstname" id="firstName" />
                    div>
                    <div class="form-group">
                        <label>Last namelabel>
                        <input type="text" class="form-control" name="lastname" id="lastName" />
                    div>
                    <div class="form-group">
                        <label>Emaillabel>
                        <input type="email" class="form-control" name="email" id="email" />
                    div>
                    <div class="form-group">
                        <label>Mobilelabel>
                        <input type="text" class="form-control" name="mobilenumber" id="mobilenumber" />
                    div>
                    <div class="form-group">
                        <label>Passwordlabel>
                        <input type="password" class="form-control" name="password" id="password" />
                    div>
                    <button type="submit" name="submit" id="submit" class="btn btn-outline-primary btn-lg btn-block">
                        Sign up
                    button>
                form>
            div>
        div>
    div>
body>
html>

"en">
    "utf-8">
    "viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    "stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
    "stylesheet" href="css/style.css">
    
    
    
    
    
    
class="App">
        <div class="vertical-center">
            <div class="inner-block">
                <form action="" method="post">
                    <h3>Loginh3>
                    <div class="form-group">
                        <label>Emaillabel>
                        <input type="email" class="form-control" name="email_signin" id="email_signin" />
                    div>
                    <div class="form-group">
                        <label>Passwordlabel>
                        <input type="password" class="form-control" name="password_signin" id="password_signin" />
                    div>
                    <button type="submit" name="login" id="sign_in"
                        class="btn btn-outline-primary btn-lg btn-block">Sign
                        inbutton>
                form>
            div>
        div>
    div>
body>
html>

* {
  box-sizing: border-box;
}
body {
  font-weight: 400;
  background-color: #EEEFF4;
}
body,
html,
.App,
.vertical-center {
  width: 100%;
  height: 100%;
}
.navbar {
  background: #1833FF !important;
  width: 100%;
}
.btn-outline-primary {
  border-color: #1833FF;
  color: #1833FF;
}
.btn-outline-primary:hover {
  background-color: #1833FF;
  color: #ffffff;
}
.vertical-center {
  display: flex;
  text-align: left;
  justify-content: center;
  flex-direction: column;
}
.inner-block {
  width: 450px;
  margin: auto;
  background: #ffffff;
  box-shadow: 0px 14px 80px rgba(34, 35, 58, 0.2);
  padding: 40px 55px 45px 55px;
  transition: all .3s;
  border-radius: 20px;
}
.vertical-center .form-control:focus {
  border-color: #2554FF;
  box-shadow: none;
}
.vertical-center h3 {
  text-align: center;
  margin: 0;
  line-height: 1;
  padding-bottom: 20px;
}
label {
  font-weight: 500;
}

   
    // Database connection
    include('config/db.php');
    // Swiftmailer lib
    require_once './lib/vendor/autoload.php';
    
    // Error & success messages
    global $success_msg, $email_exist, $f_NameErr, $l_NameErr, $_emailErr, $_mobileErr, $_passwordErr;
    global $fNameEmptyErr, $lNameEmptyErr, $emailEmptyErr, $mobileEmptyErr, $passwordEmptyErr, $email_verify_err, $email_verify_success;
    
    // Set empty form vars for validation mapping
    $_first_name = $_last_name = $_email = $_mobile_number = $_password = "";
    if(isset($_POST["submit"])) {
        $firstname     = $_POST["firstname"];
        $lastname      = $_POST["lastname"];
        $email         = $_POST["email"];
        $mobilenumber  = $_POST["mobilenumber"];
        $password      = $_POST["password"];
        // check if email already exist
        $email_check_query = mysqli_query($connection, "SELECT * FROM users WHERE email = '{$email}' ");
        $rowCount = mysqli_num_rows($email_check_query);
 
        // PHP validation
        // Verify if form values are not empty
        if(!empty($firstname) && !empty($lastname) && !empty($email) && !empty($mobilenumber) && !empty($password)){
            
            // check if user email already exist
            if($rowCount > 0) {
                $email_exist = '
                    
                        User with email already exist!