mysql fetch field_PHP mysql_fetch_field() 函数

例子

$con = mysql_connect("localhost", "hello", "321");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

$db_selected = mysql_select_db("test_db",$con);

$sql = "SELECT * from Person";

$result = mysql_query($sql,$con);

while ($property = mysql_fetch_field($result))

{

echo "Field name: " . $property->name . "
";

echo "Table name: " . $property->table . "
";

echo "Default value: " . $property->def . "
";

echo "Max length: " . $property->max_length . "
";

echo "Not NULL: " . $property->not_null . "
";

echo "Primary Key: " . $property->primary_key . "
";

echo "Unique Key: " . $property->unique_key . "
";

echo "Mutliple Key: " . $property->multiple_key . "
";

echo "Numeric Field: " . $property->numeric . "
";

echo "BLOB: " . $property->blob . "
";

echo "Field Type: " . $property->type . "
";

echo "Unsigned: " . $property->unsigned . "
";

echo "Zero-filled: " . $property->zerofill . "
";

}

mysql_close($con);

?>

输出：

Field name: LastName

Table name: Person

Default value:

Max length: 8

Not NULL: 0

Primary Key: 0

Unique Key: 0

Mutliple Key: 0

Numeric Field: 0

BLOB: 0

Field Type: string

Unsigned: 0

Zero-filled: 0

Field name: FirstName

Table name: Person

Default value:

Max length: 7

Not NULL: 0

Primary Key: 0

Unique Key: 0

Mutliple Key: 0

Numeric Field: 0

BLOB: 0

Field Type: string

Unsigned: 0

Zero-filled: 0

Field name: City

Table name: Person

Default value:

Max length: 9

Not NULL: 0

Primary Key: 0

Unique Key: 0

Mutliple Key: 0

Numeric Field: 0

BLOB: 0

Field Type: string

Unsigned: 0

Zero-filled: 0

Field name: Age

Table name: Person

Default value:

Max length: 2

Not NULL: 0

Primary Key: 0

Unique Key: 0

Mutliple Key: 0

Numeric Field: 1

BLOB: 0

Field Type: int

Unsigned: 0

Zero-filled: 0