How to connect PHP with Microsoft Access database

by

If you are just getting started with a new project then I would suggest that you use PDO instead of the old odbc_exec() approach. Here is a simple example:

<?php
$bits = 8 * PHP_INT_SIZE;
echo "(Info: This script is running as $bits-bit.)\r\n\r\n";

$connStr="odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};" .
        'Dbq=C:\\Users\\Gord\\Desktop\\foo.accdb;';

$dbh = new PDO($connStr);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$sql = 
        "SELECT AgentName FROM Agents " .
        "WHERE ID < ? AND AgentName <> ?";
$sth = $dbh->prepare($sql);

// query parameter value(s)
$params = array(
        5,
        'Homer'
        );

$sth->execute($params);

while ($row = $sth->fetch()) {
    echo $row['AgentName'] . "\r\n";
}

NOTE: The above approach is sufficient if you do not need to support Unicode characters above U+00FF. If you do need to support such characters then neither PDO_ODBC nor the old odbc_ functions will work; you’ll need to use the solution described in this answer.

More Related Contents:

  1. Unable to retrieve UTF-8 accented characters from Access via PDO_ODBC
  2. PHP and Microsoft Access database – Connection and CRUD
  3. Connect PHP to MSSQL via PDO ODBC
  4. CodeIgniter MSSQL connection
  5. Linux – PHP 7.0 and MSSQL (Microsoft SQL)
  6. ODBC prepared statements in PHP
  7. Call to undefined function odbc_connect() message while connecting SAP HANA database
  8. Needle in a Haystack for Php [closed]
  9. Multiple inputs with same name through POST in php
  10. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  11. Is there a PDF parser for PHP? [closed]
  12. How to set proper codeigniter base url?
  13. String with array structure to Array [duplicate]
  14. How to run php files on my computer
  15. Select entries between dates in doctrine 2
  16. Auto increment in phpmyadmin
  17. Parsing CSS by regex
  18. PHP string interpolation syntax
  19. Merge XML files in PHP
  20. Mysqli fetch_assoc vs fetch_array
  21. How to Paginate lines in a foreach loop with PHP
  22. String comparison using ‘==’ or ‘===’ vs. ‘strcmp()’
  23. Turn off warnings and errors on PHP and MySQL
  24. PHP SimpleXML Namespace Problem
  25. HTML Form POST to PHP page [closed]
  26. How can I change php-cli version on Ubuntu 14.04?
  27. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  28. PHP script to execute at certain times
  29. Large hex values with PHP hexdec
  30. ZF2 – Get controller name into layout/views

Leave a Comment