鏈枃涓嶆秹鍙奝do鐨勫畨瑁咃紝鍙槸绠€鍗曟€荤粨涓€涓婸do鐨勪娇鐢ㄣ€?/p>
寮€濮嬫瀯閫犵涓€涓狿do搴旂敤锛屽湪web鏂囨。鐩綍涓嬪垱寤轰竴涓猵do.php鏂囦欢锛?/p>
[php]
exec(insert into foo set name = 'lix',gender='mail',time=now()); 
echo $count; 
$db = null; 
?> 
$dsn = mysql:host=localhost;dbname=test;
鐢ㄦ潵鏋勯€燚sn锛堟暟鎹簮锛夛紝閲岄潰鐨勪俊鎭寘鎷細鏁版嵁搴撶被鍨嬫槸mysql锛屼富鏈哄湴鍧€鏄痩ocalhost锛屾暟鎹簱鍚嶇о鏄痶est锛屽氨杩欎箞鍑犱釜淇℃伅銆備笉鍚屾暟鎹簱鐨勬暟鎹簮鏋勯€犳柟寮忔槸涓嶄竴鏍风殑銆?/p>
$db = new pdo($dsn, 'root', '');
鍒濆鍖栦竴涓狿do瀵硅薄锛屾瀯閫犲嚱鏁扮殑鍙傛暟绗竴涓氨鏄垜浠殑鏁版嵁婧愶紝绗簩涓槸杩炴帴鏁版嵁搴撴湇鍔″櫒鐨勭敤鎴凤紝绗笁涓弬鏁版槸瀵嗙爜銆?/p>
$count = $db->exec(insert into foo set name = 'lix',gender='mail',time=now());
echo $count;
璋冪敤杩炴帴鎴愬姛鐨凱do瀵硅薄鏉ユ墽琛屼竴涓煡璇紝杩欎釜鏌ヨ鏄竴涓彃鍏ヤ竴鏉¤褰曠殑鎿嶄綔锛屼娇鐢≒do::exec() 鏂规硶浼氳繑鍥炰竴涓奖鍝嶈褰曠殑缁撴灉銆傛渶鍚庤繕鏄渶瑕佺粨鏉熷璞¤祫婧愶細
$db = null;
榛樿杩欎釜涓嶆槸闀胯繛鎺ワ紝濡傛灉闇€瑕佹暟鎹簱闀胯繛鎺ワ紝闇€瑕佹渶鍚庡姞涓€涓弬鏁帮細array(pdo::attr_persistent => true) 鍙樻垚杩欐牱锛?br />$db = new pdo($dsn, 'root', '', array(pdo::attr_persistent => true));
濡傛灉鎯宠幏鍙栨暟鎹?br />[php]
query(select * from foo); 
 foreach($rs->fetch() as $row){ 
    print_r($row); 
} 
?> 
涔熷彲浠ョ敤
[php]
query(select * from foo); 
while($row = $rs->fetch()){ 
    print_r($row); 
} 
?> 
涓€娆¤幏鍙栨墍鏈夋暟鎹?br />[php]
query(select * from foo); 
$result_arr = $rs->fetchall(); 
print_r($result_arr); 
?> 
缁撴灉鏄剧ず锛?br />[php]
array 
( 
    [0] => array 
        ( 
            [id] => 1 
            [0] => 1 
            [name] => heiyeluren 
            [1] => heiyeluren 
            [gender] => 鐢?nbsp;
            [2] => 鐢?nbsp;
            [time] => 2006-10-28 23:14:23 
            [3] => 2006-10-28 23:14:23 
        ) 
} 
鎴戜滑鐪嬮噷闈㈢殑璁板綍锛屾暟瀛楃储寮曞拰鍏宠仈绱㈠紩閮芥湁锛屾氮璐硅祫婧愶紝鎴戜滑鍙渶瑕佸叧鑱旂储寮曠殑锛?br />[php]
setattribute(pdo::attr_case, pdo::case_upper); 
$rs = $db->query(select * from foo); 
$rs->setfetchmode(pdo::fetch_assoc); 
$result_arr = $rs->fetchall(); 
print_r($result_arr); 
?> 
setattribute() 鏂规硶鏄缃甈do灞炴€э紝涓昏灞炴€ф湁锛歅do::attr_case銆丳do::attr_errmode绛夌瓑锛屾垜浠繖閲岄渶瑕佽缃殑鏄疨do::attr_case锛屽氨鏄垜浠娇鐢ㄥ叧鑱旂储寮曡幏鍙栨暟鎹泦鐨勬椂鍊欙紝鍏宠仈绱㈠紩鏄ぇ鍐欒繕鏄皬鍐欙紝鏈夊嚑涓€夋嫨锛?br />pdo::case_lower -- 寮哄埗鍒楀悕鏄皬鍐?br />pdo::case_natural -- 鍒楀悕鎸夌収鍘熷鐨勬柟寮?br />pdo::case_upper -- 寮哄埗鍒楀悕涓哄ぇ鍐?br />鎴戜滑浣跨敤setfetchmode鏂规硶鏉ヨ缃幏鍙栫粨鏋滈泦鐨勮繑鍥炲€肩殑绫诲瀷锛屽悓鏍风被鍨嬭繕鏈夛細
pdo::fetch_assoc -- 鍏宠仈鏁扮粍褰㈠紡
pdo::fetch_num -- 鏁板瓧绱㈠紩鏁扮粍褰㈠紡
pdo::fetch_both -- 涓よ€呮暟缁勫舰寮忛兘鏈夛紝杩欐槸缂虹渷鐨?br />pdo::fetch_obj -- 鎸夌収瀵硅薄鐨勫舰寮忥紝绫讳技浜庝互鍓嶇殑 mysql_fetch_object()
褰撶劧锛屼竴鑸儏鍐典笅鎴戜滑鏄娇鐢≒do::fetch_assoc锛屽叿浣撲娇鐢ㄤ粈涔堬紝鎸夌収浣犺嚜宸辩殑闇€瑕侊紝鍏朵粬鑾峰彇绫诲瀷鍙傝€冩墜鍐屻€?/p>
闄や簡涓婇潰杩欑鑾峰彇鏁版嵁鐨勬柟寮忥紝杩樺彲浠ワ細
[php]
prepare(select * from foo); 
$rs->execute(); 
while($row = $rs->fetch()){ 
    print_r($row); 
} 
?> 
濡傛灉浣犳兂鑾峰彇鎸囧畾璁板綍閲屼竴涓瓧娈电粨鏋滅殑璇濓紝鍙互浣跨敤 pdostatement::fetchcolumn():
[php]
query(select count(*) from foo); 
$col = $rs->fetchcolumn(); 
echo $col; 
?> 
灏忕粨锛?br />鏌ヨ鎿嶄綔涓昏鏄疨do::query()銆丳do::exec()銆丳do::prepare()銆侾do::query()涓昏鏄敤浜庢湁璁板綍缁撴灉杩斿洖鐨勬搷浣滐紝鐗瑰埆鏄疭elect鎿嶄綔锛孭do::exec()涓昏鏄拡瀵规病鏈夌粨鏋滈泦鍚堣繑鍥炵殑鎿嶄綔锛屾瘮濡侷nsert銆乁pdate銆丏elete绛夋搷浣滐紝瀹冭繑鍥炵殑缁撴灉鏄綋鍓嶆搷浣滃奖鍝嶇殑鍒楁暟銆侾do::prepare()涓昏鏄澶勭悊鎿嶄綔锛岄渶瑕侀€氳繃$rs->execute()鏉ユ墽琛岄澶勭悊閲岄潰鐨凷ql璇彞锛岃繖涓柟娉曞彲浠ョ粦瀹氬弬鏁帮紝鍔熻兘姣旇緝寮哄ぇ锛屼笉鏄湰鏂囪兘澶熺畝鍗曡鏄庣櫧鐨勶紝澶у鍙互鍙傝€冩墜鍐屽拰鍏朵粬鏂囨。銆?/p>
鑾峰彇缁撴灉闆嗘搷浣滀富瑕佹槸锛歅dostatement::fetchcolumn()銆丳dostatement::fetch()銆丳dostatement::fetchall()銆侾dostatement::fetchcolumn() 鏄幏鍙栫粨鏋滄寚瀹氱涓€鏉¤褰曠殑鏌愪釜瀛楁锛岀己鐪佹槸绗竴涓瓧娈点€侾dostatement::fetch() 鏄敤鏉ヨ幏鍙栦竴鏉¤褰曪紝pdostatement::fetchall()鏄幏鍙栨墍鏈夎褰曢泦鍒颁竴涓腑锛岃幏鍙栫粨鏋滃彲浠ラ€氳繃pdostatement::setfetchmode鏉ヨ缃渶瑕佺粨鏋滈泦鍚堢殑绫诲瀷銆?/p>
鍙﹀鏈変袱涓懆杈圭殑鎿嶄綔锛屼竴涓槸pdo::lastinsertid()鍜孭dostatement::rowcount()銆侾do::lastinsertid()鏄繑鍥炰笂娆℃彃鍏ユ搷浣滐紝涓婚敭鍒楃被鍨嬫槸鑷鐨勬渶鍚庣殑鑷id銆侾dostatement::rowcount()涓昏鏄敤浜嶱do::query()鍜孭do::prepare()杩涜delete銆両nsert銆乁pdate鎿嶄綔褰卞搷鐨勭粨鏋滈泦锛屽pdo::exec()鏂规硶鍜孲elect鎿嶄綔鏃犳晥銆?br />銆愰敊璇鐞嗐€?br />1. 闈㈠悜瀵硅薄鐨勬柟寮弚ww.2cto.com
鍏堢湅鐪嬪鏋滆繛鎺ラ敊璇瓑鐨勫鐞嗭紝浣跨敤闈㈠悜瀵硅薄鐨勬柟寮忔潵澶勭悊锛?/p>
[php]
getmessage() .
; 
   die(); 
} 
?> 
杩欓噷鍒╃敤鎴戜滑php 5闈㈠悜瀵硅薄鐨勫紓甯稿鐞嗙壒寰侊紝濡傛灉閲岄潰鏈夊紓甯哥殑璇濆氨鍒濆鍖栬皟鐢≒doexception鏉ュ垵濮嬪寲涓€涓紓甯哥被銆?br />pdoexception寮傚父绫荤殑灞炴€х粨鏋勶細
[php]
绠€鍗曠殑鐪嬩竴涓婸hp 5鍐呯疆鐨勫紓甯稿鐞嗙被缁撴瀯锛?br />[php]
鐩稿簲鐨勶紝鍦ㄤ唬鐮佷腑鍙互鍚堥€傜殑璋冪敤 getfile() 鍜?getline() 鏉ヨ繘琛岄敊璇畾浣嶏紝鏇存柟渚跨殑杩涜璋冭瘯銆?br />2. 闈㈠悜杩囩▼鐨勬柟娉?br />[php]
$db = new pdo('mysql:host=localhost;dbname=test', $user, $pass); 
$rs = $db->query(select aa,bb,cc from foo); 
if ($db->errorcode() != '00000'){ 
    print_r($db->errorinfo()); 
    exit; 
} 
$arr = $rs->fetchall(); 
print_r($arr); 
$db = null; 
?> 
pdo鍜孭dostatement瀵硅薄鏈塭rrorcode() 鍜?errorinfo() 鏂规硶锛屽鏋滄病鏈変换浣曢敊璇? errorcode() 杩斿洖鐨勬槸: 00000 锛屽惁鍒欏氨浼氳繑鍥炰竴浜涢敊璇唬鐮併€俥rrorinfo() 杩斿洖鐨勪竴涓暟缁勶紝鍖呮嫭php瀹氫箟鐨勯敊璇唬鐮佸拰mysql鐨勯敊璇唬鐮佸拰閿欒淇℃伅锛屾暟缁勭粨鏋勫涓嬶細
[php]
array 
( 
    [0] => 42s22 
    [1] => 1054 
    [2] => unknown column 'aaa' in 'field list' 
) 
姣忔鎵ц鏌ヨ浠ュ悗锛宔rrorcode() 鐨勭粨鏋滈兘鏄渶鏂扮殑锛屾墍浠ユ垜浠彲浠ュ緢瀹规槗鑷繁鎺у埗閿欒淇℃伅鏄剧ず銆?br />
鎽樿嚜 娌冲ぇ鏉庝俊鐨?crazy coding浜虹敓
http://www.bkjia.com/phpjc/478348.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/478348.htmltecharticle鏈枃涓嶆秹鍙奝do鐨勫畨瑁咃紝鍙槸绠€鍗曟€荤粨涓€涓婸do鐨勪娇鐢ㄣ€?寮€濮嬫瀯閫犵涓€涓狿do搴旂敤锛屽湪web鏂囨。鐩綍涓嬪垱寤轰竴涓猵do.php鏂囦欢锛?[php] ?php $dsn = mysql:hos...