Home >Backend Development >PHP Tutorial >PHP delete data table and delete database_PHP tutorial
PHP delete data table and delete database_PHP tutorial
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-07-20 11:06:26974browse
php 删除数据表与删除数据库
//---------------------------删除数据表
function Ebak_Drop($tablename,$dbname){
global $empire;
$dbname=RepPostVar($dbname);
$empire->query("use `$dbname`");
$count=count($tablename);
if(empty($count))
{printerror("EmptyChangeDelTb","history.go(-1)");}
$a="";
$first=1;
for($i=0;$i<$count;$i++)
{
if(empty($first))
{
$a.=",";
}
else
{
$first=0;
}
$a.="`".$tablename[$i]."`";
}
$sql1=$empire->query("DROP TABLE IF EXISTS ".$a.";");
printerror("DelTbSuccess","ChangeTable.php?mydbname=$dbname");
}
//--------------------------删除数据库
function Ebak_DropDb($dbname){
global $empire;
$dbname=RepPostVar($dbname);
if(empty($dbname))
{
printerror("NotChangeDelDb","history.go(-1)");
}
$sql=$empire->query("DROP DATABASE `$dbname`");
if($sql)
{
printerror("DelDbSuccess","ChangeDb.php");
}
else
{printerror("DbError","history.go(-1)");}
}