php mysql_fetch_row 用法_php mysqli_fetch_row()函数使用实例

mysqli_fetch_row()介绍

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

语法：

mysqli_fetch_row(result);

参数：

参数

描述

result

必需，结果集标识符。一般由mysqli_query()函数执行sql返回

mysqli_fetch_row()实例

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

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

/* 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
";

}

mysqli_free_result($result);

mysqli_close($con);

?>

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

$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
";

}

/* http://www.manongjc.com/article/1186.html */

$mysqli->close();

?>

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