Using the ODBC function of PHP, do not create a data source.
$connstr = "Driver=microsoft Access DRIVER (*.mdb);D bq=". Realpath ("Test.mdb");
$connid =odbc_connect ($connstr, "", "", SQL_CUR_USE_ODBC);
Pro-Test code, available OH.
PHP + Access Sample code.
<?php/*** This file was just for an example of php+access. You can find these functions from http://www.php100.com/cover/php/1681.html*//* ODBC String */$odbc = "Driver={microsoft A ccess Driver (*.mdb)};D bq= ". Realpath (" Our.mdb "); $conn = Odbc_connect ($odbc,", ", sql_cur_use_odbc); $sql =" SELECT * From test "; $query = Odbc_exec ($conn, $sql);p rint $query." </br> "; $num = Odbc_num_fields ($query); if ($num! = 0) for ($i =1; $i < $num; $i + +) {$row = Odbc_fetch_row ($query); echo ",". Odbc_result ($query, "Addr"). " </br> ";//echo". Odbc_result ($query, 3). </br> "; /* The same as line 24*/}elseprint "No data";? >
PHP Connect Access database code