Difference between revisions of "Connecting to Access Database with PHP"

From Hostek.com Wiki
Jump to: navigation, search
(Created page with "==How to Connect to an Access Database with PHP== Note: This only works on our Windows servers. #Create a DSN in WCP #Use the following code example: <pre> <?php $DSN="myODBC...")
(No difference)

Revision as of 17:21, 23 May 2013

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 );
?>
Retrieved from "https://wiki.hostek.com/index.php?title=Connecting_to_Access_Database_with_PHP&oldid=1393"