闅忕潃浜戣绠楁妧鏈殑鏅強锛岃秺鏉ヨ秺澶氱殑浼佷笟閫夋嫨灏嗘暟鎹瓨鍌ㄥ湪浜戠銆傜櫨搴︿簯浣滀负鍥藉唴棰嗗厛鐨勪簯鏈嶅姟骞冲彴锛屾彁渚涗簡涓板瘜鐨勬暟鎹簱鏈嶅姟銆傛湰鏂囧皢璇︾粏浠嬬粛濡備綍浣跨敤PHP璇█杩炴帴鐧惧害浜戞暟鎹簱锛屽苟鎵ц鍩烘湰鐨凷QL鏌ヨ銆?/p>
鍑嗗宸ヤ綔
鍦ㄥ紑濮嬩箣鍓嶏紝璇风‘淇濆凡瀹屾垚浠ヤ笅鍑嗗宸ヤ綔锛?/p>
杩炴帴鐧惧害浜戞暟鎹簱
棣栧厛闇€瑕佸紩鍏ラ€傚綋鐨凱HP搴撴潵寤虹珛涓庣櫨搴︿簯鏁版嵁搴撲箣闂寸殑杩炴帴銆傝繖閲屼互MySQL涓轰緥锛屽彲浠ヤ娇鐢≒DO鎴栬€卪ysqli鏂瑰紡杩炴帴銆?/p>
浣跨敤PDO杩炴帴锛?/strong>
閫氳繃PDO杩炴帴鏃讹紝闇€瑕佹瀯閫犱竴涓狣SN瀛楃涓诧紙Data Source Name锛夛紝瀹冨寘鍚簡杩炴帴鎵€闇€鐨勬墍鏈夊弬鏁般€傜劧鍚庡埄鐢╰ry-catch缁撴瀯鎹曡幏鍙兘鍑虹幇鐨勫紓甯告儏鍐点€?/p>
// 鏇挎崲涓轰綘鐨勫疄闄呬俊鎭?
$dsn = \"mysql:host=your_host;port=your_port;dbname=your_db;charset=utf8mb4\";
$username = \'your_username\';
$password = \'your_password\';
try {
$pdo = new PDO($dsn, $username, $password);
// 璁剧疆閿欒妯″紡涓哄紓甯告姏鍑?
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo \"鎴愬姛杩炴帴鍒版暟鎹簱!\";
} catch (PDOException $e) {
die(\"杩炴帴澶辫触锛? . $e->getMessage());
}浣跨敤mysqli杩炴帴锛?/strong>
mysqli涔熸槸涓€绉嶅父鐢ㄧ殑MySQL鎿嶄綔鏂规硶锛屼笅闈㈠睍绀哄浣曚娇鐢╩ysqli杩炴帴鐧惧害浜戜笂鐨凪ySQL鏁版嵁搴撱€?/p>
$host = \'your_host\';
$port = \'your_port\';
$dbname = \'your_db\';
$user = \'your_username\';
$pwd = \'your_password\';
// 鍒涘缓杩炴帴
$conn = new mysqli($host, $user, $pwd, $dbname, $port);
// 妫€娴嬭繛鎺ユ槸鍚︽垚鍔?
if ($conn->connect_error) {
die(\"杩炴帴澶辫触: \" . $conn->connect_error);
}
echo \"鎴愬姛杩炴帴鍒版暟鎹簱!\";
鎵ц鍩烘湰鏌ヨ
涓€鏃﹀缓绔嬩簡鏈夋晥鐨勬暟鎹簱杩炴帴锛屽氨鍙互缂栧啓SQL璇彞鏉ヨ繘琛屾暟鎹绱€佹彃鍏ャ€佹洿鏂版垨鍒犻櫎鎿嶄綔銆傚浜庣畝鍗曠殑鏌ヨ浠诲姟锛屽彲浠ョ洿鎺ヨ皟鐢≒DO鎴杕ysqli鎻愪緵鐨勬煡璇㈠嚱鏁般€?/p>
PDO绀轰緥 – 鏌ヨ璁板綍锛?/strong>
$stmt = $pdo->query(\'SELECT FROM table_name\');
while ($row = $stmt->fetch()) {
print_r($row);
}mysqli绀轰緥 – 鎻掑叆鏂拌褰曪細
$sql = \"INSERT INTO table_name (column1, column2) VALUES (\'value1\', \'value2\')\";
if ($conn->query($sql) === TRUE) {
echo \"鏂拌褰曟彃鍏ユ垚鍔?;
} else {
echo \"Error: \" . $sql . \"
\" . $conn->error;
}
娉ㄦ剰浜嬮」
鍦ㄤ娇鐢≒HP杩炴帴鐧惧害浜戞暟鎹簱鏃讹紝璇锋敞鎰忎互涓嬪嚑鐐癸細
鏈枃浠嬬粛浜嗗浣曚娇鐢≒HP杩炴帴鐧惧害浜戞暟鎹簱骞舵墽琛屽熀鏈殑SQL鏌ヨ銆傞€氳繃鎺屾彙杩欎簺鎶€鑳斤紝寮€鍙戣€呭彲浠ユ洿鍔犳柟渚垮湴绠＄悊鍜屾搷浣滄墭绠″湪鐧惧害浜戝钩鍙颁笂鐨勬暟鎹簱璧勬簮銆?/p>
