实例代码如下:

<?php   
   /*   http://www.manongjc.com/article/1195.html   */
   $mysqli = new mysqli();
   $mysqli->connect(\"127.0.0.1\", \"root\",\"\", \"mydata \");

   $query = \"SELECT productid, name, price FROM product ORDER by name\";
   $mysqli->real_query($query);
   $result = $mysqli->store_result();

   while(list($productid, $name, $price) = $result->fetch_row())
      echo \"($productid) $name: $price <br />\";

   $result->free();
?>
收藏 打印