PHPÖÐͨ¹ýADOµ÷ÓÃAccessÊý¾Ý¿â-PHP¼¼Êõ-3P´úÂëÍø
¡¾·±ÌåÖÐÎÄ¡¿
¡¾ÉèΪÊ×Ò³¡¿
¡¾¼ÓÈëÊղء¿
µ±Ç°Î»ÖãºPHP¼¼ÊõÊ×Ò³ >> Êý¾Ý¿âÏà¹Ø >> PHPÖÐͨ¹ýADOµ÷ÓÃAccessÊý¾Ý¿â

PHPÖÐͨ¹ýADOµ÷ÓÃAccessÊý¾Ý¿â

2004-10-01 08:26:10  ×÷Õߣº  À´Ô´£º»¥ÁªÍø  ä¯ÀÀ´ÎÊý£º34  ÎÄ×Ö´óС£º¡¾´ó¡¿¡¾ÖС¿¡¾Ð¡¡¿
¼ò½é£ºÎÒ¿´ÁËÄÇÆª¡¶ÔõÑùÔÚPHPÖÐͨ¹ýADOµ÷ÓÃAsscessÊý¾Ý¿âºÍCOM³ÌÐò¡·ÎÄÕºó£¬ÂíÉÏ×÷Á˲âÊÔ£¬½á¹ûʧ°ÜÁË¡£ÉËÐÄÊDz»ÊÇ¡£ Ôõô°ì£¿ÎÒÖ»ºÃÈ¥PHP¹Ù·½ÍøÕ¾ÇóÖú£¬»ÊÌì²»¸ºÓÐÐÄÈË£¬ÖÕÓÚÎÒÕÒµ½Á˴𰸡ª¡ª ¾ßÌåµÄ½â¾ö·½·¨ÈçÏÂ...
¹Ø¼ü×Ö£ºÊý¾Ý¿â Access ADO PHP

ÎÒ¿´ÁËÄÇÆª¡¶ÔõÑùÔÚPHPÖÐͨ¹ýADOµ÷ÓÃAsscessÊý¾Ý¿âºÍCOM³ÌÐò¡·ÎÄÕºó£¬ÂíÉÏ×÷Á˲âÊÔ£¬½á¹ûʧ°ÜÁË¡£ÉËÐÄÊDz»ÊÇ¡£

Ôõô°ì£¿ÎÒÖ»ºÃÈ¥PHP¹Ù·½ÍøÕ¾ÇóÖú£¬»ÊÌì²»¸ºÓÐÐÄÈË£¬ÖÕÓÚÎÒÕÒµ½Á˴𰸡ª¡ª

¾ßÌåµÄ½â¾ö·½·¨ÈçÏ£º

£¨1£©½øÈëhttp://php.weblogs.com/adodb£¬ÏÂÔØÏàÓ¦µÄZIP°ü£»Í¬MICROSOFT¹«Ë¾µÄADOÒ»Ñù£¬¸Ã¶«¶«ÓÃPHPʵÏÖADOͬ¸÷ÖÖ¸÷ÑùÊý¾Ý¿â´ò½»µÀ£¨Ì«ºÃÁË£¬ËùÓÐÀàÐ͵ÄÊý¾Ý¿â¶¼ÄÜ´¦Àí£©¡£

£¨2£©½â°ü£¬ÀïÃæÎļþºÜ¶à£¬²»¹ýÓÐÓõÄÖ»ÓÐohtml.inc.phpºÍadodb.inc.php£¬°ÑËüÃǸ´ÖƵ½ÏàӦĿ¼Ï£¨»òÊǰ²×°php4µÄȱʡĿ¼ÏÂc:\php4\peer\£¬»òÊǵ±Ç°ÔËÐгÌÐòĿ¼Ï£¬ÊÓinclude()º¯Êý¶ø¶¨£©£»

£¨3£©È»ºóÔÚ±¾¼¦£¨´íÎó×ÖÒ»¸ö£¬ÊÇ»ú£©µÄc:\myphpĿ¼ÏÂ(iisÏÂÉèÖÃͨ¹ýhttp://localhost/jhkÀ´·ÃÎÊ)£¬ÔìÁËÒ»¸öÃûΪtest.mdbµÄaccess¿â£¬ÀïÍ·ÔÙÔì¸öexpertsµÄ±í¡­¡­¡£ÎªÁËͨ¹ýDSNÀ´·ÃÎÊ£¬ÎҰѸղŵÄACCESS¿âÔÚDSNÖÐÈ¡Ãûtest¡£

£¨4£©ÔËÐС£¿´×Å˵Ã÷ÊéÎÒÔìÁËÕâô¸ö³ÌÐò£º

dbtest.php£¬ÄÚÈÝÈçÏ£º

include('tohtml.inc.php'); // load code common to ADODB

include('adodb.inc.php'); // load code common to ADODB

$conn = &ADONewConnection('access'); // create a connection

$conn->PConnect('test');// connect to MySQL, agora db

$sql = 'select name, group1 from experts';

$rs = $conn->Execute($sql);

rs2html($rs,'border=2 cellpadding=3',array('Customer Name','Customer ID'));

$rs->Close(); // optional

$conn->Close(); // optional

?>

È»ºó£¬IEÖдòÈ룺http://localhost/jhk/dbtest.php

°¦£¡½á¹û³öÀ´ÁË¡£ ÁîÈË»ù±¾ÂúÒ⣡£¡

£¨5£© ½Ó×Å£¬ÎÒÓÖÏ룺»¹ÒªÉèÖÃDSN£¬·³²»·³£¡ÈƹýDSNÓ¦ÈçºÎ½â¾ö£¿ÒòΪÔÚaspÖУ¬ÎÒϰ¹ßÓÃconn.open("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("../nydatabase.mdb"))À´´¦Àímdb¿â£¬ÄÇËÙ¶È¿ìѽ£¡

£¿¡­¡­ÏëÁËÓÖÏ룬¿´ÁËÓÖ¿´¡­¡­¡£

ÕÒÕÒÕÒ£¬¡­¡­£¬ºÙºÙ£¬ÖÕÓÚÔÚtestdatabases.inc.php ÖÐÕÒµ½Á˴𰸣¡ ÎÒÔٰѸղŵijÌÐò¸Ä±à£º

include('tohtml.inc.php'); // load code common to ADODB

include('adodb.inc.php'); // load code common to ADODB

$db = &ADONewConnection("ado_access");

print "

Connecting $db->databaseType...

";

$access = 'test.mdb';

$myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'.'DATA SOURCE='. $access . ';';.'USER ID=;PASSWORD=;';

if (@$db->PConnect($myDSN, "", "", "")) {

print "ADO version=".$db->_connectionID->version."
";

$sql = 'select name, group1 from experts';

$rs = $db->Execute($sql);

rs2html($rs,'border=2 cellpadding=3',array('Customer Name','Customer ID'));

} else print "ERROR: Access test requires a Access database $access".'
'.$db->ErrorMsg();

?>

ÔËÐС£

Ò»Çи㶨£¡

ÔðÈα༭£ºadmin
±¾ÎÄÒýÓõØÖ·£º http://www.3pcode.com/php/2004/10/8804.htm
Ïà¹ØÎÄÕÂ