PHP, SQL and Access Database

PHP
1

I am very new to php and have been asked to link a webpage to microsoft access database. I would like to know if i need to use SQL to link to access or not?

2

Hi

Yes you will, this link explains it:

$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=;");
3