Description
object
mysql_fetch_field ( resource
result [, int field_offset])
Returns an object containing field information.
mysql_fetch_field() can be used
in order to obtain information about fields in a certain
query result. If the field offset isn't specified, the next
field that wasn't yet retrieved by
mysql_fetch_field() is retrieved.
The properties of the object are:
範例 1.
mysql_fetch_field()
?php
mysql_connect('localhost:3306', $user, $password)
or die("Could not connect: " . mysql_error());
mysql_select_db("database");
$result = mysql_query("select * from table")
or die("Query failed: " . 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);
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);
?
|
|
See also mysql_field_seek().