Microsoft Access using PHP PDO
Written by Saran on August 20, 2011, Updated August 4, 2014
Connect to Access database File
First we need to connect to database using ODBC, if you are not able to connect and encountered error "could not find driver", most probably you need to enable "php_pdo_odbc" extension in you PHP.ini file.
PHP
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
$db_username = ''; //username
$db_password = ''; //password
//path to database file
$database_path = "c:/db/path/database.mdb";
//check file exist before we proceed
if (!file_exists($database_path)) {
die("Access database file not found !");
}
//create a new PDO object
$database = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$database_path; Uid=$db_username; Pwd=$db_password;");SELECT Statement
Let's say we want to select all records from users table, we can simply run following query and have our records displayed on the browser.PHP
- 1
- 2
- 3
- 4
- 5
- 6
- 7
$sql = "SELECT * FROM users";
$result = $database->query($sql);
while ($row = $result->fetch()) {
echo $row["u_name"];
echo $row["u_email"];
echo $row["u_website"];
}INSERT Statement
To insert the a record, we can run following query. If successful script will display success message or anything goes wrong error will be displayed.PHP
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
$sql = "INSERT INTO users(u_name, u_email, u_website, u_message)
VALUES ('saran','[email protected]','http://www.wwebsite.com','hello how are you')";
if($database->query($sql))
{
echo 'success';
}else{
$db_err = $database->errorInfo();
echo 'Error : ('. $db_err[0] .') -- ' . $db_err[2];
}
