php批量建表：对分表有用
代码如下，db类随便找的一个，见附件。<?php
$db_config=array(
'host'=>'localhost',
'admin'=>'****',
'charset'=>'****',
'database_pwd'=>'***',
'database'=>'***',
);
require_once "db.class.php";
$db=new db;
$db->connect($db_config);
for($i=1;$i<5;$i++)
{
$tt=$i.'test';
$row=$db->query("SHOW TABLES LIKE '".$tt."'");//查看此表是否存在
if($db->num_rows($row))
{
//echo "Table exists";
echo $tt." exists<br>";
} else {
//echo "Table does not exist";
$sql="CREATE TABLE ".$tt." (`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,`name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,`tontent` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL) ENGINE = MYISAM ;";
$res=$db->query($sql);
if(!$res)
{
echo $tt." creat err<br>";
}else
{
echo $tt." creat ok<br>";
}
}
}
页:
[1]