Self-written PDO database abstraction layer MySQL for example

Class pdo_database{
function __construct ($type _database, $host _name, $dbname, $user _role, $pass _role, $sql) {
$dbms = $type _database;
Database type Oracle with ODI, for developers, using different databases, just change this, don't remember so many functions
$host = $host _name; Database host Name
$dbName = $dbname; The database used
$user = $user _role; Database connection user Name
$pass = $pass _role; The corresponding password
$DSN = "$dbms: host= $host;d bname= $dbName";

try {
$DBH = new PDO ($DSN, $user, $pass); Initializes a PDO object, which is the creation of a database connection object $DBH
echo "Connection success <br/>";
$DBH = null;
} catch (Pdoexception $e) {
Die ("error!:". $e->getmessage (). "<br/>");
}
The default is not a long connection, if you need a long database connection, you need to add one last parameter: Array (pdo::attr_persistent = True) becomes this:
$db = new PDO ($DSN, $user, $pass, array (pdo::attr_persistent = true));
$db->setattribute (Pdo::attr_case, Pdo::case_upper); Setting properties
$db->query ("Set names UTF8");
$rs = $db->query ($sql);
$rs->setfetchmode (PDO::FETCH_ASSOC);
$result _arr = $rs->fetchall ();
Dump ($result _arr);
}
}
$pdo _mysql = new Pdo_database ("MySQL", "localhost", "Shunong", "Root", "", "SELECT * from Sn_admin");