**一.創建sqlite3數據庫php8.db** ~~~ sqlite3 /sqlite3/php8.db ~~~ **二.sql基礎操作** 1.創建表user ~~~ create table user(id integer PRIMARY KEY AUTOINCREMENT,name text,age integer); ~~~ 2.插入數據 ~~~ insert into user values(1,'user1',20); insert into user values(2,'user2',22); ~~~ 3.查詢數據 ~~~ select * from user; ~~~ **三.linux下查看數據庫文件(十六進制)** ~~~ xxd php8.db ~~~ **四.php pdo操作sqlite3 php8數據庫** ~~~ $pdo = new PDO('sqlite:/sqlite3/php8.db'); ~~~ **五.pdo報錯類型PDO::ATTR\_ERRMODE** ~~~ 1.PDO::ERRMODE_SILENT 0 2.PDO::ERRMODE_WARNING 1 3.PDO::ERRMODE_EXCEPTION 2 ~~~ **六.pdo設置錯誤類型** 1.設置 ~~~ $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_WARNING); ~~~ 2.獲取 ~~~ $pdo->getAttribute(PDO::ATTR_ERRMODE); ~~~ **七.pdo操作user表** ~~~ $sql='select * from user2'; $smt=$pdo->prepare($sql); $smt->execute(); $arr=$smt->fetchAll(PDO::FETCH_ASSOC); ~~~ **八.pdo操作異常捕捉** ~~~ try{ $pdo=new PDO('sqlite:/sqlite3/php8.db'); $smt=$pdo->prepare('select * from user2'); $smt->execute(); $rows=$smt->fetchAll(PDO::FETCH_ASSOC); }catch(PDOException $e){ echo $e->getMessage(); } ~~~