mysql_fetch_field - Get column information from a result

object mysql_fetch_field ( resource $result [, int $field_offset = 0 ] )

Get column information from a result and return as an object

Returns an object containing field information. This function can be used to obtain information about fields in the provided query result.


<?php
$conn = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$conn) {
    die('Could not connect to mysql server: ' . mysql_error());
}mysql_select_db('database'); //setup of database$result = mysql_query('select * from table');
if (!$result) {
    die('MySql Error: ' . mysql_error());
}/* get column metadata */$i = 0;
while ($i < mysql_num_fields($result)) {
    echo "Information for column $i:<br />\n";
    $meta = mysql_fetch_field($result, $i);
    if (!$meta) {
        echo "No information available<br />\n";
    }
    echo "<pre>
blob:         $meta->blob
max_length:   $meta->max_length
multiple_key: $meta->multiple_key
name:         $meta->name
not_null:     $meta->not_null
numeric:      $meta->numeric
primary_key:  $meta->primary_key
table:        $meta->table
type:         $meta->type
unique_key:   $meta->unique_key
unsigned:     $meta->unsigned
zerofill:     $meta->zerofill
</pre>";
    $i++;
}mysql_free_result($result);?>

Best Related Posts are Following:

1. PHP 7 new features.
2. What is session_set_cookie_params.
3. imagecreatefrompng - Create a new image from file or URL - PHP.
4. count_chars - Count Number of character of string with PHP.
5. Check if string contains specific words - PHP.
6. New features of PHP 5.5 with Examples.
7. New features of PHP 5.4 with Examples.
8. How To Track the Real IP Address Behind the Proxy - PHP - REMOTE_ADDR.
9. date_sunrise - Returns time of sunrise for a given day and location.
10. Convert image to Binary Data and vice versa in PHP.
11. Difference between in_array and array_key_exists in php with Example.
12. get_class_vars PHP Function.
13. get_class_methods PHP Function.
14. mysql_fetch_field - Get column information from a result.
15. PHP mktime() Function - Get Unix timestamp for a date.
16. Strtolower - Returns string with all alphabetic characters converted to lowercase.
17. PHP file_get_contents Function - Reads entire file into a string.
18. PHP utf8_encode Function - Encodes an ISO-8859-1 string to UTF-8.
19. com_create_guid Generate a globally unique identifier.
20. spl_autoload What is spl_autoload function in php.
21. parse_ini_string - Parse a configuration string.
22. stream_socket_client - Open Internet or Unix domain socket connection.
23. imagecopyresampled-Copy and resize part of an image with resampling.
24. What is proc_close.
25. What is str_getcsv.
26. spl autoload extensions in PHP.
27. Parse a binary IPTC block into single tags.
28. Perform a regular expression search and replace.
29. fputcsv - Write in CSV File with PHP.
30. realpath - Get the Real path of File with PHP.
31. ob_get_level -Return the nesting level of the output buffering mechanism.
32. openssl decrypt - Decrypts data.
33. Domain Name Server.
34. iterator_apply - Call a function for every element in an iterator - PHP.
35. openssl private encrypt.
36. openssl_pkcs12_read.
37. mb_check_encoding.
38. imagegrabwindow.
39. imagealphablending.
40. Gets options from the command line argument list.
41. Embeds binary IPTC data into a JPEG image.
42. session_set_save_handler.
43. mcrypt_encrypt.
44. imagegrabscreen.
45. imagecreatefromjpeg.
46. stat Gives information about a file - PHP.
47. fsockopen Open Internet or Unix domain socket connection- PHP.
48. intval - Get Integer value from string in PHP.
49. register_shutdown_function.
50. setcookie - Store Cookie in Browser with PHP.
51. header_remove - Remove the Header.
52. proc_open.
53. ucwords - Uppercase the first character of each word in a string.
54. getimagesize -Get the size of an image - PHP.
55. phpinfo - Outputs information about PHP's configuration.
56. spl_autoload_register.
57. json_encode - Returns the JSON representation of a value.
58. mcrypt_decrypt.
59. PHP Magic Methods with Examples.