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=mysqli_query($connection_mysql,$sql)){
      while ($obj=mysqli_fetch_object($result)){
         print $obj->name;
         print "\n";
      }
      mysqli_free_result($result);
   }
   mysqli_close($connection_mysql);
?>