我正在尝试检索数据库中前缀为"CMS_"的所有表的列表
我现在使用的代码是:
$DB->conn = new mysqli($DB->servername, $DB->username, $DB->password, $DB->database);
if(!$DB->conn->connect_errno){
$recordset = $DB->conn->query("SELECT * FROM `TABLES` WHERE TABLE_NAME LIKE 'CMS_*' AND TABLE_SCHEMA='$DB->database'");
if($recordset->num_rows < 1){echo ("<H2>You have no Content-Types Defined...</H2>");}
else{
$recordset = $recordset->fetch_array();
foreach($recordset as $record){
var_dump($record);echo "<BR/>";
}
}
}else{die("fatal error;no database connection;");}
在 SQL 中,您应该使用通配符%
而不是*
LIKE 'CMS_%'
编辑:
while($record = $recordset->fetch_array()){
var_dump($record);echo "<BR/>";
}