If you want to find out field information then used mysql_fetch_field() function that return an object containing information of a field from the record set.
PHP mysql_fetch_field() Function Example:
If you want to find out field information then used mysql_fetch_field() function that return an object containing information of a field from the record set. The mysql_fetch_field() function gets data from the mysql_query() function and return an object on success or false on failure.
Example:
<?php $connection = mysql_connect("localhost","root","root"); if (!$connection) { die('PHP Mysql database connection could not connect : ' . mysql_error()); } else{ mysql_select_db("php_mysql", $connection); $sql = "SELECT * from user"; $result = mysql_query($sql,$connection); while ($user_table_property = mysql_fetch_field($result)) { echo "Field name: " . $user_table_property->name . "<br />"; echo "Table name: " . $user_table_property->table . "<br />"; echo "Default value: " . $user_table_property->def . "<br />"; echo "Max length: " . $user_table_property->max_length . "<br />"; echo "Not NULL: " . $user_table_property->not_null . "<br />"; echo "Primary Key: " . $user_table_property->primary_key . "<br />"; echo "Unique Key: " . $user_table_property->unique_key . "<br />"; echo "Field Type: " . $user_table_property->type . "<br /><br />"; } } mysql_close($connection); ?>
After running this example you can see the output that contain fields information.
Output:
Field name: user_id Table name: user Default value: Max length: 1 Not NULL: 1 Primary Key: 1 Unique Key: 0 Field Type: int Field name: user_name Table name: user Default value: Max length: 6 Not NULL: 0 Primary Key: 0 Unique Key: 0 Field Type: string Field name: user_email Table name: user Default value: Max length: 21 Not NULL: 0 Primary Key: 0 Unique Key: 0 Field Type: string Field name: user_address Table name: user Default value: Max length: 6 Not NULL: 0 Primary Key: 0 Unique Key: 0 Field Type: string
[ 0 ] Comments