Data dialysis table code for batch deletion of data tables with the same prefix in Mysql in PHP

Method 1:

Copy the code The code is as follows:

mysql_connect('','','');
mysql_select_db('');
$rs=mysql_query('show tables ');
while($arr=mysql_fetch_array($rs)){
$TF=strpos($arr[0],'class_');
if($TF===0){
$FT=mysql_query( "drop table $arr[0]");
if($FT){
echo "$arr[0] deleted successfully!
";
}
}
}
?>

Method 2 :
I reinstalled my website today and spent an afternoon working on it, and finally found a method that can be used to delete database tables in batches. . .
This is a demonstration with xx_ as the prefix. You can change it to the table prefix you want to delete

Copy the code The code is as follows:

function deldata($dbname,$tableflag){
$db_host = 'localhost';
$db_port = '3306';
$db_user = 'user';
$db_pass = 'password';
$connect =mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($dbname);
$result = mysql_query("show table status from $dbname",$connect);
$data=mysql_fetch_array($result);
while($data=mysql_fetch_array($result)) {
$table =mysubstr($data[Name],"_");
if($table==$tableflag){
//For testing purposes
/*echo $data[Name];
echo "
";
echo $ table;
echo "
";*/
mysql_query("drop table $data[Name]");
}
}
return true;
}
/*Intercept all characters before a specific character function
*$ str is the string to be intercepted
*$flag specific characters such as "_"
*/
function mysubstr($str,$flag){
$pos=strpos($str,$flag);
return substr($str, 0,$pos);
}
?>

The changes are:
1. At the beginning
function deldata($dbname,$tableflag){
$db_host = 'localhost';
$db_port = '3306';
$db_user = 'user';
$db_pass = 'password';
Change it to your own database address, account number and password
2. At the end
Change it to your own database name and the database name you want to delete For missing table prefix
, you can copy the above code and save it as .php, then upload it to the space directory to open it

The above introduces the code of data dialysis table PHP to batch delete data tables with the same prefix in Mysql, including the content of data dialysis table. I hope it will be helpful to friends who are interested in PHP tutorials.