ΪʲôPHPÁ¬½ÓmssqlÒ»µã·´Ó³¶¼Ã»ÓУ¬³õѧ£¬ÔÚÏßµÈ
ÎÒµÄÓï¾äÈçÏ£º
$myServer = "124.172.125.197"; //Ö÷»ú
$myUser = "jmkjxy"; //Óû§Ãû
$myPass = "jmkjxy023"; //ÃÜÂë
$myDB = "jmkjxy"; //MSSQL¿âÃû
$s = @mssql_connect($myServer, $myUser, $myPass);
$err = @mysql_error();
if($err){
echo "·¢Éú´íÎó£¬Çë֪ͨվ³¤";
}
else
{
echo "³É¹¦";
}
$d = @mssql_select_db($myDB, $s);
$query = "SELECT * from TAB_XI where id =1";
$result = @mssql_query($query);
$numRows = @mssql_num_rows($result);
$zongshu = @mssql_num_rows($query);
µ«ÊÇʲôÊä³ö¶¼Ã»ÓУ¬ÎÒ²âÊÔÁ˵ģ¬Êý¾Ý¿âµØÖ·ºÍÕʺÅÃÜÂë¶¼ÊǶԵÄ
»¹ÓÐÎÒ¿´ºÜ¶àµç×ÓÊ飬ÔÚ@mssql_connectº¯Êýǰ£¬¶¼Ã»ÓÐ@·ûºÅ£¬ÓеÄÓÖÓУ¬µ½µ×ÊǼӻ¹ÊDz»¼Ó°¡£¿
´ó¼Ò°ïÎÒ¿´¿´£¬ÎÒµÄÓï¾äÄÄÀïÓÐÎÊÌ⣿
¼Ó@ÊÇÆÁ±Î´íÎ󣬶¼²»¼Ó¿´±¨Ê²Ã´´íÎó£¡
¼Ó@±íʾÆÁ±Îµô´íÎóÐÅÏ¢£¬Ö»ÓÐÔÚ×ÔÐд¦Àí´íÎóʱ²ÅÓÃ
$s = mssql_connect($myServer, $myUser, $myPass) or die('Á¬½ÓÊý¾Ý¿âʧ°Ü '.mssql_get_last_message());
$d = mssql_select_db($myDB, $s) or die('Ñ¡ÔñÊý¾Ý¿âʧ°Ü '.mssql_get_last_message());
$query = "SELECT * from TAB_XI where id =1";
$result = mssql_query($query) or die('²éѯʧ°Ü $query '.mssql_get_last_message());
$numRows = mssql_num_rows($result);
·þÎñûÓпªÆô£¿
{{--
Ïà¹ØÎÊ´ð£º
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
±¾È˸սӴ¥PHP,ÍêÈ«²»´ó¶®µÄ,ÔÚPHPÒ³ÃæÓбäÁ¿$fID; $_SESSION['mid']
ÏÖÔÚJSÀïÒªÅжÏÊÇ·ñ´æÔڴ˱äÁ¿$fID; »òÊÇ·ñ´æÔÚ$_SESSION['mid']
ÔÚ1.jsÒ³ÃæÀïÕâÑùÅжÏÒ²²»ÐÐ
function showdiv()
{
var kk=<?= $fID ? ......
ÇëÎÊÈçºÎÓÃphp¸øÊÖ»úÓû§·¢ËͶÌÐŰ¡¡£
¾ßÌåÈçÏ£º
1.Èç¹û¿ÉÒÔ·¢£¬ÊÇͨ¹ýAPI»¹ÊÇ˵ÎÒÃÇ·¢Óʼþ¸ø´úÀíÉÌ£¬ÈôúÀíḚ́ïÎÒÃÇ·¢¶ÌÐÅ£¿
2.Èç¹ûÊÇͨ¹ý´úÀíÉÌÀ´·¢£¬ÄÇôÊÇÔõôÊշѵİ¡£¿ÊÇÒ» ......
ÒѾÐÞ¸ÄÁË
£¨1£©PHP.iniÖеÄpost_max_size ºÍupload_max_filesize£¬²¢ÇÒ±£Ö¤ÁËǰÕß´óÓÚºóÕß
£¨2£©Windows\System32\inetsvr\MetaBase.xmlÖеÄAspMaxRequestEntityAllowed
ÐÞ¸ÄÍê±Ïºó£¬ÖØÐÂÆô¶¯ÁËIIS·þÎñ£¬²¢ÇÒ¼Æ ......