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
Ïà¹ØÎÊ´ð£º
mb_convert_encoding ("ÄãºÃ", "HTML-ENTITIES", "gb2312"); //Êä³ö£º你好
mb_convert_encoding ("你好", " ......
ר³¤ÏµÍ³ÐèÇó·ÖÎöºÍ¹ÜÀí£¬ÏµÍ³¿ª·¢£¬ÒÔ¼°²úÆ·£¨ÉÌÒµ£©²ß»®¹ÜÀíºÍÑз¢¡£
ÎÒµÄÓ¢ÓïÒ²ºÜ²»´í.ËÄÁù¼¶ºÍ¿ÚÓï¶¼ÊÇA¼¶.
ÎҵļòÀúÔÚ¸öÈËÍøÕ¾£ºwww.ideawo.czm.cn/webapp/resume.html
ÇëCSDNµÄXDJM°ïæ,ÅúÆ ......
SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";
ÉÏÃæÊÇÎÒдµÄsqlÓï¾ä Reader_TimeÊÇʱ¼äÀàÐÍ idΪÊý×Ö ......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......