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