涓€銆佺幆澧冩鏌ヤ笌鍑嗗
鍦ㄥ惎鐢≒DO鍔熻兘鍓嶏紝闇€瀹屾垚浠ヤ笅鐜妫€鏌ワ細
- 纭PHP鐗堟湰鈮?.1.0锛屽缓璁娇鐢≒HP7.4鍙婁互涓婄増鏈?/li>
- 妫€鏌ュ綋鍓峆HP瀹夎鏄惁鍖呭惈PDO鏍稿績妯″潡锛?code>php -m | grep pdo
- 纭宸插畨瑁呭搴旀暟鎹簱椹卞姩锛堝mysql/pgsql/sqlite锛?/li>
浜屻€丳DO鎵╁睍瀹夎涓庡惎鐢?/h2>
涓嶅悓鎿嶄綔绯荤粺涓嬬殑瀹夎鏂瑰紡锛?/p>
- CentOS/RHEL锛?
sudo yum install php-pdo php-mysqlnd - Ubuntu/Debian锛?
sudo apt install php-pdo php-mysql
淇敼php.ini閰嶇疆鏂囦欢锛?/p>
; 鍚敤鏍稿績妯″潡
extension=pdo.so
; 鍚敤鏁版嵁搴撻┍鍔?
extension=pdo_mysql.so
涓夈€佸畨鍏ㄨ繛鎺ラ厤缃鑼?/h2>
鎺ㄨ崘鐨勫畨鍏ㄨ繛鎺ュ弬鏁伴厤缃細
- 寮哄埗鍚敤寮傚父妯″紡锛?code>$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION)
- 绂佺敤鏈湴妯℃嫙棰勫鐞嗭細
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false) - 璁剧疆瀛楃缂栫爜锛?code>charset=utf8mb4娣诲姞鍦―SN涓?/li>
鏍囧噯杩炴帴浠ｇ爜绀轰緥锛?/p>
$dsn = 'mysql:host=127.0.0.1;dbname=test;charset=utf8mb4';
try {
$pdo = new PDO($dsn, 'user', 'password', [
PDO::ATTR_PERSISTENT => false,
PDO::ATTR_TIMEOUT => 5
]);
} catch(PDOException $e) {
error_log($e->getMessage);
exit('鏁版嵁搴撹繛鎺ュけ璐?);
鍥涖€侀獙璇佷笌鎬ц兘浼樺寲
瀹屾垚閰嶇疆鍚庢墽琛岄獙璇佹楠わ細
- 閫氳繃
phpinfo鏌ョ湅PDO妯″潡鐘舵€?/li> - 娴嬭瘯鍩烘湰鏌ヨ鍔熻兘锛?code>$pdo->query(“SELECT 1”)->fetchColumn
鎺ㄨ崘鎬ц兘浼樺寲鎺柦锛?/p>
- 鍚堢悊璁剧疆杩炴帴姹犲弬鏁帮紙闇€閰嶅悎鎸佷箙杩炴帴浣跨敤锛?/li>
- 閰嶇疆OPcache鍔犻€烶DO棰勫鐞嗚鍙?/li>
- 鍚敤鎱㈡煡璇㈡棩蹇楃洃鎺QL鎵ц鏁堢巼
鏈暀绋嬭缁嗚鏄庝簡浠庣幆澧冩鏌ュ埌瀹夊叏閰嶇疆鐨勫畬鏁碢DO鍚敤娴佺▼銆傛纭厤缃甈DO涓嶄粎闇€瑕佸叧娉ㄥ姛鑳藉惎鐢紝鏇撮渶閲嶈瀹夊叏鍙傛暟璁剧疆涓庢€ц兘璋冧紭锛屽缓璁畾鏈熷鏌ユ暟鎹簱杩炴帴閰嶇疆骞舵洿鏂伴┍鍔ㄧ増鏈€?/p>
