<?php
class sql
{
public static $db = false;
private $database_host = '127.0.0.1';
private $database_user = 'all';
private $database_pass = 'all';
private $database_db = 'test';
private $database_type= "mysql";
function __construct()
{
if (self::$db === false) {
$this->connect();
}
}
private function connect()
{
$dsn = $this->database_type . ":dbname=" . $this->database_db . ";host=" . $this->database_host;
try {
self::$db = new PDO($dsn, $this->database_user, $this->database_pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''));
self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
// aquí va tu gestión de errores
exit("error");
}
}
}
SELECT
}
UPDATE
INSERT