php pdo错误模式改为异常模式,6-8 PDO默认错误模式为ERRMODE_EXCEPTION

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

}

```