鍦≒hp鎿嶄綔mssql鏃堕渶瑕佸厛纭畾绯荤粺鐨勮繍琛岀幆澧冩槸鍚︽敮鎸侊紝杩愯浠ヤ笅璇彞灏辩煡閬撲簡
[php]
if (function_exists('mssql_connect')){
echo '鏈嚱鏁板瓨鍦紝璇存槑鐜鏀寔mssql';
}else{
echo '浣犵殑鐜涓嶆敮鎸丮ssql锛岃鍘籄pache涓厤缃?#39;;
}
if (function_exists('mssql_connect')){
echo '鏈嚱鏁板瓨鍦紝璇存槑鐜鏀寔mssql';
}else{
echo '浣犵殑鐜涓嶆敮鎸丮ssql锛岃鍘籄pache涓厤缃?#39;;
}褰揚hp鐜涓嶆敮鎸佹椂璇峰厛瀹変互涓嬬殑鏂规硶杩涜鐜鐨勯厤缃?/p>
1銆佹墦寮€浣犵殑php.ini閰嶇疆鏂囦欢锛屾妸extension=php_pdo_mssql.dll鍜宔xtension=php_mssql.dll鍓嶉潰鐨?ldquo;;”鍘绘帀锛屽敖閲忔壘鍒板拰mssql鐩稿叧鐨勫瓧鐪硷紝閮芥妸浠栧惎鐢紱
2銆佷綘鐨勮繍琛岀幆澧冧腑涓嶄竴瀹氭湁杩炴帴mssql鐨勮繛鎺ュ簱锛屾墍浠ヤ綘蹇呴渶妫€鏌ヤ竴涓嬩綘鐨凱hp鐩綍涓嬫槸鍚﹀瓨鍦╡xt鐩綍涓嬬殑php_mssql.dll鍜宯twdblib.dll锛岀綉涓婃湁鏂囩珷璇撮渶瑕丆opy鍒癢indows/system32鐩綍涓嬶紝 濡傛灉杩炴帴涓嶄笂鐨勮瘽鍙互璇曚竴涓嬶紱
3銆侀噸鍚竴涓婣pache锛屽啀涓嶈浣犲氨鏁翠釜鏈哄瓙閲嶅惎锛堟湁鏃跺€欏氨鏄繖涔堝彉鎬侊級銆?/p>
鍋氬畬涓婇潰鐨?姝ュ悗涓嶈浠ヤ负瀹屾垚浜嗭紝鍙互鎼炲畾php+mssql浜嗭紝鍚庨潰杩樻湁瀛楃闆嗙殑闂銆?/p>
[php]
mssql_select_db($db_name,$conn);
$sql=insert into contacts (id,memberno,name,customerstateid,ext,phone,mobile,email,qq,gender,company,province_id,city_id,address,postalcode) values (4,'bx4','鍒樺姜',1,'','','13924007557','','153216429','鐢?#39;,'鍗庡悍淇濋櫓浠ｇ悊鏈夐檺鍏徃骞夸笢鍒嗗叕鍙?#39;,0,0,'骞垮窞甯傝秺绉€鍖鸿揪閬撹矾5鍙峰箍宸炲啗鍖烘湇鍔′腑蹇冨ぇ鍘?妤?#39;,'510035');
$sql=iconv('utf-8','gb2312',$sql);//杩欎釜杞崲蹇呴渶锛屽鏋滀綘鐨勭紪鐮佹槸涓€鑷寸殑璇濊繕濂藉姙锛屾垜灏辨槸鍦ㄨ繖涓棶棰樹笂绾犵粨浜嗗緢涔?nbsp;
$query=mssql_query($sql,$conn);
mssql_select_db($db_name,$conn);
$sql=insert into contacts (id,memberno,name,customerstateid,ext,phone,mobile,email,qq,gender,company,province_id,city_id,address,postalcode) values (4,'bx4','鍒樺姜',1,'','','13924007557','','153216429','鐢?#39;,'鍗庡悍淇濋櫓浠ｇ悊鏈夐檺鍏徃骞夸笢鍒嗗叕鍙?#39;,0,0,'骞垮窞甯傝秺绉€鍖鸿揪閬撹矾5鍙峰箍宸炲啗鍖烘湇鍔′腑蹇冨ぇ鍘?妤?#39;,'510035');
$sql=iconv('utf-8','gb2312',$sql);//杩欎釜杞崲蹇呴渶锛屽鏋滀綘鐨勭紪鐮佹槸涓€鑷寸殑璇濊繕濂藉姙锛屾垜灏辨槸鍦ㄨ繖涓棶棰樹笂绾犵粨浜嗗緢涔?br />$query=mssql_query($sql,$conn);濡傛灉涓嶄笂iconv杞崲锛屼笉鍚岀殑缂栫爜浼氶€犳垚mssql_query杩斿洖false,鎴戝凡缁忎娇鐢ㄤ簡@mssql_query(set names utf8,$conn);杩涜杞崲锛屾殏鏃朵笉鐭ラ亾涓轰粈涔堜笉琛岋紝鎵€浠ユ墍鏈夌殑sql璇彞閮借缁忚繃杞崲銆?/p>
瀹屾垚涓婇潰鐨勫熀鏈槸鍙互瀵规暟鎹簱杩涜鎿嶄綔浜嗐€?/p>
http://www.bkjia.com/phpjc/477514.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/477514.htmltecharticle鍦≒hp鎿嶄綔mssql鏃堕渶瑕佸厛纭畾绯荤粺鐨勮繍琛岀幆澧冩槸鍚︽敮鎸侊紝杩愯浠ヤ笅璇彞灏辩煡閬撲簡 [php] if (function_exists(mssql_connect)){ echo 鏈嚱鏁板瓨鍦紝璇存槑鐜鏀?..