 |
|
 PhpDig.net |
What is PhpDig?
PhpDig is a PHP MySQL based Web Spider & Search Engine. |
mysql_list_tables
Synopsis
mysql result mysql_list_tables(database[, connection]);
string database: Database to
use
mysql link connection
(optional): Connection handle returned by mysql_connect() or mysql_pconnect()
Description
mysql_list_tables() fetches a list of the tables that comprise the given database and returns a MySQL result handle that can be traversed with mysql_result() .
If the connection() argument is not set, the last connection opened is used by default. If no connection is open, mysql_list_tables() attempts to connect to a MySQL database by calling mysql_connect() without arguments.
See also
Example
Example 820. List all tables in a given database
<?php
// Included code that connects to a MySQL server and sets a default database
// See the MySQL Functions chapter introduction for the source code for the file
include ('mysql_connect.inc.php');
$table = 'user';
$result_handle = mysql_list_tables ($db)
or die ("mysql_list_tables () failed with this error message: '" . mysql_error () . "'");
$number_tables = mysql_num_rows ($result_handle);
echo "Database '$db' contains $number_tables table(s):<ol>";
for ($index=0; $index < $number_tables; ++$index) {
echo '<li>', mysql_result ($result_handle, $index, 0), '</li>';
}
echo '</ol>';
?>