Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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âÊÔ·½·¨ÓÐÎÊÌâ¡£




Ïà¹ØÎÊ´ð£º

php »ñÈ¡Ò³ÃæÄÚÈÝ - PHP / »ù´¡±à³Ì

Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......

phpÁª½Ó¶à¸öÊý¾Ý¿âµÄÎÊÌâ

mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

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---ǧ·Öλ·Ö¸ô·û£¿ - PHP / ¿ªÔ´×ÊÔ´

phpÖÐÈçºÎÊä³öǧ·Öλ·Ö¸ô·û¡£¡£¡£¡£¡£

number_format

PHP code:

//ÊÇÕâÖÖЧ¹û°É£¿
echo number_format(123123123, 2, '.', ',');
//½á¹ûÊä³ö123,123,123.00 2ÊÇСÊýµãºóλÊý£¬µÚÈý¸ö²ÎÊýÊÇСÊýµã·Ö¸ô·û ......

PHPÓëASP - PHP / »ù´¡±à³Ì

ÔÚPHPÖÐÓÐûÓÐÏñASPÖеļǼ¼¯(ADODB.Recordset )ÕâÖÖÀàÐ͵ĶÔÏó?¿É²»¿ÉÒÔÏñÔÚASPÖÐÒ»Ñùͨ¹ý¼Ç¼¼¯À´¸üÐÂÊý¾Ý¿â.ÈçÏÂÃæÕâÑù.
VBScript code:

set rs=server.createobject("adodb.recordset")
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ