pdo

pdo的基本操作

<?php

$dsn = 'mysql:dbname=itcast_shop;host=127.0.0.1;port=3306';
$username = 'root';
$password = '123456';
$pdo = new PDO($dsn, $username, $password);

//var_dump($pdo);

$sql  = "select * from it_category where 1";
$stmt = $pdo->query($sql);

$list = $stmt->fetchAll(PDO::FETCH_ASSOC);
$list = $stmt->fetchAll(PDO::FETCH_NUM);
$list = $stmt->fetchAll(PDO::FETCH_BOTH);
echo '<pre>';
var_dump($list);

$stmt = $pdo = null;

常用函数

<?php
$dsn = 'mysql:dbname=itcast_shop;host=127.0.0.1;port=3306';
$username = 'root';
$password = '123456';
$pdo = new PDO($dsn, $username, $password);


$sql = "insert into it_admin (admin_id, admin_name, admin_pass) values (null, 'itcast', md5('1234abcd'))";
$rows = $pdo->exec($sql);

var_dump($rows);
echo '<br>';
echo $pdo->lastInsertID();

错误模式

<?php

//
//$link = mysql_connect('127.0.0.1', 'root', '123456');
//
//$sql = "show database";
//if(!mysql_query($sql)) {
//	echo mysql_error();
//}

$dsn = 'mysql:dbname=itcast_shop;host=127.0.0.1;port=3306';
$username = 'root';
$password = '123456';
$pdo = new PDO($dsn, $username, $password);
//设置错误模式：
//$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
//$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

echo '<pre>';
try {
	$sql = 'show database';
	if (!$pdo->query($sql)) {
		echo $pdo->errorCode();
		echo '<br>';
		var_dump($pdo->errorInfo());
	}
} catch (PDOException $e) {
	echo $e->getMessage();

异常的几种方法

<?php
try {
	$price = 1234;
	if ($price > 1000) {
		throw new Exception('价格太高');
	}
} catch (Exception $e) {

//	var_dump($e);
	echo $e->getMessage();
}