Use PHP to bulk delete all Prefix_ table _php instances under a database

The following is a script to unify the deletion of a table prefixed with "prefix_":

Copy Code code as follows:

<?php
Set up database connection information. Database server address, database username, data password
mysql_connect (' Database host ', ' Database username ', ' database Password ');
Set the database name of the query
mysql_select_db (' database name ');
$rs =mysql_query (' Show Tables ');
while ($arr =mysql_fetch_array ($RS))
{
Set the database table prefixes to be deleted in bulk, such as: Prefix_
$TF =strpos ($arr [0], ' prefix_ ');
if ($TF ===0) {
$FT =mysql_query ("drop table $arr [0]");
if ($FT) {
echo "$arr [0] Delete success! <br> ";
}
}
}
?>

Create a new PHP file, save as Deletedata.php

For example, you want to delete www.aworldair.com or http://www.pro-reach.com/background data, operation two steps on OK:

1. First upload this saved deletedata.php file to your site root directory;

2. Directly in the Address bar input: www.aworldair.com/deletedata.php or http://www.pro-reach.com/deletedata.php Execute the delete script is OK, the script will display in the browser all the table to delete the success of the information.