renankof/ms-access-dbal-driver-new

A DBAL driver to use with MS Access

dev-master 2024-10-05 19:46 UTC

Requires

• php: >=8.3.0
• doctrine/dbal: ~4

Requires (Dev)

• phpunit/phpunit: 4.0.*

MIT

• Rodrigo Prado de Jesus
• Renan Burda

README

DBAL Driver to use with Microsoft Access.

Requiring/Loading

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

{
    "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>';
}