How to connect PHP with Microsoft Access database

Question

I am currently faced with a new challenge to develop a site using Microsoft Access as the primary database instead of mysql  I have not used MS Access before and I would like guidiance on how to go about it  I have looked up the w3c website on W3schools but the code gives error     Warning  odbc connect    function odbc-connect   SQL error   Microsoft  ODBC Driver Manager  Data source name not found and no default driver specified  SQL state IM002 in SQLConnect in C  Users NNALI Desktop root test php on line 2   and this error     Warning  odbc exec   expects parameter 1 to be resource  boolean given in C  Users NNALI Desktop Breweries root test php on line 4   I am stuck and do not know what to do  I would appreciate all help on this     lt  php      conc   odbc connect  northwind                sql     Select   From customers        rs     odbc exec  conn   sql     gt    Above is the code I used

User · Answer

The problem is a simple typo  You named your variable  conc  on line 2 but then referenced  conn  on line 4

User · Answer

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    lt  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- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION     sql             SELECT AgentName FROM Agents              WHERE ID  lt    AND AgentName  lt  gt       sth    dbh- gt prepare  sql       query parameter value s   params   array          5           Homer               sth- gt execute  params    while   row    sth- gt 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

User · Answer

Are you sure the odbc connector is well created   if not check the step  Create an ODBC Connection  again   EDIT  Connection without DSN from php net     Microsoft Access   connection   odbc connect  Driver  Microsoft Access Driver    mdb   Dbq  mdbFilename    user   password     in your case it might be if your filename is northwind and your file extension mdb    connection   odbc connect  Driver  Microsoft Access Driver    mdb   Dbq northwind

User · Answer

lt  php      dbName     SERVER  DOCUMENT ROOT      products products mdb       if   file exists  dbName            die  Could not find database file                db   new PDO  odbc DRIVER  Microsoft Access Driver    mdb    DBQ  dbName  Uid   Pwd        A successful connection will allow SQL commands to be executed from PHP to read or write the database  If  however  you get the error message    PDOException Could not find driver    then it   s likely that the PDO ODBC driver is not installed  Use the phpinfo   function to check your installation for references to PDO   If an entry for PDO ODBC is not present  you will need to ensure your installation includes the PDO extension and ODBC drivers  To do so on Windows  uncomment the line extension php pdo odbc dll in php ini  restart Apache  and then try to connect to the database again   With the driver installed  the output from phpinfo   should include information like this https   www diigo com item image 5kc39 hdse

User · Answer

If you are struggling with the connection in the XAMPP environment I suggest uncommenting the following entry in the php ini file   extension   odbc  I received an error without it  Uncaught pdoexception  could not find driver

User · Answer

If you need to install then refer to   https   www microsoft com en-us download details aspx id 54920

[php] How to connect PHP with Microsoft Access database

Examples related to php

Examples related to ms-access

Examples related to odbc