Çë½Ì phpÁ¬½Óaccess ·½·¨ ¼±£¡
Çë½Ì phpÁ¬½Óaccess ·½·¨ ´úÂë ,¹âÓÐÄǸö´úÂëºÃÏñ²»ÐУ¬ÊDz»ÊÇҪʲôÅäÖÃ,
ÎÒÁ¬½ÓµÄʱºòÀÏÊdzöÏÖ´í(ÎÒûÓÐÓùýÕâ¸öÁ¬½Ó).
Ï£Íû¼ÓÒ»¸ö±ãÀû´úÂ룬ÎҺó¢ÊÔһϣ¬Ð»Ð»£¡
Ò»°ãÀ´Ëµ£¬ÔÚÊý¾Ý¿â·½Ã棬phpºÍmysql²ÅÊǻƽð´îµµ£¬µ«ÓÐЩʱºòÓÈÆäС¹æÄ£Êý¾Ý´æ·ÅÔÚaccesssÖÐʱ£¬¿ÉÄܾÍÐèÒªÁ¬½ÓÒ»ÏÂÁË¡£Ç°¼¸Ì죬ÒòΪҪ¸øÀÏʦ°ÑһЩͼƬ´ÓaccessÊý¾Ý¿âÖÐÌáÈ¡³öÀ´Éú³ÉÎļþ£¬×Ô¼º¶ÔvbÖ®ÀàÓв»Ì«ÊìϤ£¬¾Í°Ù¶ÈºÍ²éÊÖ²áÓÃphp½â¾öÁËһϣ¬ÏÖÔÚ°ÑһЩÐĵÃдһÏ¡£
phpÁ¬½Óaccess,ÓõÄÊÇodbcÏà¹Øº¯Êý¡£Á¬½ÓµÄ´úÂëÈçÏ£º
<?php
$connstr="DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath("mydb.mdb");
$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC );
?>
ÈçÉϾͽ¨Á¢ÁËÒ»¸öÁ¬½Ó£¬mydb.mdb¾ÍÊÇÄãÒªÁ¬½ÓµÄaccessÊý¾Ý¿â£¬½ÓÏÂÀ´¾ÍÒªÖ´ÐÐsql²éѯ£¬¸úmysqlÀàËÆÓÖÓÐЩ²»Ò»Ñù¡£
$rs=odbc_do($connid,¡°sql²éѯ¡±)£»Ö´Ðвéѯ²¢·µ»Ø¡£
odbc_fetch_row($rs),ÓëmysqlÓÐÒ»µã²î±ð£¬odbcÎÞÐè·µ»Ø£¬Ö»ÓÐÖ´ÐÐodbc_do()Ö®ºó£¬²Å¿ÉÒÔÀûÓÃodbc_result(),À´»ñµÃ½á¹û¡£
$f1=odbc_result($rs,n)£¬ÓÃÀ´»ñµÃ²éѯ½á¹û£¬n´Ó1¿ªÊ¼È¡Öµ£¬±íʾµÚ¼¸¸ö×ֶΣ¬Ò²¿ÉÓÃ×Ö¶ÎÃû³Æ´úÌæ¡£
»ù±¾µÄ¾ÍÕâЩÁË£¬¸ü¶àµÄº¯Êý¿ÉÒԲο¼phpÊÖ²áµÄodbcº¯Êý²¿·Ö£¬¸ù¾ÝmysqlµÄÀà±È¾Í¿ÉÒÔ¡£
»¹ÓÐÒ»µãҪ˵Ã÷µÄÊÇ£¬ÔÚphp.iniÓйØÓÚ¶ÁÈ¡odbcÊý¾Ý¿âÄÚÈÝ´óСµÄÏÞÖÆ£¬Ä¬ÈÏΪ4kb£¬ÈôÊý¾Ý¿âÖÐÓÐ×ֶδóС³¬³ö¾Í»á³öÏÖÄÚÈݲ»È«£¬ÉèÖ÷½·¨ÔÚphp.iniÖÐÕÒµ½
odbc.defaultlrl£¬°ÑËüºó±ßµÄÊýÖµÔö´ó¼´¿É¡£
ÏÂÃæ¾Ù¸öÀý×Ó£º
ÔÚmydb.mdbÖÐÓиöpic±í£¬±íÖÐÁ½¸ö×ֶΣ¬Ò»¸öÊÇÃû³Æ,Ò»¸öÊÇpicid,ÏÖ
Ïà¹ØÎÊ´ð£º
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......
¹ýÍêÄêҪȥÎ人ÁË£¬ÏëÁ˽âÒ»ÏÂPHPÅàѵ±È½ÏÕý¹æ?
Ŷ ¶ÔÁË£¬»¹ÓУ¡PHPÊÖ²á±ØÐëµÃŪһ¸ö
àÅ ÌìÌìÔÚ¿´Ê¥¾£¨Ò»ÌìÒ²¾ÍÖ»ÄÜ¿´¸ö¶þʮҳ£©£¬PHP100ÊÓÆµ½Ì³Ì¿´ÁË33½²ÁË£¨Ò»ÌìÒ²Ö»¿´Ò»½²£©
ÎÒ»á¼á³Ö°ÑÕâ±¾ÊéºÍÊÓÆµ¸ã¶¨ ......
ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌø×ªÒ³Ãæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......