鍦≒HP搴旂敤绋嬪簭涓紝浣跨敤MySQL鏁版嵁搴撴槸闈炲父甯歌鐨勩€傚敖绠′紶缁熺殑`mysql_`鍑芥暟锛堝 `mysql_connect()` 鍜?`mysql_query()`锛夊凡缁忚寮冪敤锛屽苟涓斾笉鍐嶆帹鑽愪娇鐢紝浣嗕粛鏈夊绉嶆浛浠ｆ柟娉曞彲浠ュ畨鍏ㄦ湁鏁堝湴杩炴帴鍜屾搷浣淢ySQL鏁版嵁搴撱€?/p>
1. 浣跨敤mysqli鎵╁睍
Mysqli 鏄竴涓敼杩涘悗鐨?MySQL 鎺ュ彛锛屾彁渚涗簡闈㈠悜瀵硅薄鍜岃繃绋嬪紡鐨勪袱绉嶇紪绋嬮鏍笺€傚畠鏀寔鏇村鐨勫姛鑳斤紝渚嬪棰勫鐞嗚鍙ャ€佷簨鍔″鐞嗙瓑锛岃繖浜涚壒鎬т娇寰椾唬鐮佹洿鍔犲畨鍏ㄥ拰楂樻晥銆備笅闈㈡槸涓€涓畝鍗曠殑渚嬪瓙灞曠ず濡備綍浣跨敤 mysqli 杩炴帴 MySQL 鏁版嵁搴擄細
<?php$servername = \"localhost\";$username = \"root\";$password = \"\";$dbname = \"test\";// 鍒涘缓杩炴帴$conn = new mysqli($servername, $username, $password, $dbname);// 妫€鏌ヨ繛鎺ユ槸鍚︽垚鍔?if ($conn->connect_error) { die(\"杩炴帴澶辫触: \" . $conn->connect_error);}echo \"杩炴帴鎴愬姛\";// 鍏抽棴杩炴帴$conn->close();?>
2. 浣跨敤PDO (PHP Data Objects)
PDO 鎻愪緵浜嗕竴绉嶇粺涓€鐨勬柟娉曟潵璁块棶涓嶅悓鐨勬暟鎹簱绯荤粺锛岃€屼笉闇€瑕佷负姣忎釜鏁版嵁搴撶紪鍐欑壒瀹氱殑浠ｇ爜銆傚畠鍙互澶勭悊澶氫釜鏁版嵁搴撻┍鍔ㄧ▼搴忥紝鍖呮嫭 MySQL銆丼QLite 绛夈€侾DO 鏀寔棰勫鐞嗚鍙ュ拰鍏朵粬楂樼骇鐗规€э紝杩欐湁鍔╀簬闃叉 SQL 娉ㄥ叆鏀诲嚮骞舵彁楂樻€ц兘銆備互涓嬫槸濡備綍閫氳繃 PDO 杩炴帴鍒?MySQL 鐨勭ず渚嬶細
<?phptry { $dsn = \'mysql:host=localhost;dbname=test;charset=utf8mb4\'; $username = \'root\'; $password = \'\'; // 鍒涘缓 PDO 瀹炰緥 $pdo = new PDO($dsn, $username, $password); // 璁剧疆 PDO 閿欒妯″紡涓哄紓甯? $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo \"杩炴帴鎴愬姛\";} catch (PDOException $e) { echo \"杩炴帴澶辫触: \" . $e->getMessage();}// 鍏抽棴杩炴帴$pdo = null;?>
3. 浣跨敤妗嗘灦鎻愪緵鐨勬暟鎹簱鎶借薄灞?/h2>
濡傛灉浣犳鍦ㄤ娇鐢?Laravel銆丼ymfony 鎴?CodeIgniter 绛夋祦琛岀殑 PHP 妗嗘灦锛岄偅涔堥€氬父浼氭湁鍐呯疆鐨勬暟鎹簱鎶借薄灞傛潵绠€鍖栦笌 MySQL 鐨勪氦浜掋€備緥濡傦紝鍦?Laravel 涓紝浣犲彲浠ヤ娇鐢?Eloquent ORM 鏉ヨ交鏉惧湴鎵ц鏌ヨ鍜岀鐞嗘暟鎹ā鍨嬨€傝繖浜涙鏋朵笉浠呮彁渚涙柟渚挎槗鐢ㄧ殑鍔熻兘锛岃繕鍖呭惈浜嗚澶氬畨鍏ㄦ帾鏂斤紝浠ョ‘淇濅綘鐨勫簲鐢ㄧ▼搴忓厤鍙楁綔鍦ㄥ▉鑳併€?/p>
铏界劧浼犵粺鐨?mysql_ 鍑芥暟宸茬粡琚簾寮冿紝浣嗘垜浠湁璁稿鏇村ソ鐨勯€夋嫨鏉ヤ唬鏇垮畠浠€傛棤璁轰綘鏄€夋嫨 mysqli 鎵╁睍杩樻槸 PDO 绫诲簱锛屼害鎴栨槸鍒╃敤鐜颁唬 PHP 妗嗘灦鐨勪紭鍔匡紝閮藉彲浠ヤ娇浣犳瀯寤哄嚭鏇村己澶с€佹洿瀹夊叏鐨勫簲鐢ㄧ▼搴忋€傞€夋嫨鏈€閫傚悎浣犻」鐩渶姹傜殑鏂规硶锛屽苟閬靛惊鏈€浣冲疄璺碉紝灏嗘湁鍔╀簬鎻愰珮寮€鍙戞晥鐜囧拰浠ｇ爜璐ㄩ噺銆?/p>
