function __construct($table) { $class = get_class($this); print_r(strToLower($class)); echo "\n"; parent::__construct($table); }
function __construct() { parent::__construct(); $this->selectStmt = self::$db_handler->prepare('SELECT * FROM health_goal WHERE uid=?'); $this->updateStmt = self::$db_handler->prepare('UPDATE health_goal SET walk=?, upper_limb=?, lower_limb=? WHERE uid=?'); $this->insertStmt = self::$db_handler->prepare('INSERT INTO health_goal ( walk, upper_limb, lower_limb ) VALUES( ?, ?, ? )'); }
public function __construct() { parent::__construct(); $this->selectStmt = self::$db_handler->prepare('SELECT * FROM setting WHERE uid=?'); $this->updateStmt = self::$db_handler->prepare('UPDATE setting SET weight=?, heart_rate=?, slumber=?, walk=?, upper_limb=?, lower_limb=?, send_campaign=?, sync_time=? WHERE uid=?'); $this->insertStmt = self::$db_handler->prepare('INSERT INTO setting ( uid ) VALUES( ? )'); }
function __construct() { parent::__construct(); $this->selectStmt = self::$db_handler->prepare('SELECT * FROM user WHERE uname=?'); $this->updateStmt = self::$db_handler->prepare('UPDATE user SET uname=?, gender=?, email=?, age=?, location=? WHERE uid=?'); $this->insertStmt = self::$db_handler->prepare('INSERT INTO user ( uname, email, password ) VALUES( ?, ?, ? )'); }
function __construct() { parent::__construct(); $this->selectStmt = self::$PDO->prepare("SELECT * FROM venue WHERE id=?"); $this->updateStmt = self::$PDO->prepare("update venue set name=?, id=? where id=?"); $this->insertStmt = self::$PDO->prepare("insert into venue ( name ) \n values( ? )"); }
public function __construct() { parent::__construct(); $this->selectStmt = self::$db_handler->prepare('SELECT * FROM role WHERE rid=?'); $this->updateStmt = self::$db_handler->prepare('UPDATE role SET role=?, role_des=? WHERE rid=?'); $this->insertStmt = self::$db_handler->prepare('INSERT INTO role ( role, role_des ) VALUES( ?, ? )'); }
/** * ActivityMapper constructor. */ public function __construct() { parent::__construct(); $this->selectAll = self::$db_handler->prepare('SELECT title, content FROM activity'); $this->selectStmt = self::$db_handler->prepare('SELECT * FROM activity WHERE acid=?'); $this->updateStmt = self::$db_handler->prepare('UPDATE activity SET title=?, content=?, a_img_url=?, enter_amount=?, end_time=? WHERE acid=?'); $this->insertStmt = self::$db_handler->prepare('INSERT INTO activity ( title, content, post_time, end_time ) VALUES( ?, ?, ?, ? )'); }
function __construct() { parent::__construct(); $this->selectStmt = self::$db_handler->prepare('SELECT * FROM plan WHERE uid=?'); $this->updateStmt = self::$db_handler->prepare('UPDATE plan SET breakfast=?, lunch=?, dinner=?, exercise=? WHERE uid=? AND pid=?'); $this->insertStmt = self::$db_handler->prepare('INSERT INTO plan ( pid, uid ) VALUES( ?, ? )'); $this->countStmt = self::$db_handler->prepare('SELECT count(*) ' . self::COUNT . ' FROM plan WHERE uid=?'); }
/** * PostMapper constructor. */ public function __construct() { parent::__construct(); $this->selectAll = self::$db_handler->prepare('SELECT * FROM post ORDER BY post_id'); $this->selectStmt = self::$db_handler->prepare('SELECT * FROM post WHERE post_id=?'); $this->updateStmt = self::$db_handler->prepare('UPDATE post SET content=? WHERE post_id=?'); $this->insertStmt = self::$db_handler->prepare('INSERT INTO post (content, post_time) VALUES(?, ? )'); }
function __construct() { parent::__construct(); $this->selectAllStmt = self::$PDO->prepare("SELECT * FROM venue"); $this->selectStmt = self::$PDO->prepare("SELECT * FROM venue WHERE id=?"); $this->updateStmt = self::$PDO->prepare("UPDATE venue SET name=?, id=? WHERE id=?"); $this->insertStmt = self::$PDO->prepare("INSERT into venue ( name ) \n values( ? )"); }
/** * AdviceMapper constructor. */ public function __construct() { parent::__construct(); $this->selectUser = self::$db_handler->prepare('SELECT a.vote, a.content, q.title, q.qid FROM advice a JOIN question q ON a.qid = q.qid WHERE ans_user=?'); $this->selectStmt = self::$db_handler->prepare('SELECT a.*, u.uname FROM advice a JOIN user u on a.ans_user = u.uid WHERE qid=?'); $this->updateStmt = self::$db_handler->prepare('UPDATE advice SET content=? WHERE qid=?'); $this->insertStmt = self::$db_handler->prepare('INSERT INTO advice ( qid, content, ans_user, time ) VALUES( ?, ?, ?, ? )'); }
function __construct() { parent::__construct(); $this->selectAllStmt = self::$PDO->prepare("SELECT * FROM space"); $this->selectStmt = self::$PDO->prepare("SELECT * FROM space WHERE id=?"); $this->updateStmt = self::$PDO->prepare("UPDATE space SET name=?, id=? WHERE id=?"); $this->insertStmt = self::$PDO->prepare("INSERT into space ( name, venue ) \n values( ?, ?)"); $this->findByVenueStmt = self::$PDO->prepare("SELECT * FROM space where venue=?"); }
function __construct(PDO $pdo) { parent::__construct($pdo); $this->selectStmt = $this->PDO->prepare("SELECT * FROM usergroups WHERE id=?"); $this->selectAllStmt = $this->PDO->prepare("SELECT id, title FROM usergroups"); $this->insertStmt = $this->PDO->prepare("INSERT INTO usergroups (title, color) VALUES (?,?)"); $this->updateStmt = $this->PDO->prepare("UPDATE usergroups SET title=?, color=? WHERE id=?"); $this->deleteStmt = $this->PDO->prepare("DELETE FROM usergroups WHERE id=?"); }
function __construct() { parent::__construct(); $this->selectAllStmt = self::$PDO->prepare("SELECT * FROM event"); $this->selectBySpaceStmt = self::$PDO->prepare("SELECT * FROM event where space=?"); $this->selectStmt = self::$PDO->prepare("SELECT * FROM event WHERE id=?"); $this->updateStmt = self::$PDO->prepare("UPDATE event SET start=?, duration=?, name=?, id=? WHERE id=?"); $this->insertStmt = self::$PDO->prepare("INSERT into event (start, duration, space, name) \n values( ?, ?, ?, ?)"); }
/** * QuestionMapper constructor. */ public function __construct() { parent::__construct(); $this->selectUser = self::$db_handler->prepare('SELECT title, content, vote, qid FROM question WHERE uid=?'); $this->selectStmt = self::$db_handler->prepare('SELECT u.uname, q.type, q.to_user, q.title, q.content, q.time, q.vote FROM question q JOIN user u ON q.uid = u.uid WHERE qid=?'); $this->updateStmt = self::$db_handler->prepare('UPDATE question SET title=?, content=?, vote=? WHERE qid=?'); $this->insertStmt = self::$db_handler->prepare('INSERT INTO question ( uid, type, to_user, title, content, time) VALUES( ?, ?, ?, ?, ?, ? )'); $this->selectAll = self::$db_handler->prepare('SELECT * FROM question'); }
function __construct() { parent::__construct(); global $url; $this->id = $url->getIdFirstPart(); if (func_num_args() == 1 && is_object(func_get_arg(0))) { $object_ = func_get_arg(0); $this->foreignTable = $object_; } }
function __construct($pdo) { parent::__construct($pdo); $this->selectCount = $this->PDO->prepare("SELECT COUNT(id) AS count FROM news"); $this->selectStmt = $this->PDO->prepare("SELECT * FROM news WHERE id=?"); $this->selectCollectionStmt = $this->PDO->prepare("SELECT id, title, date, type FROM news ORDER BY date DESC LIMIT ?, ?"); $this->selectAllStmt = $this->PDO->prepare("SELECT * FROM news"); $this->insertStmt = $this->PDO->prepare("INSERT INTO news (title, text, full_text, date, author, view, type) VALUES (?,?,?,?,?,?,?)"); $this->updateStmt = $this->PDO->prepare("UPDATE news SET title=?, text=?, full_text=?, date=?, author=?, view=?, type=? WHERE id=?"); $this->deleteStmt = $this->PDO->prepare("DELETE FROM news WHERE id=?"); }
function __construct($pdo) { parent::__construct($pdo); $this->selectCount = $this->PDO->prepare("SELECT COUNT(id) AS count FROM categories"); $this->selectStmt = $this->PDO->prepare("SELECT * FROM categories WHERE id=?"); $this->selectCollectionStmt = $this->PDO->prepare("SELECT id, title, meta_d, meta_k FROM categories LIMIT ?, ?"); $this->selectAllStmt = $this->PDO->prepare("SELECT id, title FROM categories"); $this->insertStmt = $this->PDO->prepare("INSERT INTO categories (title, text, meta_d, meta_k) VALUES (?,?,?,?)"); $this->updateStmt = $this->PDO->prepare("UPDATE categories SET title=?, text=?, meta_d=?, meta_k=? WHERE id=?"); $this->deleteStmt = $this->PDO->prepare("DELETE FROM categories WHERE id=?"); }
function __construct(PDO $pdo) { parent::__construct($pdo); $this->selectCount = $this->PDO->prepare("SELECT COUNT(id) AS count FROM settings"); $this->selectStmt = $this->PDO->prepare("SELECT * FROM settings WHERE id=?"); $this->selectCollectionStmt = $this->PDO->prepare("SELECT id, page, title, meta_d FROM settings LIMIT ?, ?"); $this->selectAllStmt = $this->PDO->prepare("SELECT * FROM settings"); $this->insertStmt = $this->PDO->prepare("INSERT INTO settings (page, title, meta_d, meta_k) VALUES (?,?,?,?)"); $this->updateStmt = $this->PDO->prepare("UPDATE settings SET page=?, title=?, meta_d=?, meta_k=? WHERE id=?"); $this->deleteStmt = $this->PDO->prepare("DELETE FROM settings WHERE id=?"); }
function __construct($pdo) { parent::__construct($pdo); $this->selectCount = $this->PDO->prepare("SELECT COUNT(id) AS count FROM data"); $this->selectStmt = $this->PDO->prepare("SELECT * FROM data WHERE id=?"); $this->selectCollectionStmt = $this->PDO->prepare("SELECT id, cat, title, meta_d FROM data LIMIT ?, ?"); $this->selectAllStmt = $this->PDO->prepare("SELECT * FROM data LIMIT"); $this->insertStmt = $this->PDO->prepare("INSERT INTO data (title, text, cat, meta_d, meta_k, description, view, author, date) VALUES (?,?,?,?,?,?,?,?,?)"); $this->updateStmt = $this->PDO->prepare("UPDATE data SET title=?, text=?, cat=?, meta_d=?, meta_k=?, description=?, view=?, author=?, date=? WHERE id=?"); $this->deleteStmt = $this->PDO->prepare("DELETE FROM data WHERE id=?"); }
/** * MySQL driver constructor * * @param array $settings * @param array $classmap */ public function __construct($settings, array $classmap = []) { // localhost if (!is_array($settings)) { $settings = ['host' => 'localhost', 'username' => 'root', 'password' => '', 'dbname' => $settings]; } // create pdo instance $connector = 'mysql:host=' . $settings['host'] . ';dbname=' . $settings['dbname']; $pdo = new \PDO($connector, $settings['username'], $settings['password']); parent::__construct($pdo, $classmap); }
function __construct(PDO $pdo) { parent::__construct($pdo); $this->selectCount = $this->PDO->prepare("SELECT COUNT(id) AS count FROM users"); $this->selectStmt = $this->PDO->prepare("SELECT * FROM users WHERE id=?"); $this->selectCollectionStmt = $this->PDO->prepare("SELECT id, login, name, fam, email, access, regDate FROM users LIMIT ?, ?"); $this->selectAllStmt = $this->PDO->prepare("SELECT id, login FROM users WHERE access=1"); $this->insertStmt = $this->PDO->prepare("INSERT INTO users (login, password, email, access, name, fam, pol, regDate, birthDate, avatar, activation) VALUES (?,?,?,?,?,?,?,?,?,?,?)"); $this->updateStmt = $this->PDO->prepare("UPDATE users SET login=?, password=?, email=?, access=?, name=?, fam=?, pol=?, regDate=?, birthDate=?, avatar=?, activation=? WHERE id=?"); $this->deleteStmt = $this->PDO->prepare("DELETE FROM users WHERE id=?"); }
function __construct(PDO $pdo) { parent::__construct($pdo); $this->selectCount = $this->PDO->prepare("SELECT COUNT(id) as count FROM sostav"); $this->selectStmt = $this->PDO->prepare("SELECT * FROM sostav WHERE id=?"); $this->selectCollectionStmt = $this->PDO->prepare("SELECT id, name, scores, rang FROM sostav ORDER BY scores DESC LIMIT ?, ?"); $this->selectAllStmt = $this->PDO->prepare("SELECT * FROM sostav"); $this->insertStmt = $this->PDO->prepare("INSERT INTO sostav (name, scores, rang, dol, fullName, skype) VALUES (?,?,?,?,?,?)"); $this->updateStmt = $this->PDO->prepare("UPDATE sostav SET name=?, scores=?, rang=?, dol=?, fullName=?, skype=? WHERE id=?"); $this->deleteStmt = $this->PDO->prepare("DELETE FROM sostav WHERE id=?"); }
public function __construct($user = null) { parent::__construct("users"); $this->_salt = config::get('encryption/salt'); $this->_sessionName = config::get('session/session_name'); $this->_cookieName = config::get('cookie/name'); if (!$user) { if (Session::exist($this->_sessionName)) { $user = Session::get($this->_sessionName); if ($this->find(['id', '=', $user])) { $this->_isLoggedIn = true; } } } else { $this->find(['id', '=', $user]); } }
/** * Instantiate class * @param $db \DB\Mongo * @param $table string * @param $onsuspect callback * @param $key string **/ function __construct(\DB\Mongo $db, $table = 'sessions', $onsuspect = NULL, $key = NULL) { parent::__construct($db, $table); $this->onsuspect = $onsuspect; session_set_save_handler(array($this, 'open'), array($this, 'close'), array($this, 'read'), array($this, 'write'), array($this, 'destroy'), array($this, 'cleanup')); register_shutdown_function('session_commit'); $fw = \Base::instance(); $headers = $fw->get('HEADERS'); $this->_csrf = $fw->hash($fw->get('ROOT') . $fw->get('BASE')) . '.' . $fw->hash(mt_rand()); if ($key) { $fw->set($key, $this->_csrf); } $this->_agent = isset($headers['User-Agent']) ? $headers['User-Agent'] : ''; $this->_ip = $fw->get('IP'); }
public function __construct(\Erfurt_Store $store, $url, $vocabulary) { parent::__construct($store, $url, $vocabulary); }
function __construct() { parent::__construct(); }
/** * Instantiate class * @param $db object * @param $table string * @param $force bool * @param $onsuspect callback **/ function __construct(\DB\SQL $db, $table = 'sessions', $force = TRUE, $onsuspect = NULL) { if ($force) { $eol = "\n"; $tab = "\t"; $db->exec((preg_match('/mssql|sqlsrv|sybase/', $db->driver()) ? 'IF NOT EXISTS (SELECT * FROM sysobjects WHERE ' . 'name=' . $db->quote($table) . ' AND xtype=\'U\') ' . 'CREATE TABLE dbo.' : 'CREATE TABLE IF NOT EXISTS ' . (($name = $db->name()) && $db->driver() != 'pgsql' ? $name . '.' : '')) . $table . ' (' . $eol . $tab . $db->quotekey('session_id') . ' VARCHAR(40),' . $eol . $tab . $db->quotekey('data') . ' TEXT,' . $eol . $tab . $db->quotekey('csrf') . ' TEXT,' . $eol . $tab . $db->quotekey('ip') . ' VARCHAR(40),' . $eol . $tab . $db->quotekey('agent') . ' VARCHAR(255),' . $eol . $tab . $db->quotekey('stamp') . ' INTEGER,' . $eol . $tab . 'PRIMARY KEY (' . $db->quotekey('session_id') . ')' . $eol . ');'); } parent::__construct($db, $table); session_set_save_handler(array($this, 'open'), array($this, 'close'), array($this, 'read'), array($this, 'write'), array($this, 'destroy'), array($this, 'cleanup')); register_shutdown_function('session_commit'); @session_start(); $fw = \Base::instance(); $headers = $fw->get('HEADERS'); if (($ip = $this->ip()) && $ip != $fw->get('IP') || ($agent = $this->agent()) && (!isset($headers['User-Agent']) || $agent != $headers['User-Agent'])) { if (isset($onsuspect)) { $fw->call($onsuspect, array($this)); } else { session_destroy(); $fw->error(403); } } $csrf = $fw->hash($fw->get('ROOT') . $fw->get('BASE')) . '.' . $fw->hash(mt_rand()); if ($this->load(array('session_id=?', $this->sid = session_id()))) { $this->set('csrf', $csrf); $this->save(); } }
/** * Instantiate class * @param $db object * @param $table string **/ function __construct(\DB\Jig $db, $table = 'sessions') { parent::__construct($db, 'sessions'); session_set_save_handler(array($this, 'open'), array($this, 'close'), array($this, 'read'), array($this, 'write'), array($this, 'destroy'), array($this, 'cleanup')); register_shutdown_function('session_commit'); }
/** * Instantiate class * @param $db object * @param $table string **/ function __construct(\DB\Jig $db, $table = 'sessions') { parent::__construct($db, 'sessions'); session_set_save_handler(array($this, 'open'), array($this, 'close'), array($this, 'read'), array($this, 'write'), array($this, 'destroy'), array($this, 'cleanup')); register_shutdown_function('session_commit'); @session_start(); $fw = \Base::instance(); $headers = $fw->get('HEADERS'); if (($ip = $this->ip()) && $ip != $fw->get('IP') || ($agent = $this->agent()) && (!isset($headers['User-Agent']) || $agent != $headers['User-Agent'])) { session_destroy(); $fw->error(403); } $csrf = $fw->hash($fw->get('ROOT') . $fw->get('BASE')) . '.' . $fw->hash(mt_rand()); if ($this->load(array('@session_id=?', $this->sid = session_id()))) { $this->set('csrf', $csrf); $this->save(); } }