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.

PHP mktime() Function - Get Unix timestamp for a date

int mktime ([ int $hour = date("H") [, int $minute = date("i") [, int $second = date("s") [, int $month = date("n") [, int $day = date("j") [, int $year = date("Y") [, int $is_dst = -1 ]]]]]]] )

Get Unix timestamp for a date

Returns the Unix timestamp corresponding to the arguments given. This timestamp is a long integer containing the number of seconds between the Unix Epoch (January 1 1970 00:00:00 GMT) and the time specified.


<?php// Set the default timezone to use. Available as of PHP 5.1date_default_timezone_set('UTC');// Prints: July 1, 2000 is on a Saturdayecho "July 1, 2000 is on a " . date("l", mktime(0, 0, 0, 7, 1, 2000));// Prints something like: 2006-04-05T01:02:03+00:00echo date('c', mktime(1, 2, 3, 4, 5, 2006));?>

5.3.0 mktime() now throws E_DEPRECATED notice if the is_dst parameter is used. 5.1.0 The is_dst parameter became deprecated. Made the function return FALSE on error, instead of -1. Fixed the function to accept the year, month and day to be all passed as zero. 5.1.0 When called with no arguments, mktime() throws E_STRICT notice. Use the time() function instead. 5.1.0 Now issues the E_STRICT and E_NOTICE time zone errors.

Syntax

mktime(hour,minute,second,month,day,year,is_dst);

Parameter	Description
hour	Optional. Specifies the hour
minute	Optional. Specifies the minute
second	Optional. Specifies the second
month	Optional. Specifies the month
day	Optional. Specifies the day
year	Optional. Specifies the year
is_dst	Optional. Set this parameter to 1 if the time is during daylight savings time (DST), 0 if it is not, or -1 (the default) if it is unknown. If it's unknown, PHP tries to find out itself (which may cause unexpected results).

Best Related Posts are Following:

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