php mysqli_fetch_row()函数使用实例

mysqli_fetch_row()介绍

mysqli_fetch_row()函数以索引数组的方式返回结果集中当前行的数据。

语法：

mysqli_fetch_row(result);

参数：

mysqli_fetch_row()实例

这里介绍两个实例，一个是基于面向对象的实例，另一个是基本面向过程的实例。

1、mysqli_fetch_row()基本面向过程的实例

<?php 
/*   http://www.manongjc.com   */
$con=mysqli_connect(\"localhost\",\"root\",\"\",\"db\"); 
if (mysqli_connect_errno($con)) 
{ 
    echo \"Unable to connect! \" . mysqli_connect_error(); 
} 

$query = \"SELECT productid, name, price FROM product ORDER BY name\";
$result = mysqli_query($con,$query);

while($row=mysqli_fetch_row($result)){
    $name = $row[1];
    $productid = $row[0];
    $price = $row[2];
    echo \"($productid) $name: $price <br />\";
}
mysqli_free_result($result);
mysqli_close($con);
?>

2、mysqli_fetch_row()基本面向对象的实例

<?php

$mysqli = new mysqli(\'localhost\',\'root\',\'\',\'db\');

if (mysqli_connect_errno()){
	die(\'Unable to connect!\'). mysqli_connect_error();
}

$query = \"SELECT productid, name, price FROM product ORDER BY name\";
$result = $mysqli->query($query);
while (list($productid,$name,$price) = $result->fetch_row())
{
    echo \"($productid) $name: $price <br />\";
}
/*   http://www.manongjc.com/article/1186.html   */
$mysqli->close(); 
?>

注意使用面向对象编程时，使用$result->fetch_row()，而不是mysqli_fetch_row()。