如何使用php将mysql数据库中的所有表显示或显示到html表中

Question

I have a PHP script that creates tables with 3 rows in the admin's database(users).

$sql1="CREATE TABLE '".$username."' (id int(5) AUTO_INCREMENT, ip VARCHAR(255), password VARCHAR(255), PRIMARY KEY (id))";

So I want to have all the tables (it's rows and data) in the users database displayed on admin's dashboard like this:

<h3>Table_Name</h3>
<tr>
<th>Row1</th><th>Row2</th><th>Row3</th>
</tr>
<tr>
<td>All Data On Row1</td><td>All Data On Row2</td><td>All Data On Row3</td>
</tr>

Please someone should help me with a tested php mysql query on this issue. I sincerely don't have an idea on how to make this work. My xamp isn't helping matters because it can't seem to connect with the database, so i find it difficult testing my code; so help me with a tested and working code.

Answer 1

1. First select a database.
2. to get all tables of the database, run this query show TABLES;
3. To get all column names of a table run this query DESCRIBE your_table_name;