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 named buy_veggies_system
and then switches to that database. Next, use the CREATE TABLE
statement to create a table named users
, which contains the user's id
, username
, # The ##password,
email and
created_at fields.
id is the auto-increment primary key,
username is the unique field, and
created_at is the creation time field.
INSERT INTO `users` (`username`, `password`, `email`) VALUES ('user1', 'password1', 'user1@example.com');
user1, the password to
password1, and the email address to
user1@example.com## The user information of # is inserted into the users
table. 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
users table based on the user name user1
and the password password1
The id
, username
, email
and created_at
information. 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
user1 to newemail@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
user1. 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!