PDO: подключение к разным СУБД

1
// for MySQL
2
$conn = new PDO("mysql:host=$host;dbname=$db", $user, $pass);
3

4
// for SQLite
5
$conn = new PDO("sqlite:$db");
6

7
// for postgreSQL
8
$conn = new PDO("pgsql:host=$host dbname=$db", $user, $pass);

1
<?php
2
// configuration
3
$dbtype    = "sqlite";
4
$dbhost   = "localhost";
5
$dbname    = "test";
6
$dbuser    = "root";
7
$dbpass    = "admin";
8
$dbpath    = "c:/test.db";
9

10
// switching
11
switch($dbtype){
12
  case "mysql":
13
    $dbconn = "mysql:host=$dbhost;dbname=$dbname";
14
    break;
15

16
  case "sqlite":
17
    $dbconn = "sqlite:$dbpath";
18
  break;
19

20
  case "postgresql":
21
    $dbconn = "pgsql:host=$host dbname=$db";
22
  break;
23
}
24

25
// database connection
26
$conn = new PDO($dbconn,$user,$pass);
27

28
?>