PHP代码从phpmyadmin数据库中获取所有数据并显示？ [英] PHP Code to take all data from a phpmyadmin database and display?

问题描述

您好，

我想知道如何获取我拥有的数据库中每个表中的所有数据，并通过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(

这篇关于PHP代码从phpmyadmin数据库中获取所有数据并显示？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！