Detailed code for creating user registration system with PHP

This article mainly introduces the detailed code for creating a user registration system in PHP. Interested friends can refer to it. I hope it will be helpful to everyone.

User registration system

Write an index.php page with a username and password form, submit the post to check.php, and output the username and "username and password" md5 value
Create a mysql database locally, named segmentfault, create a table user, the field username password will store the content received by check.php in the previous question
Let’s complete the HTML part first:

注册


 

 邮箱
 
 
 

 密码
 
 
 

 

Note that HTML5's support for forms is much better than previous versions of HTML, and various types can be directly specified. For example, if type="email" is specified, it will check whether the email address submitted by the user is legal.

Then check.php.

 哇咔咔，你已经注册成功啦！

呃……不过注册成功了好像也没什么用，因为本网站除了注册以外好像没有其他功能。
那么，作为补偿，我会告诉你，你的“邮箱+密码”的md5值。
你的邮箱是：

The following is the PHP part, which is directly embedded in HTML. This is the advantage of PHP:

你的“邮箱+密码”的md5值是：
Note that we use htmlspecialchars to prevent users from filling in strange things. 
Then comes the database operation, we use mysqli, (mysql has been abandoned, now it is recommended to use mysqli, of course you can also use PDO.) 
First we specify some information about the database: 
$db_server = "localhost";
$db_user = "db_user";
$db_pass = "password";
$db_name = "segmentfault";
Connect to the database and make sure the connection is normal: 
$conn = new mysqli($db_server, $db_user, $db_pass, $db_name);

if (mysqli_connect_errno()) {
 trigger_error("Database connection failed: " . mysqli_connect_error(), E_USER_ERROR);
}
Use SQL statements to create a table
The code is as follows:
$sql = "CREATE TABLE user(username CHAR(140), password CHAR(140))";
Add records
 The code is as follows: 
mysqli_query($conn, "INSERT INTO user (username, password) VALUES ($username, $md5sum)");
 Hand-written SQL is not very comfortable. In actual application, the framework will provide you with various conveniences. 
Close the database: 
mysqli_close($conn);

?>



Summary: The above is the entire content of this article, I hope it will be helpful to everyone's study. 
Related recommendations: 
php array function array_walk usage and examples
PHPExcel implementation of reading excel files and simple examples
PHP MVC framework skymvc supports multiple file upload implementation methods
The above is the detailed content of Detailed code for creating user registration system with PHP. For more information, please follow other related articles on the PHP Chinese website!