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âÊÔ·½·¨ÓÐÎÊÌâ¡£
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ĿǰÔÚÎ人ÕÒ¹¤×÷
·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ
Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü
»¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³
Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......
ÔÚPHPÖÐÓÐûÓÐÏñASPÖеļǼ¼¯(ADODB.Recordset )ÕâÖÖÀàÐ͵ĶÔÏó?¿É²»¿ÉÒÔÏñÔÚASPÖÐÒ»Ñùͨ¹ý¼Ç¼¼¯À´¸üÐÂÊý¾Ý¿â.ÈçÏÂÃæÕâÑù.
VBScript code:
set rs=server.createobject("adodb.recordset")
......
ÎÒÒª×öÒ»¸ö»áÔ±×¢²áÆä±ØÐëÒªÊäÈëÊÖ»úºÅ»ñµÃÊÖ»úÑéÖ¤Â룬ÄãÃÇ˻ᰡ£¡
ÏȽøÐÐÊÖ»úÑéÖ¤»¹ÊÇÏÈ×¢²áÔÙÑéÖ¤£¿
ÐèҪʵÏÖÑéÖ¤Âë¶ÌÐÅ·¢Ë͵½ÊÖ»úÄÇÖÖ°É¡£ÐèÒª¶ÌÐŽӿڻòÕßÂò¸ö¶ÌÐÅè½øÐпª·¢
ÐèÒª½Ó¿ÚµÄ
²Î¿¼µØÖ·£ºht ......