数据库抽象层PDO

	// 1.数据源
	$dsn = "mysql:host={$config['db_host']};dbname={$config['db_name']};charset=utf8;port=3306";

	// 2.实例化PDO对象
	$pdo = new PDO($dsn,$config['db_user'],$config['db_pass']);

	//3.设置错误模式
	// $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_WARNING);
	$pdo->setAttribute(3,1);
	// 4.准备sql
	$sql = "select `id`,`name`,`money` from `m_user` where `id` >= :id";
	// 5.预处理
	$stmt = $pdo->prepare($sql);
	$post = ['id' => 1];
	// 6.执行
	$stmt->execute($post);
	// 7.获取数据
	$list = $stmt->fetchAll(2);
	// $stmt->closeCursor(); // 8.关闭连接
	// =======================================================
	
	// 插入数据
	$sql = "insert into `m_user`(`name`,`pass`,`money`) values(:name,:pass,:money)";
	$stmt = $pdo->prepare($sql);
	// 冒号占位符的自动绑定
	$data = [
		'name' => 'xiaoping',
		'pass' => 3123,
		'money' => 10
	];
	$bool = $stmt->execute($data);
	// =======================================================
	
	// 编辑数据
	$sql = "update `m_user` set `pass` = :pass , `money` = :money where `id` = :id";

	$stmt = $pdo->prepare($sql);// 5.执行预处理

	$data = [
		'money' => 89899999,
		'pass' => '3123123',
		'id' => 18
	];

	$bool = $stmt->execute($data);
	// =======================================================
	
	//7.查看影响数据
	echo '最后插入ID：' .$pdo->lastInsertId();
	echo '受影响行：' . $stmt->rowCount();
	// 在项目中，我们可以关闭错误，直接判断错误信息就可以了
	echo '错误代码：' . $stmt->errorCode();
	echo '错误信息：' ;
	$list = $stmt->errorInfo();