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
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌøתҳÃæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......
Ä¿Ç°ÔÚÎ人ÕÒ¹¤×÷
·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ
Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü
»¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³
Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......
PHPÀïÃ棬ÎÒµÄ±íµ¥Ã»ÓÐÌîдֵ£¬Ò²Ã»ÓÐÌá½»£¬ÕÕÀí˵isset²»³öÓÐÖµ¡£
ÎÒдµÄisset²éµ½ÓÐÖµ£¬µ«ÊÇechoһϣ¬¾ÍNotice: Undefined index: page in ÁË¡¡Ôõô»ØÊ°¡£¿
if(isset($_POST['page']))
{
echo $_POST['pa ......
ÎÒÏëѧϰһÏÂAJAX£¬°´×ÅÍøÉϵÄʵÀýÊÔÁËһϣ¬Ìá½»ºóûÓÐÈκη´Ó¦£¬Çë¸ßÊÖÖ¸½ÌÒÔÏ£¬´úÂëÈçÏ£¬
<script language="javascript">
function saveUserInfo()
{
//»ñÈ¡½ÓÊÜ·µ»ØÐÅÏ¢²ã
var msg = do ......