×Ô¼º½â¾öPHPÁ¬½ÓSQL SERVERµÄ°ì·¨
ÊÔÁ˺ܶàÍøÉϵķ½·¨£¬ÒÀ¾É²»ÄÜÁ¬ÉÏ£¬ËùÒÔÎÒ×Ô¼ºÑ¡ÓÃODBCÁ¬½Ómssql£¬³É¹¦£¬¼òµ¥¡£
·ÖÏíһϡ£
$server = "localhost";
$name="sa";
$ps="admin";
$database="ICD_DB_BILL";
$constr = "Driver={SQL SERVER};server=$server;Database=$database";
$conn= odbc_connect($constr,$name,$ps,SQL_CUR_USE_ODBC);
¸øÄã·¢ÕźÃÈË¿¨ ¶¥
ÓÃpdo°É
¸÷ÖÖ·½·¨¶¼ÊÔÊÔ¡£¡£
²»¹ýÄãÕâÑù×ö½«¶ªÊ§ºÜ¶¼Êý¾Ý¿âÌØÓй¦ÄÜ
Ö÷ÒªÊÇ×Ô¼ºÊÔÁ˺ܾö¼Ã»³É¹¦£¬ÏàÐźܶàÐÖµÜÒ²¶¼ÓÐÕâÑùµÄÇé¿ö£¬Ç¡ºÃÓÖ׿±½øÐÐÏîÄ¿£¬ÎÒÌù³öÀ´Ö÷ÒªÊÇΪÁËÈôó¼ÒÄܶàÒ»ÖÖÑ¡Ôñ¶øÒÑ£¬ºÇºÇ
ÎÒÏÖÔÚ»¹ÔÚÏë·½Éè·¨Á¬MSÄØ
ODBC¡£ Ö§³Öһϡ£
Ö§³Öһϣ¬ÐÅÏ¢·ÖÏí£¡ÔÞÒ»¸ö
È¥ÍøÉÏÕÒһϣ¬ÓÐÈ«Ì׵ݲװ¹¤¾ß£¬²»ÓÃÕâôÂé·³µÄ¡£
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌø×ªÒ³Ãæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......