I've just recently been playing with PHP, MS Access on a Windows server. So far i'm just able to read the database and not update/remove/insert data into it..
here's the code that should work for you.
function objConn(){
global $objConn;
$objConn = new COM('ADODB.Connection');
// you need both of these, if you use
//$objConn->Provider = 'Microsoft.Jet.OLEDB.4.0';
//$objConn->Open(DATA_DB);
// either one work seperately.
$objConn->Open('DRIVER={Microsoft Access Driver (*.mdb)}; DBQ='.DATA_DB);
//$objConn->Open('Provider=Microsoft.Jet.OLEDB.4.0; Data Source='.DATA_DB);
}
function objClose(&$objConn, &$objRS){
if(is_resource($objRS)){
$objRS->Close();
$objRS->Release();
$objRS = null;
}
if(is_resource($objConn)){
$objConn->Close();
$objConn->Release();
$objConn = null;
}
//global $objConn;
if(isset($objConn)){
unset($objConn);
//echo 'Unset';
}
}
// usage; 2 examples
objConn();
$objRS = $objConn->Execute("select * from Table1");
$id = $objRS->Fields('id');
while (!$objRS->EOF) {
print "$id->value<br />\n";
$objRS->MoveNext();
}
objClose($objConn, $objRS);
// or something like this, i find easier
$id = $objRS->Fields('field_name');
$id = $id->value;
while (!$objRS->EOF) {
echo "$id<br />\n";
$objRS->MoveNext();
}
objClose($objConn, $objRS);
in the objConn() function i have a few lines that are commented out. These lines do work.. instructions are commented above them.
hope this helps.
(if you find out how to insert data to MS Access, please post the code, i'd love to see it)
