phpÁ¬½ÓMSSQL Á¬²»ÉÏ - PHP / »ù´¡±à³Ì
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44
ÍêÁË
php.iniphp_mysql.dllÇ°ÃæµÄ·ÖºÅÈ¥µôÁË,ÎļþÒ²¿¼µ½WINDOWSÏÂÃæÈ¥ÁË
httpd.confÎļþÀïÒ²¼ÓÁËLoadFile c:\php\ntwdblib.dll
ÔõôÎÒÓÃPHPÁ¬½ÓmssqlÁ¬²»ÉÏ¡£¡£
ÀÏÊDZ¨Õâ¸ö´íÎ󡣡£
<?php
$ser ="220.*.*.*";
$db ='db';
$user="***";
$pass="*****";
$conn=odbc_connect("Driver={SQL Server};Server=$ser;Database=$db",$user,$pass) OR die("ÍêÁË");
if($conn) printf ("Connected successfully");
$sql="select * from city ";
$result=odbc_do($conn,$sql)or die("query failed");
$row=odbc_num_rows($result);
$fetch = odbc_fetch_array($result);
print_r($fetch);
?>
°ïÄã¶¥Ò»ÏÂ
ÎÒÓõÄÊÇMYSQL£¬²»»áMSSQL£¬°ï¶¥£¡
ûÓùýMSsql£¬apacheÖØÆôÁËÂð£¿
PHP code
Code highlighting produced by Actipro Co
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡
ÊÖ²áºÜÖØÒªµÄàÞ£¡~
ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ
Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â
php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£
È¥ÂòÊ¥¾°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......
²ËÄñÇó¾È£¡£¡
ÏÖÔÚÎÒÊÖÍ·ÓÐÒ»¸öphp+oracleµÄÍøÕ¾¡£¡£·þÎñÆ÷ÊÇlinuxϵͳ
Çë¸÷λ¸æËßÎÒÈçºÎ·¢²¼¡£¡£¡£ÎÒÊÇÐÂÊÖ¡£Ð»Ð»ÁË£¡£¡
°²×°Ò»¸öapache£¬°ÑphpÎļþ·Åµ½apacheµÄ·¢²¼Ä¿Â¼Ï£¬ ......
<?php
@session_start();
require_once './module/t_doctor.inc';
$t_doctor = new t_doctor();
if(isset($Submit)){
$sql="select * from t_doctor WHERE docname='".$usernam ......