View source for Connecting to Access Database with PHP

==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:
<syntaxhighlight lang="php">
<?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 );
?>
</syntaxhighlight>