mysql_fetch_array

mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both.

Description

array mysql_fetch_array ( resource result [, int result_type])

דוגמה 1 .






דוגמה 2 . mysql_fetch_array with MYSQL_NUM

 
?php

 
mysql_connect(

 
"localhost"

 
,

 
"mysql_user"

 
,

 
"mysql_password"

 
)

 
or

 
die("could

 
not

 
connect")

 
;

 
mysql_select_db("mydb")

 
;

 
$result

 
=

 
mysql_query("SELECT

 
id

 
,

 
name

 
FROM

 
mytable")

 
;

 
while

 
($row

 
=

 
mysql_fetch_array($result

 
,

 
MYSQL_NUM)

 
)

 
{

 
printf

 
("ID

 
:

 
%s

 
Name

 
:

 
%s"

 
,

 
$row[0]

 
,

 
$row[1])

 
;

 
}

 
mysql_free_result($result)

 
;

 
?



דוגמה 3 . mysql_fetch_array with MYSQL_ASSOC

 
?php

 
mysql_connect(

 
"localhost"

 
,

 
"mysql_user"

 
,

 
"mysql_password"

 
)

 
or

 
die("could

 
not

 
connect")

 
;

 
mysql_select_db("mydb")

 
;

 
$result

 
=

 
mysql_query("SELECT

 
id

 
,

 
name

 
FROM

 
mytable")

 
;

 
while

 
($row

 
=

 
mysql_fetch_array($result

 
,

 
MYSQL_ASSOC)

 
)

 
{

 
printf

 
("ID

 
:

 
%s

 
Name

 
:

 
%s"

 
,

 
$row["id"]

 
,

 
$row["name"])

 
;

 
    }

 
mysql_free_result($result)

 
;

 
?



דוגמה 4 . mysql_fetch_array with MYSQL_BOTH

 
?php

 
mysql_connect(

 
"localhost"

 
,

 
"mysql_user"

 
,

 
"mysql_password"

 
)

 
or

 
die("could

 
not

 
connect")

 
;

 
mysql_select_db("mydb")

 
;

 
$result

 
=

 
mysql_query("SELECT

 
id

 
,

 
name

 
FROM

 
mytable")

 
;

 
while

 
($row

 
=

 
mysql_fetch_array($result

 
,

 
MYSQL_BOTH)

 
)

 
{

 
printf

 
("ID

 
:

 
%s

 
Name

 
:

 
%s"

 
,

 
$row[0]

 
,

 
$row["name"])

 
;

 
    }

 
mysql_free_result($result)

 
;

 
?