**一.創建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(); } ```