mysqli_fetch_array() 函数示例:
<?php $conn=mysqli_connect("localhost","username","password","db"); $query="SELECT students, marks FROM class"; $result=mysqli_query($conn,$query); while ($arr=mysqli_fetch_array($result)) { echo $arr['students']." ".$arr['marks']; echo "<br />"; } mysqli_close($conn); ?>
在mysqli_fetch_object()
函数中,我们可以对象的形式获取查询的结果数据行。
on it road.com
mysqli_fetch_object() 函数示例:
<?php $conn=mysqli_connect("localhost","username","password","db"); $query="SELECT students, marks FROM class"; $result=mysqli_query($conn,$query); while ($obj=mysqli_fetch_object($result)) { echo $obj->students." ".$obj->marks; echo "<br />"; } mysqli_close($conn); ?>
这两个 PHP 函数都用于从 MYSQL 数据库中获取数据,但是 mysqli_fetch_array()
和 mysqli_fetch_object()
的输出格式有所不同。
使用 mysqli_fetch_array() 函数,我们可以以数组的形式获取查询的结果数据行。
日期:2020-09-17 00:10:24 来源:oir作者:oir