How php deletes the contents of a table

This article mainly introduces php how to delete the contents of the table, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Php delete the contents of the table method: 1, create a test.php file; 2, connect to the mysql database; 3, use mysqli_select_db to select the database to operate; 4, use delete to create a sql statement to delete the contents of the mytest data table.

This article operating environment: Windows7 system, PHP7.1 version, DELL G3 computer

How does php delete the contents of a table?

Php+mysql deletes the contents of the data table:

In the test database, create a mytest table and insert multiple pieces of data into the table for testing.

Create a test.php file within which you use the header () method to set the encoding format of the page to utf-8.

In the test.php file, connect to the mysql database through the server address, account number and password.

Within the test.php file, use mysqli_select_db to select the database you want to operate on.

Within the test.php file, use delete to create a sql statement that deletes the contents of the mytest data table, and then execute the sql statement through mysqli_query.

Open the test.php file in the browser and view the results in the database.

Thank you for reading this article carefully. I hope the article "how to delete the contents of a table in php" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!