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

php ʹÓà ADODB Á¬½ÓAccess µÄÎÊÌâ

<?php

include("adodb/adodb.inc.php");

$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=$access;";
// $dsn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=$access;";

$db->Connect($dsn) or
die("Connect({$dsn}) Fail!\r\n$db->ErrorMsg()");

?>

ÈçºÎÓÃÕâÁ½ÖÖÁ¬½Ó×Ö·û´®,ÈóÌÐòÅÜÆðÀ´
$dsn = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=$access;";
// $dsn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=$access;";

ÁíÍâ,ÇëÎÊ´øÃÜÂëµÄÁ¬½Ó ÓÃÕâÁ½ÖÖÁ¬½Ó ÈçºÎʵÏÖ?

СµÜÀ§ÈÅÁ˺þÃÁË,Çë¸÷λǰ±²ÃDz»ÁߴͽÌ,Ö¸µãÃÔ½ò!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Ê®·Ö¸Ðл!!!!!!!!!!!
ÒÔǰдµÄ PHPÁ¬½ÓAccessÊý¾Ý¿âÎÞ´í°æ
http://blog.csdn.net/brothercat/archive/2006/07/21/952716.aspx

Èç¹û¼ÓÉÏÃÜÂ룬
½«
$connStr="Provider = Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("easy.mdb");
¸Ä³É
$connStr="Provider = Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("easy.mdb").";Database Password=123";
ÊÔÊÔ£¬123±íʾÃÜÂë×Ö·û´®

»¹ÊÇÄǾäÀÏ»°,½¨ÒéʹÓÃPDOÈ¥Á¬½Ó...

http://cn2.php.net/manual/en/ref.pdo-dblib.php#86668

ÒýÓÃ
Èç¹û¼ÓÉÏÃÜÂë£


Ïà¹ØÎÊ´ð£º

PHPÀ©Õ¹CʱµÄÎÊÌâ

ÎÒÓÃPHPÀ©Õ¹Cʱ£¬ÓõÄÊÇÔ´ÂëextĿ¼ÏµÄ./ext_skel
×îºó±àÒë×ÜÊDz»ÄÜÉú³ÉÀ©Õ¹Ä£¿éµÄ.so¶¯Ì¬¿â£¬ÎÒÓõİ汾ÊÇ5.3.0£¬
ÕâÊÇÔõô»ØÊ£¬¸ßÊÖ½â´ðÏÂ

²»ÄÜÉú³ÉʱÓÐɶÌáʾÐÅÏ¢£¿

ÔËÐÐÁË/ext_skel --extname=Ä ......

Ô¶³ÌlinuxÖ÷»úÉÏ,php ÎÞ·¨´´½¨Ð´ÈëÎļþ

ÓôÃÆÀ²£¬Õû¸öÎļþ¼ÐµÄÊôÐÔÎÒÒ²ÉèÖóÉ777ÁË,¾ÍÊDz»ÐС£

ÔÚÁíÍâһ̨linux·þÎñÆ÷ÉϽøÐÐͬÑùµÄ²Ù×÷£¬È´¿ÉÒÔÖ´ÐС£ ±ÈÈç ÔÚÏß½âѹ£¬¶¼³É¹¦ÁË¡£

µ«ÊÇÔÚÕą̂»úÆ÷ÉÏ£¬ËÀ»î¶¼²»ÐУ¬×ÜÊÇ permission denied...ÔÎ ......

±±¾©¼±ÕÐlinux¡¢PHPÍøÂçÓ¦Óÿª·¢

ÎÒÃÇÁ¥ÊôÖпÆÔº¼ÆËãËùÍøÂçÖصãʵÑéÊÒ(http://www.ict.ac.cn/survey/channel/detail443.asp)»ù´¡ÉèÊ©¿ÎÌâ×é.
ÏÖÒòÏîÄ¿ºÍÒµÎñÍØÕ¹µÄÐèÒª,ÌØÐèÒªÕÐƸÓëÏîÄ¿Ïà¹ØµÄÍøÂçÓ¦Óù¤³Ìʦ1-2Ãû¡£

¾ßÌåÒªÇóÈçÏ¡£ÓÐÒâÕß ......

access Êý¾Ý¿â SQLÓï¾äÔõôÑùËæ»úÑ¡ÔñÊý¾Ý£¿£¿

³ÌÐòʱASP+access

sql="select top 2 id,username from comp    order by rnd(id)  "

ÉÏÃæÓï¾äˢкó¶¼ÊÇÒ»¸öÖµ ÕâÑù»¹ÓÐËæ»úµÄÒâÒåÂð

ACCESSÓÐË¢ÐÂËæ»úÑ¡ÔñµÄSQLÓ ......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ