(PHP3 , PHP4 )
mysql_fetch_field --
Get column information from a result and return as an object
Description
object mysql_fetch_field (int 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:
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
Példa 1. Mysql_fetch_field() 1
2 <?php
3 mysql_connect ($host, $user, $password)
4 or die ("Could not connect");
5 $result = mysql_db_query ("database", "select * from table")
6 or die ("Query failed");
7 # get column metadata
8 $i = 0;
9 while ($i $lt; mysql_num_fields ($result)) {
10 echo "Information for column $i:<BR>\n";
11 $meta = mysql_fetch_field ($result);
12 if (!$meta) {
13 echo "No information available<BR>\n";
14 }
15 echo "<PRE>
16 blob: $meta -> blob
17 max_length: $meta -> max_length
18 multiple_key: $meta -> multiple_key
19 name: $meta -> name
20 not_null: $meta -> not_null
21 numeric: $meta -> numeric
22 primary_key: $meta -> primary_key
23 table: $meta -> table
24 type: $meta -> type
25 unique_key: $meta -> unique_key
26 unsigned: $meta -> unsigned
27 zerofill: $meta -> zerofill
28 </PRE>";
29 $i++;
30 }
31 mysql_free_result ($result);
32 ?>
33 |
|
See also mysql_field_seek().