Database construction of php user registration and login system

Database analysis

The database for registration and login contains a user table, and there should be at least three in the table Fields, number, username and password

Field details are as follows:

Next, let’s create the database

Database creation

We are using phpMyAdmin To create a simple database

First log in to the database. The username and password were set when we installed the database. My username and password are both root

After successful login, clickDatabaseon the top page,Then fill in the name of the database we want to create under the new database, and select utf8_general_ci for encoding (multi-language, case-insensitive)

#Click to create:

A_I):

##After filling in, click Save:

Okay, at this point, the database required for this project has been built

Note: If you can’t see the picture clearly, right-click on the picture Select View Picture to see the big pictureContinuing Learning

##int varchar varchar Field length Field description Number Username Password Now we create a data table containing three fields in the databaseClick Execute and fill in the details of each field ( Note: You need to choose an auto-increment for the id field, that is, select the option

##Field name	id	username	userpwd
Field type
10	20	20

用户名：
密 码：
确认密码：