protected static function dbInstance()
{
if (NULL == self::$instance) {
self::$instance = new self();
}
return self::$instance;
}
public static function instance()
{
if (self::$instance == NULL) {
self::$instance = new db();
}
return self::$instance->db;
}
public static function get_instance()
{
if (is_null(db::$instance)) {
db::$instance = new db();
}
return db::$instance;
}
public static function getInstance()
{
if (self::$instance === null) {
self::$instance = new self();
}
return self::$instance;
}
public static function getInstance()
{
if (!self::$instance instanceof self) {
self::$instance = new self();
}
return self::$instance;
}
public static function getInstance()
{
if (!isset(self::$instance)) {
self::$instance = new db();
}
return self::$instance;
}
public static function init()
{
if (self::$instance === null) {
self::$instance = new db(DB_CONN, DB_USER, DB_PASS);
}
return self::$instance;
}
static function GetInstance()
{
if (self::$instance == null) {
self::$instance = new db();
}
return self::$instance;
}
public static function singleton($server = null, $username = null, $password = null, $schema = null) {
if (!isset(self::$instance)) {
$c = __CLASS__;
self::$instance = new $c($server, $username, $password, $schema);
}
return self::$instance;
}
/**
* Funcion que usaremos para crear la instancia necesaria para usar la base de datos desde el modelo
*/
public static function getInstance()
{
if (!self::$instance) {
//Si no existiera una instancia la crea
self::$instance = new self();
}
return self::$instance;
}
/**
*
* Return DB instance or create intitial connection
*
* @return object (PDO)
*
* @access public
*
*/
public static function getInstance()
{
if (!self::$instance) {
self::$instance = new PDO("mysql:host=localhost;dbname=exiastore", 'root', '');
self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
return self::$instance;
}
public static function getInstance()
{
if (!self::$instance) {
self::$instance = new PDO("mysql:host=localhost;dbname=periodic_table", 'username', 'password');
self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
return self::$instance;
}
/**
*
* Return DB instance or create intitial connection
*
* @return object (PDO)
*
* @access public
*
*/
public static function getInstance()
{
if (!self::$instance) {
self::$instance = new PDO("mysql:host=localhost;dbname=stoneci2_menuBoard", 'stoneci2_menu', '_P@55word');
self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
return self::$instance;
}
public static function instance()
{
if (!isset(self::$instance)) {
$classname = __CLASS__;
self::$instance = new $classname();
}
return self::$instance;
}
/**
* Return DB instance or create intitial connection
* @return object (PDO)
* @access public
*/
public static function getInstance()
{
if (!self::$instance) {
self::$instance = new PDO('mysql:host=localhost;dbname=' . DB_NAME, DB_USER_NAME, DB_USER_PASS);
self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
self::$instance->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
}
return self::$instance;
}
public static function getInstance()
{
if (!self::$instance) {
require 'config.inc.php';
self::$instance = new PDO('mysql:host=' . $mysql_server . ';dbname=' . $mysql_db, $mysql_user, $mysql_pass);
self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
return self::$instance;
}
public static function instance()
{
if (!self::$initialized) {
throw new Exception('O banco de dados ainda não foi inicializado');
}
if (!isset(self::$instance)) {
self::$instance = new self(self::$default_host, self::$default_schema, self::$default_user, self::$default_pass);
}
return self::$instance;
}
public static function findbykey($key)
{
$pdo = db::instance();
$query = "SELECT `id` FROM `consumer` WHERE `consumer_key`='{$key}'";
$result = $pdo->query($query);
if ($result->rowCount() == 1) {
$result = $result->fetch();
return new consumer($result['id']);
}
return FALSE;
}
static function getInstance()
{
if (is_null(db::$instance)) {
if (file_exists(PATH_CORE . '/include/db/' . DATABASE_TYPE . '.php')) {
require_once PATH_CORE . '/include/db/' . DATABASE_TYPE . '.php';
$class = 'DB' . DATABASE_TYPE;
db::$instance = new $class();
}
}
return db::$instance;
}
static function getInstance()
{
if (is_null(db::$instance)) {
if (file_exists('include/class/db/' . DATABASE_TYPE . '.php')) {
require_once 'include/class/db/' . DATABASE_TYPE . '.php';
$class = 'db_' . DATABASE_TYPE;
db::$instance = new $class();
}
}
return db::$instance;
}
public static function findbytoken($token)
{
$pdo = db::instance();
$query = "SELECT `id` FROM `token` WHERE `token`='{$token}'";
$result = $pdo->query($query);
if ($result->rowCount() == 1) {
$result = $result->fetch();
return new token($result['id']);
}
return FALSE;
}
public static function getInstance()
{
$s_host = 'localhost';
$s_db = 'sample-core-app';
$s_user = '******';
$s_pass = '******';
if (!self::$instance) {
self::$instance = new PDO("mysql:host={$s_host};dbname={$s_db}", $s_user, $s_pass);
self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
return self::$instance;
}
/**
* Get instance of PDO object
* @return PDO
*/
private static function get()
{
if (!self::$instance instanceof PDO) {
try {
$options = [PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING, PDO::ATTR_AUTOCOMMIT => true, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC];
self::$instance = new PDO(Config::$dbDriver . ':host=' . Config::$dbHost . ';dbname=' . Config::$dbName . ';charset=' . Config::$dbCharset, Config::$dbUsername, Config::$dbPassword, $options);
} catch (PDOException $pe) {
Config::crash(self::getTextError($pe));
}
}
return self::$instance;
}
public static function findbyusername($username, $password)
{
$pdo = db::instance();
$password = md5($password);
$query = "SELECT `id` FROM `user` WHERE `user_name`='{$username}' AND `password`='{$password}'";
$result = $pdo->query($query);
if ($result->rowCount() == 1) {
$result = $result->fetch();
return new user($result[`id`]);
}
return FALSE;
}
/**
* Return DB instance or create intitial connection
* @return object (PDO)
* @access public
*/
public static function getDB($param = null)
{
if (!is_null($param)) {
self::$instance = null;
}
if (!self::$instance) {
$password = array_key_exists('password', $param) ? $param['password'] : "";
$username = array_key_exists('username', $param) ? $param['username'] : "";
self::$instance = new PDO(self::getConnString($param), $username, $password);
self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
return self::$instance;
}
public static function getInstance()
{
if (!self::$instance) {
self::$instance = new PDO("mysql:host=myhost;dbname=mydbname", 'myname', 'mypass');
self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$movie_sql = "CREATE TABLE IF NOT EXISTS \r\n movie(\r\n id int(11) NOT NULL AUTO_INCREMENT,\r\n title varchar(100) NOT NULL,\r\n year int(11) NOT NULL,\r\r\n PRIMARY KEY(id)\r\r\n ) ENGINE=InnoDB;";
$actor_sql = "CREATE TABLE IF NOT EXISTS \r\r\n actor(\r\r\n id int(11) NOT NULL AUTO_INCREMENT,\r\r\n movieid int(11) NOT NULL,\r\r\n name varchar(100) NOT NULL,\r\r\n surname varchar(100) NOT NULL,\r\r\n PRIMARY KEY(id),\r\r\n FOREIGN KEY (movieid) REFERENCES movie(id)\r\r\n ON UPDATE CASCADE\r\r\n ON DELETE CASCADE \r\r\n ) ENGINE=InnoDB;";
$movie_type_sql = "CREATE TABLE IF NOT EXISTS \r\r\n movie_format(\r\r\n id int(11) NOT NULL AUTO_INCREMENT,\r\r\n movieid int(11) NOT NULL,\r\r\n format varchar(100) NOT NULL,\r\r\n PRIMARY KEY(id),\r\r\n FOREIGN KEY (movieid) REFERENCES movie(id)\r\r\n ON UPDATE CASCADE\r\r\n ON DELETE CASCADE\r\r\n ) ENGINE=InnoDB;";
$user_sql = "CREATE TABLE IF NOT EXISTS \r\r\n user(\r\r\n id int(11) NOT NULL AUTO_INCREMENT,\r\r\n username varchar(100) NOT NULL,\r\r\n password varchar(255) NOT NULL,\r\r\n email varchar(100) NOT NULL,\r\r\n token varchar(255) NOT NULL,\r\r\n token_expire DATETIME NOT NULL,\r\r\n PRIMARY KEY(id)\r\r\n ) ENGINE=InnoDB;";
self::$instance->exec($movie_sql);
self::$instance->exec($actor_sql);
self::$instance->exec($movie_type_sql);
self::$instance->exec($user_sql);
}
return self::$instance;
}
static function connect()
{
$stuff = the::app();
if (count($stuff->connections) != 0) {
foreach ($stuff->connections as $host => $credentials) {
if (preg_match("|" . $host . "|", $stuff->uri_string)) {
$link = mysql_connect($credentials[0], $credentials[2], $credentials[3]);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db($credentials[1]);
}
}
}
if (!self::$instance) {
self::$instance = new db();
}
return self::$instance;
}
function clearDB()
{
// очищает базу данных
$db = db::instance();
$db->query("delete from `advertisement`");
$this->ads = array();
return self::$instance;
}
public static function init()
{
// {{{
return self::$instance = new self();
}
protected function _getPdoServerWithAlias($alias, $type = self::db_type_slave)
{
$dataDriver = db::instance($alias, $type);
return $dataDriver;
}
