The following is a script that uniformly deletes tables with the prefix "prefix_":
Copy code The code is as follows:
//Set database connection information. Database server address, database username, data password
mysql_connect('database host', 'database username', 'database password');
//Set the query database name
mysql_select_db('database name ');
$rs=mysql_query('show tables');
while($arr=mysql_fetch_array($rs))
{
//Set the database table prefix to be deleted in batches, such as ：prefix_
$TF=strpos($arr[0],'prefix_');
if($TF===0){
$FT=mysql_query("drop table $arr[0] ");
if($FT){
echo "$arr[0] deleted successfully!
";
}
}
}
?>
Create a new php file and save it as deletedata.php
For example, you want to delete the background data of www.aworldair.com or http://www.pro-reach.com/ , two steps are enough:
1. First upload the saved deletedata.php file to the root directory of your website;
2. Directly enter: www. aworldair.com/deletedata.php or http://www.pro-reach.com/deletedata.php will be OK if you execute this deletion script. The script will display the successful deletion information of all tables in the browser.
http://www.bkjia.com/PHPjc/781036.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/781036.htmlTechArticleThe following is a script to uniformly delete tables with the prefix "prefix_": Copy the code as follows: ?php //Settings Database connection information. Database server address, database user name, data...
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
