How to develop MYSQL simple Interactive site in PHP

Editor to share with you how to develop MYSQL simple interactive site in PHP, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

General users can only view other user information, not modify, add, and delete operations. Root users can complete the above three operations.

Realization idea

1. Create two data tables in the MySQL database. One data table holds the user name and password, which is used for login authentication, and the other holds basic information such as user permissions.

two。 When submitting the form to log in, first find out whether the user exists in the database, if it does not exist, report an error, exist, then verify the password, if the password is wrong, if the password is correct, the login displays all the user information stored in the database and the current login user name.

3. When users add or delete operations, first determine whether the permissions are sufficient, if they have permissions, complete the corresponding operations and modify the contents of the database, otherwise they will be prompted to have no permissions.

Concrete realization

1. Landing page