Copyright 1997-2021 the PHP Documentation Group.
mysql_tablename
Get table name of field
This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
SQL Query: SHOW TABLES
|
Description
string|false mysql_tablename(resource result,
int i);
Retrieves the table name from a result
.
This function is deprecated. It is preferable to use
mysql_query
to issue an SQL SHOW TABLES [FROM db_name] [LIKE
'pattern']
statement instead.
Parameters
-
result
A result pointer resource that's returned from
mysql_list_tables
.-
i
The integer index (row/table number)
Return Values
The name of the table on success or false
on failure.
Use the
mysql_tablename
function to traverse this result pointer, or any function for
result tables, such as
mysql_fetch_array
.
Changelog
Version | Description |
---|---|
5.5.0 | The
mysql_tablename
function is deprecated, and emits an
E_DEPRECATED level error. |
Examples
Example 7.195 mysql_tablename
example
<?php
mysql_connect("localhost", "mysql_user", "mysql_password");
$result = mysql_list_tables("mydb");
$num_rows = mysql_num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
echo "Table: ", mysql_tablename($result, $i), "\n";
}
mysql_free_result($result);
?>
Notes
The
mysql_num_rows
function may be used to determine the number of tables in the
result pointer.
See Also
mysql_list_tables
|
mysql_field_table
|
mysql_db_name
|