PHP - Jobba med databaser

Anslut till Access-databas

Spar exempelkoden nedan i en fil med filändelsen .php

Exempelkod:

<?php
$db = 'C:\Inetpub\wwwroot\access_db\test1.mdb';

// Use phpinfo() to check your php.ini (odbc section) for proper ODBC user and password values 
$user = NULL;
$password = NULL;
$conn = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$db", $user, $password);

echo '<b>Connected to the Access database</b>'."\n"."\n";

odbc_close($conn);
?>