Home > Database > mysql > How to get list of table names from database in mysql?

How to get list of table names from database in mysql?

Hi friends,

I got the requirement to display the list of table names from the database using php code. I got the solution for it, once check the below code.

1) Connect to database:

mysql_connect(“dbserver”,”dbuser”,”dbpassword”);

2)Get the list of tables from table

$result = mysql_list_tables(“dbname”);

3) Count the total number of tables

$num_tables = mysql_num_rows($result);

3) Display the tables names

for($i=0;$i<$num_rows;$i++)

{

echo  “Table : <b>”.mysql_tablename($result,$i).”</b>”;

}

mysql_free_result($result);

In this way we can the total table names from the database.

You may also like
Website uptime monitoring using PHP script
Understanding the basic need of MVC architecture
How to convert feeds to html using javascript and php
Multi-language support for web application with MySql and PHP

2 Responses

  1. Gwapo2go

    mysql_list_tables is already depricated. You should use mysql_query() to issue SHOW TABLES command. Refer to the PHP Manual for additional details.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.