Use PHP to batch delete all tables with prefix_ in the database_PHP tutorial

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