无涯教程-PHP - mysqli fetch object函数

mysqli fetch object - 语法

mysqli_fetch_object(result,classname,params);

它以对象的形式返回输出集的当前行。

mysqli fetch object - 返回值

它返回所提取行的字符串属性，如果输出集中没有更多的行，则返回NULL

mysqli fetch object - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","user","password","db");
if (mysqli_connect_errno($connection_mysql)){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="SELECT name FROM emp";
if ($result</span><span class="pun">=</span><span class="pln">mysqli_query</span><span class="pun">(</span><span class="pln">$connection_mysql,sql</span><span class="pun">)){</span><span class="pln">
      </span><span class="kwd">while</span><span class="pln"> </span><span class="pun">(</span><span class="pln">obj=mysqli_fetch_object(result</span><span class="pun">)){</span><span class="pln">
         </span><span class="kwd">print</span><span class="pln"> obj->name;
print "\n";
}
mysqli_free_result(result</span><span class="pun">);</span><span class="pln">
   </span><span class="pun">}</span><span class="pln">
   mysqli_close</span><span class="pun">(</span><span class="pln">connection_mysql);
?>

参考链接

www.learnfk.com/php/php-mys…