Connecting to Access Database with PHP

From Hostek.com Wiki
Jump to: navigation, search

How to Connect to an Access Database with PHP

Note: This only works on our Windows servers.

  1. Create a DSN in WCP
  2. Use the following code example:
<?php
$DSN="myODBC_DSN";
$DSN_User="";
$DSN_Passwd="";
$QueryString="SELECT id, FirstName, LastName, Email FROM tblContact";
 
$Connect = odbc_connect( $DSN, $DSN_User, $DSN_Passwd );
$Result = odbc_exec( $Connect, $QueryString );
?>