PHP Mysql Tutorials, Function, mysql_list

Topic

What is mysql_list_tables() function in PHP?
How does mysql_list_tables() works?

Explanation

This mysql_list_tables function list all the tables in a MySQL database.

Syntax

resource mysql_list_tables ( string database [, resource link_identifier])

Returns result pointer resource on success, or FALSE on failure.

mysql_list_tables() function returns a result pointer containing all the table names for given database. The mysql_tablename() is used to extract the actual table names from the returned result pointer.

This function is deprecated. It is preferable to use mysql_query() to issue a SQL SHOW TABLES [FROM db_name] [LIKE 'pattern'] to list table names of given database.

Example

<?php

//Attempt to connect to the default database server

$link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
or die ("Could not connect");

//return result pointer containing list of table names

$list = mysql_list_tables ("database");
$i = 0;

//extract table names form the result pointer

while ($i < mysql_num_rows ($list)) {
$tb_names[$i] = mysql_tablename ($list, $i);
echo $tb_names[$i] . "<BR>"; $i++;
}

?>

Above code returns a result pointer to retrieve list of table names for given database using mysql_list_tables function. mysql_tablename or mysql_fetch_row is used to fetch list of table name returned by result pointer.

RESULT:

table1
table2
table3...

See also: mysql_list_dbs() and mysql_tablename().