瀵逛簬澶у?鏁皐eb搴旂敤鏉ヨ?锛屾暟鎹?簱閮芥槸涓?涓?崄鍒嗗熀纭?鎬х殑閮ㄥ垎銆傚?鏋滀綘鍦ㄤ娇鐢≒HP锛岄偅涔堜綘寰堝彲鑳戒篃鍦ㄤ娇鐢∕ySQL鈥擫AMP绯诲垪涓?妇瓒宠交閲嶇殑涓?浠藉瓙銆?
銆?銆?瀵逛簬寰堝?鏂版墜浠?潵璇达紝浣跨敤PHP鍙?互鍦ㄧ煭鐭?嚑涓?皬鏃朵箣鍐呰交鏉惧湴鍐欏嚭鍏锋湁鐗瑰畾鍔熻兘鐨勪唬鐮併?備絾鏄?紝鏋勫缓涓?涓?ǔ瀹氬彲闈犵殑鏁版嵁搴撳嵈闇?瑕佽姳涓婁竴浜涙椂鏃ュ拰鐩稿叧鎶?鑳姐?備笅闈㈠垪涓句簡鎴戞浘缁忕姱杩囩殑鏈?涓ラ噸鐨?1涓狹ySQL鐩稿叧鐨勯敊璇?紙鏈変簺鍚屾牱涔熷弽鏄犲湪鍏朵粬璇?█/鏁版嵁搴撶殑浣跨敤涓婏級銆?
1.浣跨敤MyISAM鑰屼笉鏄疘nnoDB
銆?銆?MySQL鏈夊緢澶氭暟鎹?簱寮曟搸锛屼絾鏄?綘鏈?鍙?兘纰板埌鐨勫氨鏄疢yISAM鍜孖nnoDB銆?
銆?銆?MySQL榛樿?浣跨敤鐨勬槸MyISAM銆備絾鏄?紝寰堝?鎯呭喌涓嬭繖閮芥槸涓?涓?緢绯熺硶鐨勯?夋嫨锛岄櫎闈炰綘鍦ㄥ垱寤轰竴涓?潪甯哥畝鍗曟姂鎴栧疄楠屾?х殑鏁版嵁搴撱?傚?閿?害鏉熸垨鑰呬簨鍔″?鐞嗗?浜庢暟鎹?畬鏁存?ф槸闈炲父閲嶈?鐨勶紝浣哅yISAM閮戒笉鏀?寔杩欎簺銆傚彟澶栵紝褰撴湁涓?鏉¤?褰曞湪鎻掑叆鎴栬?呮洿鏂版椂锛屾暣涓?暟鎹?〃閮借?閿佸畾浜嗭紝褰撲娇鐢ㄩ噺澧炲姞鐨勬椂鍊欒繖浼氫骇鐢熼潪甯稿樊鐨勮繍琛屾晥鐜囥??
銆?銆?缁撹?寰堢畝鍗曪細浣跨敤InnoDB銆?
2.浣跨敤PHP鐨刴ysql鍑芥暟
銆?銆?PHP鑷?骇鐢熶箣鏃ュ氨鎻愪緵浜哅ySQL搴撳嚱鏁帮紙or near as makes no difference锛夈?傚緢澶氬簲鐢ㄤ粛鐒跺湪浣跨敤绫讳技mysql_connect銆乵ysql_query銆乵ysql_fetch_assoc绛夌殑鍑芥暟锛屽敖绠?HP鎵嬪唽涓婅?锛?
銆?銆?濡傛灉浣犲湪浣跨敤MySQL v4.1.3鎴栬?呮洿鏂扮増鏈?紝寮虹儓鎺ㄨ崘浣跨敤鎮ㄤ娇鐢╩ysqli鎵╁睍銆?
銆?銆?mysqli锛圡ySQL鐨勫姞寮虹増鎵╁睍锛夋湁浠ヤ笅鍑犱釜浼樼偣锛?
銆?銆?鍙??夌殑闈㈠悜瀵硅薄鎺ュ彛
銆?銆?prepared琛ㄨ揪寮忥紝杩欐湁鍒╀簬闃绘?SQL娉ㄥ叆鏀诲嚮锛岃繕鑳芥彁楂樻?ц兘
銆?銆?鏀?寔鏇村?鐨勮〃杈惧紡鍜屼簨鍔″?鐞?
銆?銆?鍙﹀?锛屽?鏋滀綘鎯虫敮鎸佸?绉嶆暟鎹?簱绯荤粺锛屼綘杩樺彲浠ヨ?冭檻PDO銆?
3.娌℃湁澶勭悊鐢ㄦ埛杈撳叆
銆?銆?杩欐垨鑰呭彲浠ヨ繖鏍疯?#1锛氭案杩滀笉瑕佺浉淇＄敤鎴风殑杈撳叆銆傜敤鏈嶅姟鍣ㄧ?鐨凱HP楠岃瘉姣忎釜瀛楃?涓诧紝涓嶈?瀵勫笇鏈涗笌JavaScript銆傛渶绠?鍗曠殑SQL娉ㄥ叆鏀诲嚮浼氬埄鐢ㄥ?涓嬬殑浠ｇ爜锛?
銆?銆?$username = $_POST["name"];
銆?銆?$password = $_POST["password"];
銆?銆?$sql = 鈥淪ELECT userid FROM usertable WHERE username=鈥?username鈥?AND password=鈥?password鈥?鈥?
銆?銆?// run query鈥?
銆?銆?鍙??鍦╱sername瀛楁?杈撳叆鈥漚dmin鈥?鈥撯?濓紝杩欐牱灏变細琚?粦鍒帮紝鐩稿簲鐨凷QL璇?彞濡備笅锛?
銆?銆?SELECT userid FROM usertable WHERE username=鈥檃dmin鈥?
銆?銆?鐙＄尵鐨勯粦瀹㈠彲浠ヤ互admin鐧诲綍锛屼粬浠?笉闇?瑕佺煡閬撳瘑鐮侊紝鍥犱负瀵嗙爜娈佃?娉ㄩ噴鎺変簡銆?
4.娌℃湁浣跨敤UTF-8
銆?銆?缇庡浗銆佽嫳鍥藉拰婢冲ぇ鍒╀簹鐨勬垜浠?緢灏戣?冭檻闄よ嫳璇?箣澶栫殑鍏朵粬璇?█銆傛垜浠?緢寰楁剰鍦板畬鎴愪簡鑷?繁鐨勨?濇澃浣溾?濆嵈鍙戠幇瀹冧滑骞朵笉鑳藉湪鍏朵粬鍦版柟姝ｅ父杩愯?銆?
銆?銆?UTF-8瑙ｅ喅浜嗗緢澶氬浗闄呭寲闂??銆傝櫧鐒跺湪PHP v6.0涔嬪墠瀹冭繕涓嶈兘寰堝ソ鍦拌?鏀?寔锛屼絾杩欏苟涓嶅奖鍝嶄綘鎶奙ySQL瀛楃?闆嗚?涓篣TF-8銆?
5.鐩稿?浜嶴QL锛屽亸鐖盤HP
銆?銆?濡傛灉浣犳帴瑙?ySQL涓嶄箙锛岄偅涔堜綘浼氬亸鍚戜簬浣跨敤浣犲凡缁忔帉鎻＄殑璇?█鏉ヨВ鍐抽棶棰橈紝杩欐牱浼氬?鑷村啓鍑轰竴浜涘啑浣欍?佷綆鏁堢巼鐨勪唬鐮併?傛瘮濡傦紝浣犱笉浼氫娇鐢∕ySQL鑷?甫鐨凙VG()鍑芥暟锛屽嵈浼氬厛瀵硅?褰曢泦涓?殑鍊兼眰鍜岀劧鍚庣敤PHP寰?幆鏉ヨ?绠楀钩鍧囧?笺??
銆?銆?姝ゅ?锛岃?娉ㄦ剰PHP寰?幆涓?殑SQL鏌ヨ?銆傞?氬父鏉ヨ?锛屾墽琛屼竴涓?煡璇㈡瘮鍦ㄧ粨鏋滀腑杩?唬鏇存湁鏁堢巼銆?
銆?銆?鎵?浠ワ紝鍦ㄥ垎鏋愭暟鎹?殑鏃跺?欒?鍒╃敤鏁版嵁搴撶郴缁熺殑浼樺娍锛屾噦涓?浜汼QL鐨勭煡璇嗗皢澶ф湁瑁ㄧ泭銆?
6.娌℃湁浼樺寲鏁版嵁搴撴煡璇?/strong>
銆?銆?99%鐨凱HP鎬ц兘闂??閮芥槸鐢辨暟鎹?簱寮曡捣鐨勶紝浠呬粎涓?涓?碂绯曠殑SQL鏌ヨ?灏辫兘璁╀綘鐨剋eb搴旂敤褰诲簳鐦?棯銆侻ySQL鐨凟XPLAIN statement銆丵uery Profiler锛岃繕鏈夊緢澶氬叾浠栫殑宸ュ叿灏嗕細甯?姪浣犳壘鍑鸿繖浜涗竾鎭剁殑SELECT銆?
7.涓嶈兘姝ｇ‘浣跨敤鏁版嵁绫诲瀷
銆?銆?MySQL鎻愪緵浜嗚?濡俷umeric銆乻tring鍜宒ate绛夌殑鏁版嵁绫诲瀷銆傚?鏋滀綘鎯冲瓨鍌ㄤ竴涓?椂闂达紝閭ｄ箞浣跨敤DATE鎴栬?匘ATETIME绫诲瀷銆傚?鏋滆繖涓?椂鍊欑敤INTEGER鎴栬?匰TRING绫诲瀷鐨勮瘽锛岄偅涔堝皢浼氫娇寰桽QL鏌ヨ?闈炲父澶嶆潅锛屽墠鎻愭槸浣犺兘浣跨敤INTEGER鎴栬?匰TRING鏉ュ畾涔夐偅涓?被鍨嬨??
銆?銆?寰堝?浜哄?惧悜浜庢搮鑷?嚜瀹氫箟涓?浜涙暟鎹?殑鏍煎紡锛屾瘮濡傦紝浣跨敤string鏉ュ瓨鍌ㄥ簭鍒楀寲鐨凱HP瀵硅薄銆傝繖鏍风殑璇濇暟鎹?簱绠＄悊璧锋潵鍙?兘浼氬彉寰楃畝鍗曚簺锛屼絾浼氫娇寰桵ySQL鎴愪负涓?涓?碂绯曠殑鏁版嵁瀛樺偍鑰屼笖涔嬪悗寰堝彲鑳戒細寮曡捣鏁呴殰銆?
8.鍦ㄦ煡璇?腑浣跨敤*
銆?銆?姘歌繙涓嶈?浣跨敤*鏉ヨ繑鍥炰竴涓?暟鎹?〃鎵?鏈夊垪鐨勬暟鎹??傝繖鏄?噿鎯帮細浣犲簲璇ユ彁鍙栦綘闇?瑕佺殑鏁版嵁銆傚氨绠椾綘闇?瑕佹墍鏈夊瓧娈碉紝浣犵殑鏁版嵁琛ㄤ篃涓嶅彲閬垮厤鐨勪細浜х敓鍙樺寲銆?
9.涓嶄娇鐢ㄧ储寮曟垨鑰呰繃搴︿娇鐢ㄧ储寮?/strong>
銆?銆?涓?鑸??у師鍒欐槸杩欐牱鐨勶細select璇?彞涓?殑浠讳綍涓?涓獁here瀛愬彞琛ㄧず鐨勫瓧娈甸兘搴旇?浣跨敤绱㈠紩銆?
銆?銆?涓句釜渚嬪瓙锛屽亣璁炬垜浠?湁涓?涓猽ser琛?紝鍖呮嫭numeric ID锛堜富閿?級鍜宔mail address銆傜櫥褰曠殑鏃跺?欙紝MySQL蹇呴』浠ヤ竴涓猠mail涓轰緷鎹?煡鎵炬?纭?殑ID銆傚?鏋滀娇鐢ㄤ簡绱㈠紩鐨勮瘽锛堣繖閲屾寚email锛夛紝閭ｄ箞MySQL灏辫兘澶熶娇鐢ㄦ洿蹇?殑鎼滅储绠楁硶鏉ュ畾浣峞mail锛岀敋鑷冲彲浠ヨ?鏄?嵆鏃跺疄鐜般?傚惁鍒欙紝MySQL灏卞彧鑳介『搴忓湴妫?鏌ユ瘡涓?鏉¤?褰曠洿鍒版壘鍒版?纭?殑email address銆?
銆?鏈夌殑浜轰細鍦ㄦ瘡涓?瓧娈典笂閮芥坊鍔犵储寮曪紝閬楁喚鐨勬槸锛屾墽琛屼簡INSERT鎴栬?匲PDATE涔嬪悗杩欎簺绱㈠紩閮介渶瑕侀噸鏂扮敓鎴愶紝杩欐牱灏变細褰卞搷鎬ц兘銆傛墍浠ワ紝鍙?湪闇?瑕佺殑鏃跺?欐坊鍔犵储寮曘??
10.蹇樿?澶囦唤
銆?銆?铏界劧姣旇緝缃曡?锛屼絾鏄?暟鎹?簱杩樻槸鏈夊穿婧冪殑鍗遍櫓銆傜‖鐩樻湁鍙?兘鎹熷潖锛屾湇鍔″櫒鏈夊彲鑳藉穿婧冿紝web涓绘満鎻愪緵鍟嗘湁鍙?兘浼氱牬浜э紒涓㈠けMySQL鏁版嵁灏嗕細鏄?伨闅炬?х殑锛屾墍浠ヨ?纭?繚浣犲凡缁忎娇鐢ㄤ簡鑷?姩澶囦唤鎴栬?呭凡缁忓?鍒跺埌浣嶃??
11.Bonus mistake-涓嶈?冭檻浣跨敤鍏朵粬鏁版嵁搴?/strong>
銆?銆?瀵逛簬PHP寮?鍙戜汉鍛樻潵璇达紝MySQL鍙?兘鏄?娇鐢ㄦ渶骞挎硾鐨勬暟鎹?簱绯荤粺锛屼絾骞朵笉鏄?敮涓?鐨勯?夋嫨銆侾ostgreSQL鍜孎irebird鏄?渶寮烘湁鍔涚殑绔炰簤鑰咃細杩欎釜涓よ?呴兘鏄?紑婧愮殑锛岃?屼笖閮芥病鏈夎?鍏?徃鏀惰喘銆傚井杞?彁渚涗簡sql server Express锛岀敳楠ㄦ枃鎻愪緵浜?0g Express锛岃繖涓よ?呴兘鏄?紒涓氱骇鏁版嵁搴撶殑鍏嶈垂鐗堟湰銆傛湁鏃跺?欙紝瀵逛簬涓?涓?緝灏忕殑web搴旂敤鎴栬?呭祵鍏ュ紡搴旂敤锛孲QLite涔熶笉澶变负涓?涓?彲琛岀殑鏇夸唬鏂规?銆?
鍘熸枃锛歜oobooke.com