MS Access database AND MySQL

<?php
function dump($a) {
    echo '<pre>'.print_r($a, true).'</pre>';
}

// assumption: no usernames/passwords set for accessing
$source = getcwd().DIRECTORY_SEPARATOR.'db.mdb';
if (($con = odbc_connect('Driver={Microsoft Access Driver (*.mdb)};Dbq='.$source, '', '', SQL_CUR_USE_ODBC)) === false) {
    die('connection failed');
}

// odbc_prepare will only halt on syntax error, it isn't until execution a query fails,
// for example because you refer to a a nonexistent table...
// odbc_exec both prepares and executes a query (so it's odbc_prepare() and odbc_execute() combined)

// for a list of tables use odbc_tables
$tables = array();
$res = odbc_tables($con);
while ($row = odbc_fetch_array($res)) {
    if ($row['TABLE_TYPE'] == 'TABLE') {
        $tables[] = $row['TABLE_NAME'];
    }
}
odbc_free_result($res);
dump($tables);

// for a table definition
// @see http://www.php.net/manual/en/function.odbc-columns.php comments
// cannot seem to get odbc_columns to work, or I don't understand how to use
$table = array();
$res = odbc_exec($con, 'SELECT * FROM someTable WHERE 1=2');
$n = odbc_num_fields($res); // field numbering starts at 1
for ($i=1; $i <= $n; $i++) {
    $field_name = odbc_field_name($res, $i);
    $table[$field_name] = array(
        'type'      => odbc_field_type($res, $i),
        'length'    => odbc_field_len($res, $i),
    );
}
odbc_free_result($res);
dump($table);

// fetch some data
$res = odbc_exec($con, 'SELECT * FROM someTable') or die(odbc_error($con));
while ($row = odbc_fetch_array($res)) {
    dump($row);
}
odbc_free_result($res);

odbc_close($con);
?>

<?php
function dump($a) {
    echo '<pre>'.print_r($a, true).'</pre>';
}
 
// assumption: no usernames/passwords set for accessing
$source = getcwd().DIRECTORY_SEPARATOR.'db.mdb';
if (($con = odbc_connect('Driver={Microsoft Access Driver (*.mdb)};Dbq='.$source, '', '', SQL_CUR_USE_ODBC)) === false) {
    die('connection failed');
}
 
// odbc_prepare will only halt on syntax error, it isn't until execution a query fails,
// for example because you refer to a a nonexistent table...
// odbc_exec both prepares and executes a query (so it's odbc_prepare() and odbc_execute() combined)
 
// for a list of tables use odbc_tables
$tables = array();
$res = odbc_tables($con);
while ($row = odbc_fetch_array($res)) {
    if ($row['TABLE_TYPE'] == 'TABLE') {
        $tables[] = $row['TABLE_NAME'];
    }
}
odbc_free_result($res);
dump($tables);
 
// for a table definition
// @see http://www.php.net/manual/en/function.odbc-columns.php comments
// cannot seem to get odbc_columns to work, or I don't understand how to use
$table = array();
$res = odbc_exec($con, 'SELECT * FROM someTable WHERE 1=2');
$n = odbc_num_fields($res); // field numbering starts at 1
for ($i=1; $i <= $n; $i++) {
    $field_name = odbc_field_name($res, $i);
    $table[$field_name] = array(
        'type'      => odbc_field_type($res, $i),
        'length'    => odbc_field_len($res, $i),
    );
}
odbc_free_result($res);
dump($table);
 
// fetch some data
$res = odbc_exec($con, 'SELECT * FROM someTable') or die(odbc_error($con));
while ($row = odbc_fetch_array($res)) {
    dump($row);
}
odbc_free_result($res);
 
odbc_close($con);
?>

<?php
echo '<pre>'.print_r(PDO::getAvailableDrivers, true).'</pre>';
?>

<?php
echo '<pre>'.print_r(PDO::getAvailableDrivers, true).'</pre>';
?>

<?php
// lees extension dir uit en print bestandsnamen
// mogelijk kun je dit gebruiken om deze libraries dynamisch te laden met dl()
// maar beter is dus om deze mee te nemen bij het opstarten
if (($dh = opendir(ini_get('extension_dir'))) !== false) {
    while (($file = readdir($dh)) !== false) {
        echo $file.'<br />';
    }
    closedir($dh);
}
?>

<?php
// lees extension dir uit en print bestandsnamen
// mogelijk kun je dit gebruiken om deze libraries dynamisch te laden met dl()
// maar beter is dus om deze mee te nemen bij het opstarten
if (($dh = opendir(ini_get('extension_dir'))) !== false) {
    while (($file = readdir($dh)) !== false) {
        echo $file.'<br />';
    }
    closedir($dh);
}
?>

try
{
    $pdo = new PDO('odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=database.mdb;Uid=eventueel_gebruikersnaam');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $myPDO = $pdo->prepare($query);
    $myPDO->execute(); 

    $result = $myPDO->fetchAll();
} catch(PDOException $e)
{
    echo $e->getMessage();
}

try
{
    $pdo = new PDO('odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=database.mdb;Uid=eventueel_gebruikersnaam');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $myPDO = $pdo->prepare($query);
    $myPDO->execute(); 
 
    $result = $myPDO->fetchAll();
} catch(PDOException $e)
{
    echo $e->getMessage();
}