我可以展示所有数据库和特定数据库中的所有表,但我想在PHP中使用循环或foreach获取MySQL中的所有数据库,并对于每个数据库显示与数据库名称关联的所有表。 我想要这样的数组...
我尝试过:
Array ( [database_name] = employees, [tables] = name, surame)
这只是一个例子我尝试过:
$db = new MysqliDb('');
$All_databases = $db->rawQuery('SHOW DATABASES'); // this gets all databases
foreach ($All_databases as $key => $value) {
$AllDbs[] = $value['Database']; // array of all databases found
$dbname = $value['Database']; // assign $dbname as a database name
foreach ($AllDbs as $tbl) { // foreach database found find its tables
$db2 = new MysqliDb($dbname);
$db_tables = $db2->rawQuery('SHOW TABLES');
foreach ($db_tables as $tbl) {
$table_name = $tbl['Tables_in_'.$dbname.''];
}
}
}
foreach ($All_databases as $key => $value)
中,$All_databases
和as
之间缺少一个空格。 - Allan Pereira