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(