MSAccessDBALDriver

, _(*1)

DBAL Driver to use with Microsoft Access., _(*2)

Requiring/Loading

If you're using Composer to manage dependencies, you can include the following in your composer.json file:, _(*3)

{
    "require": {
        "royopa/ms-access-dbal-driver": "dev-master"
    }
}

Usage

<?php
header('Content-Type: text/html; charset=utf-8');

require 'vendor/autoload.php';

$dsn = 'odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=MyDatabase.mdb;';

try {
    $connPdo = new PDO($dsn);
} catch (PDOException $e) {
    echo $e->getMessage() . '</br>';
}

$config = new \Doctrine\DBAL\Configuration();
$connectionParams = array(
    'user'     => null,
    'password' => null,
    'pdo'      => $connPdo,
    'driverClass' => 'Royopa\Doctrine\DBAL\Driver\MSAccess\Driver\Driver',
);

$conn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);

$sql = 'SELECT * FROM myTable';
$stmt = $conn->query($sql);

while ($row = $stmt->fetch()) {
    echo $row['columnName'] . '</br>';
}

27/05 2015

dev-master

9999999-dev https://github.com/royopa/MSAccessDBALDriver

A DBAL driver to use with MS Access

Sources Download

MIT

The Requires

php >=5.3.0
doctrine/dbal ~2.5

The Development Requires

phpunit/phpunit 4.0.*

library ms-access-dbal-driver

A DBAL driver to use with MS Access

royopa/ms-access-dbal-driver

The README.md