php·ÃÎÊsqlserverÊý¾Ý¿âµÄÎÊÌâ - PHP / »ù´¡±à³Ì
ERPÈí¼þµÄÊý¾Ý¿âÊÇSQLSERVER2000µÄ£¬¹«Ë¾ÈÃÎÒ×ö¸öÍøÕ¾£¬ÆäÖÐÓÐЩÊý¾ÝÊǵ÷ÓÃERPÀïµÄ£¬ÎÒÏëÓÃPHP×öÍøÕ¾£¬µ«ÊDz»ÖªµÀPHP·ÃÎÊSQLSERVER¿âºÃʵÏÖ²»£¬ÔÙ¾ÍËÙ¶È·½ÃæÓ°Ïì²»»áÌ«´ó°É£¿¸úASP·ÃÎÊSQLSERVERÏà±ÈËٶȱ仯´ó²»£¿£¨ASPÖ÷ÒªÊǰ²È«ÐÔ²»Ì«ºÃ£¬²»ÏëÓÃËü£©
¶¥Ò»Ï£¬²»¾ÃÎÒÒ²µÃ°Ñmysql»»³ÉsqlserverÁË£¬µ½Ê±²»ÖªµÀ»áÓöµ½Ê²Ã´ÑùµÄÎÊÌâ
ÎÒÒ²ÓÃPHPÁ¬½ÓSQL Server×ö¹ýÍøÕ¾£¬¸Ð¾õ»¹¿ÉÒÔ
ûÓÐÌ«´óÎÒÇø±ð
$this->mssql = odbc_connect("Driver={SQL Server};Server=$dbserver;Database=$dbname;", $dbuser, $dbpsd);//mysql_connect ($dbserver, $dbuser, $dbpsd);
Á¬½ÓÊÇÕâÑùµÄ¡£
ÆäËûÀàËÆ¡£
2000µÄ³ýÁ˲Ù×÷º¯ÊýÃûºÍSQLÓï¾ä²»Ò»ÑùÍ⣬ÆäËû¶¼²î²»¶à
·ÃÎÊÊÇ¿ÉÒÔ·ÃÎÊ£¬µ«ÊÇ»¹ÊÇ»áÓÐһЩÎÊÌâµÄ¡£
Ê×ÏÈ£¬ÅäÖÃÎļþÒª¸Ä£¬°üÀ¨dllÎļþҪȫµÈ¿©¡£
È»ºóĿǰ×î¶ñÐĵľÍÊÇÓйØ×ªÒå·ûµÄÎÊÌ⣬mssqlµÄתÒå·û²»ÊÇ¡°/¡±£¬¶øÊÇ¡°'¡± ¡£Èç¹ûphpĬÈÏÔö¼ÓתÒå·ûÁË»¹ÒªÏÈÈ¥µôбÏߣ¬ÔÙ½øÐÐתÒå¡£
»¹ÓоÍÊÇsqlserver2000ºÃÏñ²»Ö§³ÖUTF-8£¬ÕâµãÒ²ºÜÓôÃÆ£¬²»ÖªµÀÄÄλ´óÉñÓÐʲô·½·¨½â¾ö¡£
¶ÔÁË£¬Â¥Ö÷µÄERPÈí¼þÊDz»ÊÇÓÃÓÑ£¿
ÎҼǵÃËûÊÇSQL SERVERµÄÊý¾Ý¿â°É
ÎÒÊÔ¹ýÁË£¬phpÁ¬½Ómssql³ýÁ˺¯ÊýÖ®ÍâÆäËû±ä»¯²»´ó£¬×öÆðÀ´µ¹ÊDz»Âé·³£¬Ö÷ÒªÊǵ£ÐÄ·ÃÎÊËÙ¶È¡£ÎÒÔÚ×Ô¼ºµçÄÔÉÏ´óÌå²âÊÔÁËһϣ¬¸Ð¾õ·ÃÎÊMSSQL²»Èç·ÃÎÊMYSQLËٶȿ죬Ҳ¿ÉÄÜÊÇÎҵIJâÊÔ·½·¨ÓÐÎÊÌâ¡£
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ĿǰÔÚÎ人ÕÒ¹¤×÷
·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ
Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü
»¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³
Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
ÎÒ×î½üдÁ˸ömailÖ´ÐкóûÓгöÏÖ´íÎóÐÅÏ¢Ö´ÐÐÍê±ÏºóÓÊÏäÀﲢû·¢ËÍÓʼþ£¬Çë¸÷λ°ïÎÒ¿´¿´
ÎÒÓõĵÄÊÇiis smtp
<?php
$to = 'xueyuxia1988@sohu.com';
$subject = 'the subject';
$message = 'hello';
$ ......
phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë
ÀýÈ磺
SELECT time, goodid from dbname1.time, dbname2.goods
ÊÇÕâ¸öÒâ˼ô£¿
SELECT time, goodid from ......