How to create a user registry for the grocery shopping system in MySQL

How to create a user registry for the grocery shopping system in MySQL

When developing a grocery shopping system, user registration is an essential function. The user registration table is one of the important data tables that stores user information. Creating a user registry in MySQL requires taking into account the user's basic information, account information and security. Here's how to create a user registry using specific code examples.

Create database and table

First, we need to create the database and user registry in MySQL. The following code example can be used:

CREATE DATABASE `buy_veggies_system` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; USE `buy_veggies_system`; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(100) NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

The above code creates a database namedbuy_veggies_systemand then switches to that database. Next, use theCREATE TABLEstatement to create a table namedusers, which contains the user'sid,username, # The ##password,emailandcreated_atfields.idis the auto-increment primary key,usernameis the unique field, andcreated_atis the creation time field.

INSERT INTO `users` (`username`, `password`, `email`) VALUES ('user1', 'password1', 'user1@example.com');

user1, the password topassword1, and the email address touser1@example.com## The user information of # is inserted into theuserstable.Query user information

In functions such as user login, we need to query user information from the user registration table based on the user name (or email) and password provided by the user. You can use the following code example:

SELECT `id`, `username`, `email`, `created_at` FROM `users` WHERE `username` = 'user1' AND `password` = 'password1';

The above code queries the user from the

table based on the user nameuser1and the passwordpassword1Theid,username,emailandcreated_atinformation.Update user information

When a user modifies personal information, we need to update the information in the user registration form. You can use the following code example:

UPDATE `users` SET `email` = 'newemail@example.com' WHERE `username` = 'user1';

The above code updates the email address of the user named

tonewemail@example.com.Delete user information

In functions such as user logout, we need to delete user information from the user registration table. The following code example can be used:

DELETE FROM `users` WHERE `username` = 'user1';

The above code deletes the user information with the username

.Summary

The above is a detailed code example of how to create a user registry for the grocery shopping system in MySQL. By creating databases and tables, adding, querying, updating, and deleting user information, we can implement a complete user registration function. Of course, there may be other functions and security considerations in the actual system. This article only briefly introduces the basic operations and table structure. If necessary, it can be adjusted and expanded according to the actual situation.

The above is the detailed content of How to create a user registry for the grocery shopping system in MySQL. For more information, please follow other related articles on the PHP Chinese website!