What is mysql_fetch_field() function in PHP?
How does mysql_fetch_field() works?
<?php //Attempt to connect to the default database server $link = mysql_connect("mysql_host", "mysql_user", "mysql_password")or die ("Could not connect"); //select database if (!mysql_select_db("my_database", $link)) {echo " ERROR NO: " . mysql_errno($link) . "n"; } // Simple Select query $query = "SELECT * FROM my_table";$res=mysql_query($query,$link); /* get column metadata */ echo "Information for column 0:n";$meta = mysql_fetch_field($res,0); if (!$meta) { echo "No information availablen"; } echo" 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"; mysql_free_result($res); ?> |
<?php /* get column metadata */ $i = 0;while ($i < mysql_num_fields($res)) { echo "Information for column $i:n"; $meta = mysql_fetch_field($res); if (!$meta) { echo "No information availablen"; } echo" 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"; $i++; } mysql_free_result($res); ?> Replace the above code in the previous example to display field information of all the fields. |