欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  php教程

php 删除数据表与删除数据库

程序员文章站 2022-03-27 16:31:52
...
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 {
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)");}
}