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âÊÔ·½·¨ÓÐÎÊÌâ¡£
Ïà¹ØÎÊ´ð£º
ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌøתҳÃæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
ÏÖÔÚÓÐa,bÈý¸öÒ³Ãæ
bÊǵǽҳÃ棬·ÃÎÊaÒ³Ã棬Èç¹ûûÓеǼ£¬Ôòheaderµ½bÒ³Ãæ
ÔÚbÒ³ÃæÈ¡²»µ½HTTP_REFERER
òËÆHTTP_REFERERÖ»ÄÜÈ¡µ½a±êÇ©ºÍpost,get·½·¨µÄÌøת
Äܲ»ÄÜαÔìÒ»¸öHTTP_REFERER£¬È»ºó¹ýÈ¥£¿
¼ÈÈ»Ö ......