<? $pdo = new PDO('mysql:host=localhost;port=3336;dbname=TD_OA', 'root', 'myoa888'); //$pdo = new PDO('mysql:host=localhost;port=3336;dbname=TD_OA', 'root', 'myoa888','array(PDO::ATTR_PERSISTENT => true)'); //持久連接配接 $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //錯誤的話抛出異常 $pdo->exec('set names gb2312');
$query="select user_id,uid,user_name from user"; $rs = $pdo -> query($query); while($row = $rs -> fetch()){ //echo $row["user_id"]."<br>"; //print_r($row); } $num=$rs->rowCount(); echo $num."<br>";//查詢個數 $rs1 = $pdo -> query($query); $row1=$rs1->fetchAll(); foreach ($row1 as $rs) { $id = $rs['user_id']; // echo $id."<br>"; } // echo "<pre>"; //print_r($row1); // echo "</pre>"; $num1=$rs1->rowCount(); echo $num1."<br>";//查詢個數 $rs2 = $pdo->query("SELECT user_name FROM user where user_id='admin'");//查詢唯一的最後一個的某一列 $col = $rs2->fetchColumn(); echo $col."<br>";
$query="select * from company_sun where company='".$zfjg."' and leibie_id='".$i."' and leibie='".$leibie."'"; //echo $query."<br>"; $res = $pdo->prepare($query); //$res->exec(); $res->execute(); $num_rows=$res->rowCount();//取數 //修改 $query3="update user set user_name='系統管理者' where user_id='admin'"; $stmt = $pdo->prepare($query3); $stmt->execute(); echo $stmt->rowCount()."<br>"; //傳回影響的行數 $query4="update user set user_name='系統管理者' where user_id='admin'"; $stmt4 = $pdo->exec($query4); // 傳回影響的行數了 echo $stmt4."<br>";
$sql = "DELETE FROM `user` WHERE `user_id` LIKE 'kevin_'"; //kevin% $stmt = $pdo->prepare($sql); $stmt->execute(); echo $stmt->rowCount()."<br>";//删除同修改
//新增 $pdo -> exec("insert into db_demo(name,content) values('title','content')"); echo "插入成功!"; echo $pdo -> lastinsertid(); //$sql = "INSERT INTO `user` SET `login`=:login AND `password`=:password"; $sql = "INSERT INTO `user` (`login` ,`password`)VALUES (:login, :password)"; $stmt = $pdo->prepare($sql); $stmt->execute(array(':login'=>'kevin2',':password'=>'')); echo $pdo->lastinsertid(); //新增 $sql = "INSERT INTO lailu (ip,times) VALUES ('".$iipp."', '". date('Y-m-d H:i:s')."')"; $stmt = $pdo->prepare($sql); $stmt->execute(); echo $pdo->lastinsertid();
?> PDO::query() 主要是用于有記錄結果傳回的操作,特别是SELECT操作 PDO::exec() 主要是針對沒有結果集合傳回的操作,如INSERT、UPDATE等操作 PDO::lastInsertId() 傳回上次插入操作,主鍵列類型是自增的最後的自增ID PDOStatement::fetch() 是用來擷取一條記錄 PDOStatement::fetchAll() 是擷取所有記錄集到一個中