<div class="codebody" id="code22249">
<?PHP
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_fetcharray($result)) {
$table=mysubstr($data[Name],"");
if($table==$tableflag){
//测试之用
/echo $data[Name];
echo "
";
echo $table;
echo "
";/
MysqL_query("drop table $data[Name]");
}
}
return true;
}
/截取某个特定字符前的所有字符函数
$str 为待截取字符串
$flag 特定字符如“_”
/
function mysubstr($str,$flag){
$pos=strpos($str,$flag);
return substr($str,$pos);
}
?>