Home>Article>Backend Development> Detailed code for creating user registration system with PHP

Detailed code for creating user registration system with PHP

墨辰丷
墨辰丷 Original
2018-06-06 17:21:49 6198browse

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn