- PDO allows you to work with different databases, such as: MYSQL, Oracle, PostgreSQL and many others.
- PDO allows you to work with a prepared statement
Connecting to a Database Using PDO
xxxxxxxxxx
/ / MuSQL
$Database = new PDO ("mysql: host = $ host; dbname = $Databasename", $username, $password);
/ / PostgreSQL
$Database = new PDO ("pgsql: host = $ host; dbname = $Databasename", $username, $password);
/ / MS SQL
$Database = new PDO ("mssql: host = $ host; dbname = $Databasename", $username, $password);
/ / SQLite
$Database = new PDO ("sqlite: my / database / path / database.db");
xxxxxxxxxx
try {
$Database = new PDO ("mysql: host = $ host; dbname = $Databasename", $username, $password);
}
catch (PDOException $ e) {
echo "Unable to connect to database";
}