mysqli_fetch_array in php code example
Example 1: mysql_fetch_array php
<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Impossible de se connecter : " . mysql_error());
mysql_select_db("mydb");
$result = mysql_query("SELECT id, name FROM mytable");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID : %s Nom : %s", $row[0], $row[1]);
}
mysql_free_result($result);
?>
Example 2: mysqli load result into array
$resource = $db->query("SELECT * FROM users WHERE userid = '".$userid."'");
while($row = $resource->fetch_array()) { $the_rows[] = $row; }