Query: mysql_tablename
OS: php
Section: 3
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
MYSQL_TABLENAME(3) 1 MYSQL_TABLENAME(3) mysql_tablename - Get table name of fieldSYNOPSISWarning 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)DESCRIPTIONRetrieves 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)
Related Man Pages |
---|
mysql_db_name(3) - php |
mysql_db_query(3) - php |
mysql_field_type(3) - php |
mysql_free_result(3) - php |
mysql_tablename(3) - php |