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:

##intvarcharvarcharField lengthField descriptionNumberUsernamePassword

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, click Database on 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:

Now we create a data table containing three fields in the database

Click 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

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 picture Continuing Learning

new file

<!DOCTYPE html> <html> <head> <title>php.cn</title> <meta charset="utf-8" /> <style> .box{ width:250px; height:120px; background:#f0f0f0; } </style> </head> <body>  <div class="box"> <form action="regcheck.php" method="post"> <table> <tr> <td align="right">用户名：</td> <td><input type="text" name="username" value="请输入用户名" maxLength="6"/></td> </tr> <tr> <td align="right">密码：</td> <td><input type="password" name="userpwd" maxLength="6"/></td> </tr> <tr> <td align="right">确认密码：</td> <td><input type="password" name="confirm" maxLength="6"/></td> </tr> <tr> <td colspa="2" align="right"><input type="Submit" name="Submit" value="注册"/></td> </tr> </table> </form> </div> </body> </html>

submit Reset Code

Automatic operation

Previous section Next Section

Tutorial List

get help

Course Recommendations
Courseware download

The courseware is not available for download at the moment. The staff is currently organizing it. Please pay more attention to this course in the future~

Students who have watched this course are also learning

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

Database construction of php user registration and login system

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]