php查询全部数据表名,php 查询获得(遍历)MySQLI所有表名称，并删除所有数据表、创建多张表...

$conn = new mysqli("数据库地址", "数据库用户名","用户密码", "数据库名");

if ($conn->connect_error) {// 检测连接

die("连接失败: " . $conn->connect_error);

}else{//连接成功时开始写入数据库表

$result = $conn->query("SHOW TABLES"); //执行之前先删除数据表

while($arr = $result->fetch_assoc()){

foreach($arr as $key=>$vle){//遍历所有遍名称

//echo $vle; 输出所有数据表名

$slms_sql = 'DROP TABLE '.$vle;//删除查询到的数据库代码

$conn->query($slms_sql);//开始删除

}

}

}

$conn->close();//关闭数据库连接

2、php创建多个数据表解决办法

$slms_sql_list = "CREATE TABLE slms_list (

id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(30) NOT NULL COMMENT '名称'

)";

$slms_sql_users = "CREATE TABLE slms_users (

uid INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

uname VARCHAR(30) NOT NULL COMMENT '用户名'

)";

$slms_sql_ping = "CREATE TABLE slms_ping (

pid INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

id INT(11) NOT NULL COMMENT '文章id'

)";

$slms_sql_huifu = "CREATE TABLE slms_huifu (

hid INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

pid INT(11) NOT NULL COMMENT '评论ID'

)";

$slms_sql = array($slms_sql_list,$slms_sql_users,$slms_sql_ping,$slms_sql_huifu);

foreach($slms_sql as $key=>$val){//遍历数据库执行代码

if($conn->query($val) != 1){//创建失败时执行

echo "创建数据表错误: " . $conn->error;

}else{

echo $key."创建成功！";

}

}