[TOC] ## php5.6 pdo 適配文件 鏈接: https://pan.baidu.com/s/1mpJEXmWCixJ0OM9HV-UL9A 提取碼: uij7 ## pdo ### 連接數據庫 ``` $dsn = 'kdb:host=192.168.0.141;dbname=ANTDBMS;port=54321'; $user = 'SYSTEM'; $password = 'system'; $dbh = null; $dbh = new PDO($dsn, $user, $password, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));//錯誤時候拋出異常 ``` ### 添加 ``` try{ //預處理 $stmt = $dbh->prepare("INSERT INTO SYS_ADMIN (user_id, user_login, user_name,user_pwd) VALUES (?, ?, ?, ?)"); $id = 4; $fp = "123"; $stmt->bindParam(1, $id); $stmt->bindParam(2, $fp); $stmt->bindParam(3, $fp); $stmt->bindParam(4, $fp); $res = $stmt->execute(); var_dump($res); //不進行預處理 $dbh->exec("insert into sys_admin(user_id,user_login,user_name,user_pwd) values (6,'123','12321','123')"); }catch(Exception $e){ var_dump($e->getMessage()); } ``` ### 查看 ``` $PDOStatement = $dbh->query("select * from sys_admin",PDO::FETCH_ASSOC); foreach($PDOStatement as $v){ print_r($v); } ```