MYSQL_TABLENAME(3) 1 MYSQL_TABLENAME(3)
mysql_tablename - Get table name of field
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. 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:
oSQL Query:
SHOW TABLES
string mysql_tablename (resource $result, int $i)
DESCRIPTION
Retrieves the table name from a $result.
This function is deprecated. It is preferable to use mysql_query(3) to issue an SQL SHOW TABLES [FROM db_name] [LIKE 'pattern'] statement
instead.
o $result
- A result pointer resource that's returned from mysql_list_tables(3).
o $i
- The integer index (row/table number)
The name of the table on success or FALSE on failure.
Use the mysql_tablename(3) function to traverse this result pointer, or any function for result tables, such as mysql_fetch_array(3).
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.5.0 | |
| | |
| | The mysql_tablename(3) function is deprecated, |
| | and emits an E_DEPRECATED level error. |
| | |
+--------+---------------------------------------------------+
Example #1
mysql_tablename(3) 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), "
";
}
mysql_free_result($result);
?>
Note
The mysql_num_rows(3) function may be used to determine the number of tables in the result pointer.
mysql_list_tables(3), mysql_field_table(3), mysql_db_name(3).
PHP Documentation Group MYSQL_TABLENAME(3)
