PHP 忒聊
綴豖
ヶ輛
mysql_fetch_field
(PHP 3, PHP 4)
Description
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:
name - column name
table - name of the table the column belongs to
max_length - maximum length of the column
not_null - 1 if the column cannot be NULL
primary_key - 1 if the column is a primary key
unique_key - 1 if the column is a unique key
multiple_key - 1 if the column is a non-unique key
numeric - 1 if the column is numeric
blob - 1 if the column is a BLOB
type - the type of the column
unsigned - 1 if the column is unsigned
zerofill - 1 if the column is zero-filled
瞰赽 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().
綴豖
れ萸
ヶ輛
mysql_fetch_assoc
奻珨撰
mysql_fetch_lengths