в 10:37, 26 мая 2010

2010-05-26T10:37:34Z

Admin: 1 версия

2010-05-26T07:06:21Z

1 версия

Новая страница

==function mysql_fetch_array() accomplishes the same result as mysql_fetch_row(), by default it assigns a returned row to an associative array.==



<source lang="html4strict">

array mysql_fetch_array (int result [, result_type])
<?
@mysql_connect("localhost", "root","") or die("Could not connect to MySQL server!");
@mysql_select_db("mydatabase") or die("Could not select database!");
$query = "SELECT * FROM mytable";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) :
print $row["id"];
endwhile;
mysql_close();
?>

</source>

==Using the mysqli_fetch_array() Function==



<source lang="html4strict">

<?php
$link = mysqli_connect("localhost", "username", "password");
if(!$link) {
trigger_error("Could not connect to the database", E_USER_ERROR);
}
mysqli_select_db($link, "myDatabase");
$result = mysqli_query("SELECT first, last FROM members");
if(!$result) {
trigger_error("Could not perform the specified query", E_USER_ERROR);
}
echo "<TABLE><TR><TD>First Name</TD><TD>Last Name</TD></TR>";
while($row = mysqli_fetch_array($result)) {
echo "<TR>";
echo "<TD>{$row["first"]}</TD><TD>{$row["last"]}</TD>";
echo "</TR>";
}
echo "</TABLE>;
mysqli_close($link);
?>

</source>

← Предыдущая	Версия 10:37, 26 мая 2010
(нет различий)

PHP/MySQL Database/mysqli fetch array - История изменений

в 10:37, 26 мая 2010

Admin: 1 версия