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âÊÔ·½·¨ÓÐÎÊÌâ¡£
Ïà¹ØÎÊ´ð£º
zend guard¼ÓÃܵÄphpÊÇ¿ÉÒÔÆÆ½âµÄ£¬ÓÐµÄ ËµÊÇʹÓú¯Êý»ìÏý¿ÉÒÔ¸üÄÑÆÆ½âһЩ¡£ÔõôʹÓÃÄØ¡£
»òÕß´ó¼Ò¸æËßÎÒÄÄÖÖ¼ÓÃÜ·½Ê½¸ü°²È«¡£Ð»Ð»ÁË¡£
ÎÒĿǰµÄzend guard°æ±¾ÊÇ4.0.1
ÎÞ½â
ÒýÓÃ
ÎÞ½â
²»¿ÉÄܰɡ£ÔÚÍøÉϲéÁ ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
ÏÖÓÐÒ»PHP¿Õ¼ä£¬Ö§³ÖMYSQLÊý¾Ý¿â
Ϊ½ÚÊ¡·ÑÓã¬ÏÖÏëͨ¹ýÓòÃûתÏòĿ¼ÐÎʽ½øÐйÜÀí£¨¼´½«ÓòÃûA¼Ç¼£Û°üÀ¨¶¥¼¶ÓòÃû¼°¶þ¼¶ÓòÃû£Ý¶¼Ö¸Ïòͬһ¿Õ¼ä£©
È磺·ÃÎÊÓòÃû abcd.cn Ö±½Ó·ÃÎÊÍøÕ¾¸ùĿ¼
·ÃÎʶþ¼¶ÓòÃû ef.abcd.cn ......
Çë½Ì¸ßÊÖ°ïæ£¬session_start£¨£©·ÅÔÚÍⲿµÄÎļþÓà require »ò include °üº¬½øÀ´£¬ÇëÎÊÕâÑù×öºÏÀíÂ𣿣¿´úÂëÔËÐÐÊÇÕý³£µÄ£¬ÕâÑù×öºÏÀíÂ𣿣¿Çë¸ßÊÖÖ¸µã¡£¡£¡£¡£ лл····
require »ò include ......
phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë
ÀýÈ磺
SELECT time, goodid from dbname1.time, dbname2.goods
ÊÇÕâ¸öÒâ˼ô£¿
SELECT time, goodid from ......