mysql_fetch_field

mysql_fetch_field -- Get column information from a result and return as an object

Description

object mysql_fetch_field ( resource result [, int field_offset])



דוגמה 1 . mysql_fetch_field( )

 
?php

 
mysql_connect(

 
'localhost:3306'

 
,

 
$user

 
,

 
$password

 
)

 
or

 
die

 
("Could

 
not

 
connect")

 
;

 
mysql_select_db("database")

 
;

 
$result

 
=

 
mysql_query("select

 
*

 
from

 
table"

 
)

 
or

 
die("Query

 
failed")

 
;

 
/

 
*

 
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)

 
;

 
?