php 创建数据[crate database]与清空数据表
<?php
function Ebak_CreatDb($dbname, $dbchar = '') {
global $empire, $phome_db_ver;
$dbname = RepPostVar($dbname);
if (!trim($dbname)) {
printerror("EmptyDbname", "history.go(-1)");
}
$a = "";
if ($dbchar && $phome_db_ver >= '4.1') {
$a = " DEFAULT CHARACTER SET " . $dbchar;
}
$sql = $empire->query("CREATE DATABASE IF NOT EXISTS `$dbname`" . $a);
if ($sql) {
printerror("CreateDbSuccess", "ChangeDb.php");
} else {
printerror("DbError", "history.go(-1)");
}
}
//--------------------------清空表
function Ebak_EmptyTable($tablename, $dbname) {
global $empire;
$dbname = RepPostVar($dbname);
$empire->query("use `$dbname`");
$count = count($tablename);
if (empty($count)) {
printerror("EmptyChangeTb", "history.go(-1)");
}
for ($i = 0; $i < $count; $i++) {
$sql1 = $empire->query("TRUNCATE `" . $tablename[$i] . "`;");
}
printerror("TruncateTbSuccess", "ChangeTable.php?mydbname=$dbname");
}教程网址:http://www.phprm.com/code/php-create-database.html
欢迎收藏∩_∩但请保留本文链接。