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>";
        }
    }
   
}