Example #1
0
     */
    public static function setDetails($host, $dbname, $username, $password)
    {
        self::$host = $host;
        self::$dbname = $dbname;
        self::$username = $username;
        self::$password = $password;
    }
    /**
     * Get the database singleton
     * @return The one PDO instance
     */
    public static function getDB()
    {
        if (self::$db == null) {
            self::$db = new PDO('mysql:host=' . self::$host . ';dbname=' . self::$dbname, self::$username, self::$password);
            self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        }
        return self::$db;
    }
    /**
     * Format a date for use in database WHERE clauses
     */
    public static function date($time)
    {
        return date('Y-m-d H:i:s', $time);
    }
}
// Set details based on config
Database::setDetails(Config::$database['host'], Config::$database['name'], Config::$database['username'], Config::$database['password']);