<?php
header("Content-type: text/html; charset=gb2312");
$host="localhost";
$user="root";
$pwd="";
$dbnames="news";
$sqls="选择 id,title from news order by id desc limit 0,5";
//以下是mySqli各种方法及mySqli预处理
$mysqli=new mysqli($host,$user,$pwd,$dbnames);
$mysqli->query("set names gb2312");
//MYSQLi操作
$rows=$mysqli->query($sqls);//形成结果集,结果集不能直接使用,
$rs=$rows->fetch_all(MYSQLI_ASSOC);//一次性取出
var_dump($rs);
echo "<hr>";
$rows->data_seek(0);//指针返回头部
while($rs=$rows->fetch_array(MYSQLI_ASSOC)){//单条取出
var_dump($rs);
}
$rows->data_seek(0);//指针返回头部
echo "<hr>";
while($rs=$rows->fetch_array(MYSQLI_ASSOC)){//单条取出,用数组存据
$rm[]=$rs;
}
var_dump($rm);
?>