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 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.

Add user information

When a user registers, we need to store the information provided by the user into the user registration form. You can use the following code example:

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

The above code sets the user name to

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!