代码如下,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>";
- }
- }
- }