{"id":79,"date":"2017-12-01T15:58:04","date_gmt":"2017-12-01T07:58:04","guid":{"rendered":"http:\/\/www.cheln.com\/index.php\/2017\/12\/01\/php-pdo"},"modified":"2017-12-01T15:58:04","modified_gmt":"2017-12-01T07:58:04","slug":"php-pdo","status":"publish","type":"post","link":"http:\/\/www.cheln.com\/index.php\/2017\/12\/01\/php-pdo\/","title":{"rendered":"PHP PDO"},"content":{"rendered":"
\n
1.<\/div>\n
\n
\n
\u7c21\u4ecb<\/div>\n
\u7c21\u8ff0\uff1aPHP \u8cc7\u6599\u7269\u4ef6 \uff08PDO\uff09 \u64f4\u5c55\u70baPHP\u5b58\u53d6\u8cc7\u6599\u5eab\u5b9a\u7fa9\u4e86\u4e00\u500b\u8f15\u91cf\u7d1a\u7684\u4e00\u81f4\u63a5\u53e3<\/div>\n
\u7279\u8272\uff1aPDO \u63d0\u4f9b\u4e86\u4e00\u500b \u8cc7\u6599\u5b58\u53d6 \u62bd\u8c61\u5c64,\u4e0d\u7ba1\u4f7f\u7528\u54ea\u7a2e\u8cc7\u6599\u5eab,\u90fd\u53ef\u4ee5\u7528\u76f8\u540c\u7684\u51fd\u6578(\u65b9\u6cd5)\u4f86\u67e5\u8a62\u548c\u5b58\u53d6\u8cc7\u6599<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
2.<\/div>\n
\n
\n
\u9023\u7d50\u8207\u7ba1\u7406<\/div>\n
\u9023\u63a5\u5230 MySQL<\/strong><\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
$dbh<\/code>\u00a0=\u00a0<\/code>new<\/code>\u00a0PDO(<\/code>'mysql:host=localhost;dbname=test'<\/code>,\u00a0<\/code>$user<\/code>,\u00a0<\/code>$pass<\/code>);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\u8655\u7406\u9023\u7d50\u932f\u8aa4<\/b><\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n<\/td>\n
\n
\n
try<\/code> {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>$dbh<\/code> = <\/code>new<\/code> PDO(<\/code>'mysql:host=localhost;dbname=test'<\/code>, <\/code>$user<\/code>, <\/code>$pass<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>foreach<\/code>(<\/code>$dbh<\/code>->query(<\/code>'SELECT * from FOO'<\/code>) <\/code>as<\/code> $row<\/code>) {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>print_r(<\/code>$row<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>$dbh<\/code> = null;<\/code><\/div>\n
} <\/code>catch<\/code> (PDOException <\/code>$e<\/code>) {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>print<\/code> \"Error!: \"<\/code> . <\/code>$e<\/code>->getMessage() . <\/code>\"<br\/>\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>die<\/code>();<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
<\/div>\n
\u95dc\u9589\u4e00\u500b\u9023\u7d50<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
$dbh<\/code> = null;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\u6301\u7e8c\u9023\u7dda<\/div>\n
\u512a\u9ede\uff1a\u7121\u9700\u6bcf\u6b21\u5efa\u7acb\u4e00\u500b\u65b0\u7684\u9023\u7d50\uff0c\u8b93web application \u66f4\u5feb<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
$dbh<\/code> = <\/code>new<\/code> PDO(<\/code>'mysql:host=localhost;dbname=test'<\/code>, <\/code>$user<\/code>, <\/code>$pass<\/code>, <\/code>array<\/code>(<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>PDO::ATTR_PERSISTENT => true<\/code><\/div>\n
));<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
3.<\/div>\n
\n
\n
\u4ea4\u6613\u8207\u81ea\u52d5\u63d0\u4ea4<\/div>\n
\u56db\u5927\u7279\u6027<\/div>\n
\u539f\u5b50\u6027\uff08Atomicity\uff09<\/div>\n
\u4e00\u81f4\u6027\uff08Consistency\uff09<\/div>\n
\u9694\u96e2\u6027\uff08Isolation\uff09<\/div>\n
\u6301\u4e45\u6027\uff08Durability\uff09<\/div>\n
<\/div>\n
\u5047\u5982\u8cc7\u6599\u5eab\u4e0d\u652f\u63f4Transactions\u53ef\u904b\u884c\u7684\u7a0b\u5f0f\u78bc<\/div>\n
\u555f\u52d5<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
PDO::beginTransaction()<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\u63d0\u4ea4<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
PDO::commit()<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
<\/div>\n
\u5012\u56de<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
PDO::rollBack()<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
<\/div>\n
\u4e00\u500b\u4ea4\u6613\u8655\u7406\u4f8b\u5b50<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n<\/td>\n
\n
\n
try<\/code> {<\/code><\/div>\n
\u00a0\u00a0<\/code>$dbh<\/code> = <\/code>new<\/code> PDO(<\/code>'odbc:SAMPLE'<\/code>, <\/code>'db2inst1'<\/code>, <\/code>'ibmdb2'<\/code>, <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>array<\/code>(PDO::ATTR_PERSISTENT => true));<\/code><\/div>\n
\u00a0\u00a0<\/code>echo<\/code> \"Connected\\n\"<\/code>;<\/code><\/div>\n
} <\/code>catch<\/code> (Exception <\/code>$e<\/code>) {<\/code><\/div>\n
\u00a0\u00a0<\/code>die<\/code>(<\/code>\"Unable to connect: \"<\/code> . <\/code>$e<\/code>->getMessage());<\/code><\/div>\n
}<\/code><\/div>\n
<\/div>\n
try<\/code> {\u00a0 <\/code><\/div>\n
\u00a0\u00a0<\/code>$dbh<\/code>->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>$dbh<\/code>->beginTransaction();<\/code><\/div>\n
\u00a0\u00a0<\/code>$dbh<\/code>-><\/code>exec<\/code>(<\/code>\"insert into staff (id, first, last) values (23, 'Joe', 'Bloggs')\"<\/code>);<\/code><\/div>\n
\u00a0\u00a0<\/code>$dbh<\/code>-><\/code>exec<\/code>(\"insert into salarychange (id, amount, changedate) <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>values (23, 50000, NOW())\");<\/code><\/div>\n
\u00a0\u00a0<\/code>$dbh<\/code>->commit();<\/code><\/div>\n
\u00a0\u00a0<\/code><\/div>\n
} <\/code>catch<\/code> (Exception <\/code>$e<\/code>) {<\/code><\/div>\n
\u00a0\u00a0<\/code>$dbh<\/code>->rollBack();<\/code><\/div>\n
\u00a0\u00a0<\/code>echo<\/code> \"Failed: \"<\/code> . <\/code>$e<\/code>->getMessage();<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
4.<\/div>\n
\n
\n
\u9810\u5148\u8a9e\u53e5\u8207\u5132\u5b58\u904e\u7a0b<\/div>\n
\u9810\u5148\u8a9e\u53e5\u7684\u63d2\u5165<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
$stmt<\/code> = <\/code>$dbh<\/code>->prepare(<\/code>\"INSERT INTO REGISTRY (name, value) VALUES (:name, :value)\"<\/code>);<\/code><\/div>\n
$stmt<\/code>->bindParam(<\/code>':name'<\/code>, <\/code>$name<\/code>);<\/code><\/div>\n
$stmt<\/code>->bindParam(<\/code>':value'<\/code>, <\/code>$value<\/code>);<\/code><\/div>\n
<\/div>\n
\/\/ \u63d2\u5165\u4e00\u884c<\/code><\/div>\n
$name<\/code> = <\/code>'one'<\/code>;<\/code><\/div>\n
$value<\/code> = 1;<\/code><\/div>\n
$stmt<\/code>->execute();<\/code><\/div>\n
<\/div>\n
\/\/\u00a0 \u7528\u4e0d\u540c\u7684\u503c\u63d2\u5165\u53e6\u4e00\u884c<\/code><\/div>\n
$name<\/code> = <\/code>'two'<\/code>;<\/code><\/div>\n
$value<\/code> = 2;<\/code><\/div>\n
$stmt<\/code>->execute();<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\u9810\u9632 SQL \u6ce8\u5165\u653b\u64ca<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n<\/td>\n
\n
\n
$stmt<\/code> = <\/code>$dbh<\/code>->prepare(<\/code>\"SELECT * FROM REGISTRY where name = ?\"<\/code>);<\/code><\/div>\n
if<\/code> (<\/code>$stmt<\/code>->execute(<\/code>array<\/code>(<\/code>$_GET<\/code>[<\/code>'name'<\/code>]))) {<\/code><\/div>\n
\u00a0\u00a0<\/code>while<\/code> (<\/code>$row<\/code> = <\/code>$stmt<\/code>->fetch()) {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>print_r(<\/code>$row<\/code>);<\/code><\/div>\n
\u00a0\u00a0<\/code>}<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\u8a2d\u5b9a \u9650\u5236 \u8f38\u5165\u8207\u8f38\u51fa \u578b\u614b<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
$stmt<\/code> = <\/code>$dbh<\/code>->prepare(<\/code>\"CALL sp_takes_string_returns_string(?)\"<\/code>);<\/code><\/div>\n
$value<\/code> = <\/code>'hello'<\/code>;<\/code><\/div>\n
$stmt<\/code>->bindParam(1, <\/code>$value<\/code>, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 4000); <\/code><\/div>\n
<\/div>\n
\/\/ \u8c03\u7528\u5b58\u50a8\u8fc7\u7a0b<\/code><\/div>\n
$stmt<\/code>->execute();<\/code><\/div>\n
<\/div>\n
print<\/code> \"procedure returned $value\\n\"<\/code>;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
<\/div>\n
\u6b63\u78ba\u7684LIKE\u4f7f\u7528<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
$stmt<\/code> = <\/code>$dbh<\/code>->prepare(<\/code>\"SELECT * FROM REGISTRY where name LIKE ?\"<\/code>);<\/code><\/div>\n
$stmt<\/code>->execute(<\/code>array<\/code>(<\/code>\"%$_GET[name]%\"<\/code>));<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
5.<\/div>\n
\n
\n
\u932f\u8aa4\u8207\u8655\u7406<\/div>\n
<\/div>\n
PDO::ERRMODE_SILENT<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
PDO::ERRMODE_SILENT<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u7c21\u55ae\u8a2d\u7f6e\u932f\u8aa4\u78bc\uff0c\u53ef\u4f7f\u7528<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
PDO::errorCode()<\/code><\/div>\n
PDO::errorInfo()<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\u6aa2\u67e5\u8a9e\u53e5\u8207\u8cc7\u6599\u5eab\u7269\u4ef6<\/div>\n
<\/div>\n
PDO::ERRMODE_WARNING<\/div>\n
\u4e3b\u8981\u529f\u80fd\uff1a\u767c\u51faE_WARNING\u8cc7\u8a0a\uff0c\u4e0d\u4e2d\u65b7\u61c9\u7528\u7a0b\u5f0f<\/div>\n
\u4f7f\u7528\u6642\u6a5f\uff1a\u6e2c\u8a66\u671f<\/div>\n
<\/div>\n
PDO::ERRMODE_EXCEPTION<\/div>\n
\u4e3b\u8981\u529f\u80fd\uff1a\u8a2d\u7f6e\u932f\u8aa4\u78bc\u3001\u4e1f\u51faPDOException\u7570\u5e38\u985e\u5225\uff0c\u8a2d\u7f6e\u4ed6\u7684\u5c6c\u6027\u4f86\u53cd\u6620\u932f\u8aa4\u7a0b\u5f0f\u78bc\u8207\u932f\u8aa4\u8a0a\u606f<\/div>\n
<\/div>\n
\u4e00\u500b\u7c21\u55ae\u7684pdo\u932f\u8aa4\u8655\u7406<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n<\/td>\n
\n
\n
$dsn<\/code> = <\/code>'mysql:dbname=testdb;host=127.0.0.1'<\/code>;<\/code><\/div>\n
$user<\/code> = <\/code>'dbuser'<\/code>;<\/code><\/div>\n
$password<\/code> = <\/code>'dbpass'<\/code>;<\/code><\/div>\n
<\/div>\n
try<\/code> {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>$dbh<\/code> = <\/code>new<\/code> PDO(<\/code>$dsn<\/code>, <\/code>$user<\/code>, <\/code>$password<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>$dbh<\/code>->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);<\/code><\/div>\n
} <\/code>catch<\/code> (PDOException <\/code>$e<\/code>) {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>echo<\/code> 'Connection failed: '<\/code> . <\/code>$e<\/code>->getMessage();<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
6.<\/div>\n
\n
\n
Large Objects<\/div>\n
\u4e3b\u8981\u7528\u65bc\u5927\u91cf\u8cc7\u6599\uff0c\u901a\u5e38\u662f4kb\u4ee5\u4e0a\uff0c\u53ef\u4f7f\u7528PDO::PARAM_LOB\u8655\u7406<\/div>\n
<\/div>\n
\u4f7f\u7528PDO::PARAM_LOB\u986f\u793a\u4e00\u5f35\u7167\u7247<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
$db<\/code> = <\/code>new<\/code> PDO(<\/code>'odbc:SAMPLE'<\/code>, <\/code>'db2inst1'<\/code>, <\/code>'ibmdb2'<\/code>);<\/code><\/div>\n
$stmt<\/code> = <\/code>$db<\/code>->prepare(<\/code>\"select contenttype, imagedata from images where id=?\"<\/code>);<\/code><\/div>\n
$stmt<\/code>->execute(<\/code>array<\/code>(<\/code>$_GET<\/code>[<\/code>'id'<\/code>]));<\/code><\/div>\n
$stmt<\/code>->bindColumn(1, <\/code>$type<\/code>, PDO::PARAM_STR, 256);<\/code><\/div>\n
$stmt<\/code>->bindColumn(2, <\/code>$lob<\/code>, PDO::PARAM_LOB);<\/code><\/div>\n
$stmt<\/code>->fetch(PDO::FETCH_BOUND);<\/code><\/div>\n
<\/div>\n
header(<\/code>\"Content-Type: $type\"<\/code>);<\/code><\/div>\n
fpassthru<\/code>(<\/code>$lob<\/code>);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
<\/div>\n
\u4f7f\u7528PDO::PARAM_LOB\u63d2\u5165\u4e00\u5f35\u7167\u7247<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
$db<\/code> = <\/code>new<\/code> PDO(<\/code>'odbc:SAMPLE'<\/code>, <\/code>'db2inst1'<\/code>, <\/code>'ibmdb2'<\/code>);<\/code><\/div>\n
$stmt<\/code> = <\/code>$db<\/code>->prepare(<\/code>\"insert into images (id, contenttype, imagedata) values (?, ?, ?)\"<\/code>);<\/code><\/div>\n
$id<\/code> = get_new_id(); <\/code>\/\/ \u8c03\u7528\u67d0\u4e2a\u51fd\u6570\u6765\u5206\u914d\u4e00\u4e2a\u65b0 ID<\/code><\/div>\n
<\/div>\n
\/\/ \u5047\u8bbe\u5904\u7406\u4e00\u4e2a\u6587\u4ef6\u4e0a\u4f20<\/code><\/div>\n
\/\/ \u53ef\u4ee5\u5728 PHP \u6587\u6863\u4e2d\u627e\u5230\u66f4\u591a\u7684\u4fe1\u606f<\/code><\/div>\n
<\/div>\n
$fp<\/code> = <\/code>fopen<\/code>(<\/code>$_FILES<\/code>[<\/code>'file'<\/code>][<\/code>'tmp_name'<\/code>], <\/code>'rb'<\/code>);<\/code><\/div>\n
<\/div>\n
$stmt<\/code>->bindParam(1, <\/code>$id<\/code>);<\/code><\/div>\n
$stmt<\/code>->bindParam(2, <\/code>$_FILES<\/code>[<\/code>'file'<\/code>][<\/code>'type'<\/code>]);<\/code><\/div>\n
$stmt<\/code>->bindParam(3, <\/code>$fp<\/code>, PDO::PARAM_LOB);<\/code><\/div>\n
<\/div>\n
$db<\/code>->beginTransaction();<\/code><\/div>\n
$stmt<\/code>->execute();<\/code><\/div>\n
$db<\/code>->commit();<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
7.<\/div>\n
\n
\n

PDO<\/h1>\n

PDO::beginTransaction<\/h1>\n
\u4e00\u500btransactions\u7c21\u55ae\u7684\u4f8b\u5b50<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
\/* \u958b\u59cb\u4e00\u500bTransaction\uff0c\u95dc\u9589\u81ea\u52d5\u63d0\u4ea4 *\/<\/code><\/div>\n
$dbh<\/code>->beginTransaction();<\/code><\/div>\n
<\/div>\n
\/* \u66f4\u6539\u8cc7\u6599\u5eab\u67b6\u69cb\u53ca\u8cc7\u6599 *\/<\/code><\/div>\n
$sth<\/code> = <\/code>$dbh<\/code>-><\/code>exec<\/code>(<\/code>\"DROP TABLE fruit\"<\/code>);<\/code><\/div>\n
$sth<\/code> = <\/code>$dbh<\/code>-><\/code>exec<\/code>(\"UPDATE dessert<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>SET name = <\/code>'hamburger'<\/code>\");<\/code><\/div>\n
<\/div>\n
\/* \u8b58\u5225\u51fa\u932f\u8aa4\u4e26\u5012\u56de\u66f4\u6539 *\/<\/code><\/div>\n
$dbh<\/code>->rollBack();<\/code><\/div>\n
<\/div>\n
\/* \u8cc7\u6599\u5eab\u9023\u63a5\u73fe\u5728\u8fd4\u56de\u5230\u81ea\u52d5\u63d0\u4ea4\u6a21\u5f0f *\/<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
<\/div>\n
PDO::commit<\/div>\n
\u4e00\u500b\u7c21\u55ae\u7684\u7bc4\u4f8b<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n<\/td>\n
\n
\n
\/* \u958b\u59cb\u4e00\u500bTransaction\uff0c\u95dc\u9589\u81ea\u52d5\u63d0\u4ea4 *\/<\/code><\/div>\n
$dbh<\/code>->beginTransaction();<\/code><\/div>\n
<\/div>\n
\/* \u5728\u5168\u6709\u6216\u5168\u7121\u7684\u57fa\u790e\u4e0a\u63d2\u5165\u591a\u884c\u8a18\u9304\uff08\u5168\u90e8\u63d2\u5165\uff0c\u5168\u90e8\u4e0d\u63d2\u5165\uff09 *\/<\/code><\/div>\n
$sql<\/code> = 'INSERT INTO fruit<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>(name, colour, calories)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>VALUES (?, ?, ?)';<\/code><\/div>\n
<\/div>\n
$sth<\/code> = <\/code>$dbh<\/code>->prepare(<\/code>$sql<\/code>);<\/code><\/div>\n
<\/div>\n
foreach<\/code> (<\/code>$fruits<\/code> as<\/code> $fruit<\/code>) {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>$sth<\/code>->execute(<\/code>array<\/code>(<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>$fruit<\/code>->name,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>$fruit<\/code>->colour,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>$fruit<\/code>->calories,<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>));<\/code><\/div>\n
}<\/code><\/div>\n
<\/div>\n
\/* \u63d0\u4ea4\u66f4\u6539 *\/<\/code><\/div>\n
$dbh<\/code>->commit();<\/code><\/div>\n
<\/div>\n
\/* \u73fe\u5728\u8cc7\u6599\u5eab\u9023\u63a5\u8fd4\u56de\u5230\u81ea\u52d5\u63d0\u4ea4\u6a21\u5f0f *\/<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
<\/div>\n
\n

PDO::__construct<\/h1>\n
\u5efa\u7acb\u4e00\u500b\u8cc7\u6599\u5eab\u9023\u7d50\u7684PDO\u5be6\u4f8b<\/div>\n
\u4e00\u500b\u7c21\u55ae\u7684\u4f8b\u5b50<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n<\/td>\n
\n
\n
\/* Connect to an ODBC database using driver invocation *\/<\/code><\/div>\n
$dsn<\/code> = <\/code>'mysql:dbname=testdb;host=127.0.0.1'<\/code>;<\/code><\/div>\n
$user<\/code> = <\/code>'dbuser'<\/code>;<\/code><\/div>\n
$password<\/code> = <\/code>'dbpass'<\/code>;<\/code><\/div>\n
<\/div>\n
try<\/code> {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>$dbh<\/code> = <\/code>new<\/code> PDO(<\/code>$dsn<\/code>, <\/code>$user<\/code>, <\/code>$password<\/code>);<\/code><\/div>\n
} <\/code>catch<\/code> (PDOException <\/code>$e<\/code>) {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>echo<\/code> 'Connection failed: '<\/code> . <\/code>$e<\/code>->getMessage();<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
<\/div>\n
PDO::errorCode<\/div>\n
\u4e00\u500b\u7c21\u55ae\u7684\u7bc4\u4f8b<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
\/* \u5f15\u767c\u4e00\u4e2a\u932f\u8aa4 -- BONES \u8cc7\u6599\u8868\u4e0d\u5b58\u5728 *\/<\/code><\/div>\n
$dbh<\/code>-><\/code>exec<\/code>(<\/code>\"INSERT INTO bones(skull) VALUES ('lucy')\"<\/code>);<\/code><\/div>\n
<\/div>\n
echo<\/code> \"\\nPDO::errorCode(): \"<\/code>;<\/code><\/div>\n
print<\/code> $dbh<\/code>->errorCode();<\/code>\/\/ \u8f38\u51faPDO::errorCode(): 42S02<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
<\/div>\n
PDO::errorInfo<\/div>\n
\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
\/* Provoke an error -- bogus SQL syntax *\/<\/code><\/div>\n
$stmt<\/code> = <\/code>$dbh<\/code>->prepare(<\/code>'bogus sql'<\/code>);<\/code><\/div>\n
if<\/code> (!<\/code>$stmt<\/code>) {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>echo<\/code> \"\\nPDO::errorInfo():\\n\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>print_r(<\/code>$dbh<\/code>->errorInfo());<\/code><\/div>\n
}<\/code><\/div>\n
\/*<\/code><\/div>\n
PDO::errorInfo():<\/code><\/div>\n
Array<\/code><\/div>\n
(<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>[0] => HY000<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>[1] => 1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>[2] => near \"bogus\": syntax error<\/code><\/div>\n
)<\/code><\/div>\n
*\/<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
PDO::getAttribute<\/div>\n
\u53d6\u56de\u4e00\u500b\u8cc7\u6599\u5eab\u9023\u7d50\u7684\u5c6c\u6027<\/div>\n
\n
    \n
  1. PDO::ATTR_AUTOCOMMIT<\/li>\n
  2. PDO::ATTR_CASE<\/li>\n
  3. PDO::ATTR_CLIENT_VERSION<\/li>\n
  4. PDO::ATTR_CONNECTION_STATUS<\/li>\n
  5. PDO::ATTR_DRIVER_NAME<\/li>\n
  6. PDO::ATTR_ERRMODE<\/li>\n
  7. PDO::ATTR_ORACLE_NULLS<\/li>\n
  8. PDO::ATTR_PERSISTENT<\/li>\n
  9. PDO::ATTR_PREFETCH<\/li>\n
  10. PDO::ATTR_SERVER_INFO<\/li>\n
  11. PDO::ATTR_SERVER_VERSION<\/li>\n
  12. PDO::ATTR_TIMEOUT<\/li>\n<\/ol>\n
    \u4e00\u500b\u7c21\u55ae\u7684\u7bc4\u4f8b<\/div>\n
    \n
    \n
    \n\n\n\n
    \n
    1<\/div>\n
    2<\/div>\n
    3<\/div>\n
    4<\/div>\n
    5<\/div>\n
    6<\/div>\n
    7<\/div>\n
    8<\/div>\n
    9<\/div>\n
    10<\/div>\n
    11<\/div>\n<\/td>\n
    		\n
    \n
    $conn<\/code> = <\/code>new<\/code> PDO(<\/code>'odbc:sample'<\/code>, <\/code>'db2inst1'<\/code>, <\/code>'ibmdb2'<\/code>);<\/code><\/div>\n
    $attributes<\/code> = <\/code>array<\/code>(<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>\"AUTOCOMMIT\"<\/code>, <\/code>\"ERRMODE\"<\/code>, <\/code>\"CASE\"<\/code>, <\/code>\"CLIENT_VERSION\"<\/code>, <\/code>\"CONNECTION_STATUS\"<\/code>,<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>\"ORACLE_NULLS\"<\/code>, <\/code>\"PERSISTENT\"<\/code>, <\/code>\"PREFETCH\"<\/code>, <\/code>\"SERVER_INFO\"<\/code>, <\/code>\"SERVER_VERSION\"<\/code>,<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>\"TIMEOUT\"<\/code><\/div>\n
    );<\/code><\/div>\n
    <\/div>\n
    foreach<\/code> (<\/code>$attributes<\/code> as<\/code> $val<\/code>) {<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>echo<\/code> \"PDO::ATTR_$val: \"<\/code>;<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>echo<\/code> $conn<\/code>->getAttribute(constant(<\/code>\"PDO::ATTR_$val\"<\/code>)) . <\/code>\"\\n\"<\/code>;<\/code><\/div>\n
    }<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
    <\/div>\n
    PDO::getAvailableDrivers<\/div>\n
    \u56de\u50b3\u4e00\u500b\u53ef\u4f7f\u7528\u7684\u9a45\u52d5<\/div>\n
    <\/div>\n
    \u4e00\u500b\u7c21\u55ae\u7684\u7bc4\u4f8b<\/div>\n
    \n
    \n
    \n\n\n\n
    \n
    1<\/div>\n<\/td>\n
    		\n
    \n
    print_r(PDO::getAvailableDrivers());<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
    <\/div>\n
    PDO::inTransaction<\/div>\n
    \u6aa2\u67e5\u662f\u5426\u5728\u4e00\u500bTransactions\u5167<\/div>\n
    <\/div>\n
    PDO::lastInsertId<\/div>\n
    \u56de\u50b3\u6700\u5f8c\u63d2\u5165\u7684id\u6216\u5e8f\u5217\u503c<\/div>\n
    <\/div>\n
    PDO::prepare<\/div>\n
    \u9810\u5148\u6e96\u5099\u8a9e\u53e5 \u56de\u50b3\u4e00\u500b\u8a9e\u53e5\u7684\u7269\u4ef6<\/div>\n
    \u4e00\u500b\u7c21\u55ae\u7684\u7bc4\u4f8b<\/div>\n
    \n
    \n
    \n\n\n\n
    \n
    1<\/div>\n
    2<\/div>\n
    3<\/div>\n
    4<\/div>\n
    5<\/div>\n
    6<\/div>\n
    7<\/div>\n
    8<\/div>\n
    9<\/div>\n
    10<\/div>\n
    11<\/div>\n
    12<\/div>\n
    13<\/div>\n
    14<\/div>\n
    15<\/div>\n
    16<\/div>\n
    17<\/div>\n
    18<\/div>\n<\/td>\n
    		\n
    \n
    $sql<\/code> = 'SELECT name, colour, calories<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>FROM fruit<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>WHERE calories < :calories AND colour = :colour';<\/code><\/div>\n
    $sth<\/code> = <\/code>$dbh<\/code>->prepare(<\/code>$sql<\/code>, <\/code>array<\/code>(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));<\/code><\/div>\n
    $sth<\/code>->execute(<\/code>array<\/code>(<\/code>':calories'<\/code> => 150, <\/code>':colour'<\/code> => <\/code>'red'<\/code>));<\/code><\/div>\n
    $red<\/code> = <\/code>$sth<\/code>->fetchAll();<\/code><\/div>\n
    $sth<\/code>->execute(<\/code>array<\/code>(<\/code>':calories'<\/code> => 175, <\/code>':colour'<\/code> => <\/code>'yellow'<\/code>));<\/code><\/div>\n
    $yellow<\/code> = <\/code>$sth<\/code>->fetchAll();<\/code><\/div>\n
    <\/div>\n
    \/\/ \u57f7\u884c\u91cd\u8907\u8a9e\u53e5<\/code><\/div>\n
    \/*\u00a0Execute\u00a0a\u00a0prepared\u00a0statement\u00a0by\u00a0passing\u00a0an\u00a0array\u00a0of\u00a0values\u00a0*\/<\/code><\/div>\n
    $sth<\/code>\u00a0=\u00a0<\/code>$dbh<\/code>->prepare('SELECT\u00a0name,\u00a0colour,\u00a0calories<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>FROM\u00a0fruit<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>WHERE\u00a0calories\u00a0<\u00a0?\u00a0AND\u00a0colour\u00a0=\u00a0?');<\/code><\/div>\n
    $sth<\/code>->execute(<\/code>array<\/code>(150,\u00a0<\/code>'red'<\/code>));<\/code><\/div>\n
    $red<\/code>\u00a0=\u00a0<\/code>$sth<\/code>->fetchAll();<\/code><\/div>\n
    $sth<\/code>->execute(<\/code>array<\/code>(175,\u00a0<\/code>'yellow'<\/code>));<\/code><\/div>\n
    $yellow<\/code>\u00a0=\u00a0<\/code>$sth<\/code>->fetchAll();<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
    \n

    PDO::query<\/h1>\n
    \u57f7\u884cSQL\u8a9e\u53e5\u4e26\u56de\u50b3\u7d50\u679c<\/div>\n
    \u4e00\u500b\u7c21\u55ae\u7684\u7bc4\u4f8b<\/div>\n
    \n
    \n
    \n\n\n\n
    \n
    1<\/div>\n
    2<\/div>\n
    3<\/div>\n
    4<\/div>\n
    5<\/div>\n
    6<\/div>\n
    7<\/div>\n
    8<\/div>\n
    9<\/div>\n
    10<\/div>\n
    11<\/div>\n
    12<\/div>\n
    13<\/div>\n
    14<\/div>\n
    15<\/div>\n
    16<\/div>\n
    17<\/div>\n
    18<\/div>\n<\/td>\n
    		\n
    \n
    function<\/code> getFruit(<\/code>$conn<\/code>) {<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>$sql<\/code> = <\/code>'SELECT name, color, calories FROM fruit ORDER BY name'<\/code>;<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>foreach<\/code> (<\/code>$conn<\/code>->query(<\/code>$sql<\/code>) <\/code>as<\/code> $row<\/code>) {<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>print<\/code> $row<\/code>[<\/code>'name'<\/code>] . <\/code>\"\\t\"<\/code>;<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>print<\/code> $row<\/code>[<\/code>'color'<\/code>] . <\/code>\"\\t\"<\/code>;<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>print<\/code> $row<\/code>[<\/code>'calories'<\/code>] . <\/code>\"\\n\"<\/code>;<\/code><\/div>\n
    \u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
    \/*<\/code><\/div>\n
    \u8f38\u51fa<\/code><\/div>\n
    apple \u00a0 red \u00a0 \u00a0 150<\/code><\/div>\n
    banana \u00a0yellow \u00a0250<\/code><\/div>\n
    kiwi \u00a0 \u00a0brown \u00a0 75<\/code><\/div>\n
    lemon \u00a0 yellow \u00a025<\/code><\/div>\n
    orange \u00a0orange \u00a0300<\/code><\/div>\n
    pear \u00a0 \u00a0green \u00a0 150<\/code><\/div>\n
    watermelon \u00a0 \u00a0 \u00a0pink \u00a0 \u00a090<\/code><\/div>\n
    \/*<\/code><\/div>\n
    }<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n
    8.<\/div>\n
    \n
    \n
    PDOStatement<\/div>\n
    PDOStatement::bindColumn<\/div>\n
    <\/div>\n
    \u4f7f\u7528\u65b9\u6cd5\uff1aPDOStatement::bindColumn\u00a0(\u00a0mixed\u00a0$column\u00a0,\u00a0mixed\u00a0&$param\u00a0[,\u00a0int\u00a0$type\u00a0[,\u00a0int\u00a0$maxlen\u00a0[,\u00a0mixed\u00a0$driverdata\u00a0]]] )<\/div>\n
    <\/div>\n
    \u53c3\u6578\u8aaa\u660e\uff1a<\/div>\n
    \n