我使用以下代码来显示所有表,但如何将表存储到排序数组中:
$sql = "SHOW TABLES FROM ".$counter_database." ORDER BY TABLES DESC";
$result = $conn->query($sql);
$outArray = array();
while($table = $result->fetch_assoc()) {
$outArrayx[] = $table;
}
以下代码吐出数据:
foreach ($outArrayx as $key => $value) {
foreach ($value as $keys => $values) {
$sql = "SELECT * FROM ".$values." WHERE user_id='0'";
$result = $conn->query($sql);
if (strpos($values, "ckia") === 0) {
while($table = $result->fetch_assoc()) {
$outArray[] = $table;
}
}
}
}
繁星淼淼