PHP代码从phpmyadmin数据库中获取所有数据并显示?

问题描述:

您好,

我想知道如何获取我拥有的数据库中每个表中的所有数据,并通过php将其显示在网页中。基本上每个表中所有数据的数据转储



提前谢谢!

Luke

Hello,
I was wondering how I would get all data that is in each table within a database I have and display it in a webpage through php. Basically a data dump of all data in each table

Thank You in advance !
Luke

要查找所有表,您可以使用此SQL命令:

To find all tables you can use this SQL command:


sql = SELECT TABLE_NAME AS TableName
FROM information_schema.tables
WHERE table_catalog = db_name()
ORDER BY TABLE_NAME
;
sql = "SELECT TABLE_NAME AS TableName FROM information_schema.tables WHERE table_catalog = db_name() ORDER BY TABLE_NAME";


tables = mysqli_query(
tables = mysqli_query(