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.
2 Comments
Gwapo2go · July 12, 2010 at 10:02 am
mysql_list_tables is already depricated. You should use mysql_query() to issue SHOW TABLES command. Refer to the PHP Manual for additional details.
Murali Krishna K · October 27, 2010 at 5:57 am
Use $num_tables instead of $num_rows in for loop on the above mention code than it works fine.