<?php
 header("Content-type: text/html; charset=gb2312"); 
$host="localhost";
$user="root";
$pwd="";
$dbnames="news";

$sql="inserts into news(title,hit) values(?,?)";
$sqls="selects id,title from news order by id desc  limit 0,3";
$str="updates news set title=?,hit=? where id>?";
$dels="deletes from news";
//以下是mySqli各种方法及mySqli预处理
$mysqli=new mysqli($host,$user,$pwd,$dbnames);
$mysqli->query("set names gb2312");
//含参数的MYSQLi预处理，插入
$stmt=$mysqli->prepare($sql);
$hit=10;
$title="bkbdkbdkbd";
$stmt->bind_param("si",$title,$hit);
$stmt->execute();

//MYSQLi正常操作
$rows=$mysqli->query($sqls);
$rs=$rows->fetch_all(MYSQL_ASSOC);
var_dump($rs);
echo "<hr>";

//以下是PDO各种方法及PDO预处理
$mypdo=new PDO("mysql:host=$host;dbname=$dbnames","$user","");
$mypdo->query("set names gb2312");
//PDO类操作
$stmt=$mypdo->query($sqls);//静态对象，可直接以二维数组方式输出
$rows=$stmt->fetchAll();//从结果集中取出二维数组
var_dump($rows);
echo "<hr>";
//含参数的PDO预处理，修改
$stmt=$mypdo->prepare($str);
$stmt->execute(array('hjf','4',10));
//不含参数的PDO预处理，查询
$stmt=$mypdo->prepare($sqls);
$stmt->execute();
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
echo "<hr>";
//不含参数的PDO预处理，删除
$stmt=$mypdo->prepare($dels);
$stmt->execute();
//含参数的PDO预处理，插入
$stmt=$mypdo->prepare($sql);
$hit=565;
$title='wanzhai';
$stmt->bindParam(1,$title,PDO::PARAM_STR);
$stmt->bindParam(2,$hit,PDO::PARAM_INT);
$stmt->execute();
//含参数的PDO预处理，查询
$stmt=$mypdo->prepare("selects id,title from news where id>?");
$stmt->execute(array(1));
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
echo "<hr>";
?>