Shulou(Shulou.com)06/01 Report--

How to achieve PHP connection to the database, through the process-oriented method to achieve the most basic operation of adding, deleting, modifying and searching? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

1. PHP connects to MySQL database

2. Add data to the database

First, I created such a user table in the beyondweb_test database for demonstration. As shown in the figure:

SQL statement:

CREATE TABLE user (id INT (20) PRIMARY KEY AUTO_INCREMENT, nikename VARCHAR (30), email VARCHAR (40))

Then add data to the database:

3. Modify the data in the database

We also operate based on the user table, such as changing "Zhang San" to "Li Si". The php code is as follows:

In fact, the SQL statement has changed, and everything else is exactly the same.

4. Query the database

Just change the SQL statement, such as querying all the data in the table and outputting it in tabular form:

Id nikename email

5. Delete data

The previous solutions have been given to add data, modify data, and delete data, so there is only one "delete" left in "add, delete, modify and query". Let's take a look at how to delete data. In fact, it is similar to the above, just change a SQL statement. Take a look at the PHP code:

All right, the above is the PHP connection database and the most basic addition, deletion, change and search operation, I hope it can be helpful to beginners.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.