Database construction for login page

As we have said in the previous chapter, users The name and password must be stored in the data, so these two fields are essential. We name the username field "username" and the password "password".

Database creation

We can create a database through the mysql knowledge we have learned. This chapter uses our PHP Code to create our database

<?php
header("Content-type:text/html;charset=utf-8");    //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
// 創(chuàng)建連接
$conn = mysqli_connect($servername, $username, $password);
 mysqli_set_charset($conn,'utf8'); //設(shè)定字符集 
// 檢測連接
if (!$conn) {
    die("連接失敗: " . mysqli_connect_error());
}
// 創(chuàng)建數(shù)據(jù)庫
$sql = "CREATE DATABASE login";
if (mysqli_query($conn, $sql)) {
    echo "數(shù)據(jù)庫創(chuàng)建成功";
} else {
    echo "數(shù)據(jù)庫創(chuàng)建失敗: " . mysqli_error($conn);
}
mysqli_close($conn);
?>

The above code creates a database named login

Create data table

The data table is named: user

The data table and field creation code is as follows

<?php
header("Content-type:text/html;charset=utf-8");    //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "login";
// 創(chuàng)建連接
$conn = mysqli_connect($servername, $username, $password, $dbname);
 mysqli_set_charset($conn,'utf8'); //設(shè)定字符集 
// 檢測連接
if (!$conn) {
    die("連接失敗: " . mysqli_connect_error());
}
// 使用 sql 創(chuàng)建數(shù)據(jù)表
$sql = "CREATE TABLE user (
 id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 username VARCHAR(30) NOT NULL,
 password VARCHAR(30) NOT NULL
 );";
if (mysqli_query($conn, $sql)) {
    echo "數(shù)據(jù)表 user 創(chuàng)建成功";
} else {
    echo "創(chuàng)建數(shù)據(jù)表錯(cuò)誤: " . mysqli_error($conn);
}
mysqli_close($conn);
?>

The above code creates a database named "user", which contains "id", "username" and "password" Field

Let’s open phpmyadmin and take a look

. We can see that our database has been set up. Of course, this is just the simplest and basic one. After setting up our database, we can create our HTML display page