protected static function getAllOnID($table, $id) { $select = new Select(self::$db); $select->from($table, "*")->where("`id` = ?", array($id)); $data = self::$db->select($select); return $data; }
public function loadRandom() { $select = new Select(self::$db); $select->from(self::$table, "*")->where("`state` =" . self::$db->getSQ(), array(1))->rand()->limit(1); $row = self::$db->selectRow($select); return $this->init($row); }
public function loadRandom() { $select = new Select(self::$db); $select->from(self::$table, "*")->rand()->limit(1); $row = self::$db->selectRow($select); return $this->init($row); }
public static function getImgOnID($id) { $select = new Select(self::$db); $select->from(self::$table, "*")->where("`product_id` = " . self::$db->getSQ(), array($id)); $data = self::$db->select($select); $images = ObjectDB::buildMultiple(__CLASS__, $data); return $images; }
public static function getStudentsOnGroupID($group_id) { $select = new Select(self::$db); $select->from(self::$table, "*")->where("`group_id` = ?", array($group_id)); $data = self::$db->select($select); $students = ObjectDB::buildMultiple(__CLASS__, $data); //foreach ($groups as $g) $g->postHandling(); return $students; }
public static function getItems() { $select = new Select(self::$db); $select->from(self::$table, array("s.*", "p.img"), "s")->join("INNER", "product", "p", "s.product_id = p.id"); $data = self::$db->select($select); $slider = ObjectDB::buildMultiple(__CLASS__, $data); foreach ($slider as $slide) { $slide->postHandling(); } return $slider; }
public static function getItemsOnView($view) { $select = new Select(self::$db); $select->from(self::$table, "*")->where("`view_id` = ?", array($view)); $data = self::$db->select($select); $items = ObjectDB::buildMultiple(__CLASS__, $data); foreach ($items as $item) { $item->postHandling(); } return $items; }
public static function getGroupsOnTeacherID($id) { $select = new Select(self::$db); $select->from(self::$table, "*")->where("`teacher_id` = ?", array($id)); $data = self::$db->select($select); $groups = ObjectDB::buildMultiple(__CLASS__, $data); foreach ($groups as $g) { $g->postHandling(); } return $groups; }
public static function getIdonNumder($number) { $select = new Select(self::$db); $select->from(self::$table, array("id"))->where("`number` = ?", array($number)); $id = self::$db->selectCell($select); if (!$id) { $select = new Select(self::$db); $select->from(self::$table, array("id"))->where("`parent_number` = ?", array($number)); $id = self::$db->selectCell($select); } return $id; }
public function loadOnSectionID($section_id, $type) { $select = new Select(); $select->from(self::$table, "*")->where("`type` = " . self::$db->getSQ(), array($type))->where("`latest` = " . self::$db->getSQ(), array(1))->rand(); $data_1 = self::$db->select($select); $select = new Select(); $select->from(self::$table, "*")->where("`type` = " . self::$db->getSQ(), array($type)); if ($section_id) { $select->whereFIS("section_ids", $section_id); } $select->rand(); $data_2 = self::$db->select($select); $data = array_merge($data_1, $data_2); if (count($data) == 0) { $select = new Select(); $select->from(self::$table, "*")->where("`type` = " . self::$db->getSQ(), array($type))->rand(); $data = self::$db->select($select); } $data = ObjectDB::buildMultiple(__CLASS__, $data); uasort($data, array(__CLASS__, "compare")); $first = array_shift($data); $this->load($first->id); }
public static function authAdmin($login = false, $password = false) { if ($login) { $auth = true; } else { if (!session_id()) { session_start(); } if (!empty($_SESSION["auth_login"]) && !empty($_SESSION["auth_password"])) { $login = $_SESSION["auth_login"]; $password = $_SESSION["auth_password"]; } else { return; } $auth = false; } $user = new AdminDB(); if ($auth) { $password = self::hash($password, Config::SECRET); } $select = new Select(); $select->from(self::$table, array("COUNT(id)"))->where("`login` = " . self::$db->getSQ(), array($login))->where("`password` = " . self::$db->getSQ(), array($password)); $count = self::$db->selectCell($select); if ($count) { $user->loadOnLogin($login); if ($user->activation != "") { throw new Exception("ERROR_ACTIVATE_USER"); } if ($auth) { $user->login(); } return $user; } if ($auth) { throw new Exception("ERROR_AUTH_USER"); } }
public static function isAlreadyPoll($poll_data_ids) { $select = new Select(self::$db); $select->from(self::$table, array("id"))->whereIn("poll_data_id", $poll_data_ids)->where("`ip` = " . self::$db->getSQ(), array(ip2long($_SERVER["REMOTE_ADDR"])))->limit(1); return self::$db->selectCell($select) ? true : false; }
public static function getCountOnArticleID($article_id) { $select = new Select(self::$db); $select->from(self::$table, array("COUNT(id)"))->where("`article_id` = " . self::$db->getSQ(), array($article_id)); return self::$db->selectCell($select); }
} if (!empty($this->_select['where'])) { $sql .= ' WHERE ' . $this->_select['where']; } if (count($this->_select['and'])) { $sql .= ' AND ' . join(' AND ', $this->_select['and']); } if (count($this->_select['or'])) { $sql .= ' OR ' . join(' OR ', $this->_select['and']); } if (!empty($this->_select['limit'])) { $sql .= ' LIMIT ' . $this->_select['limit']; } return $sql; } public function fetchAll() { $sql = $this->_buildSQL(); echo $sql, '<br/><br/>'; } function fetchOne() { print_r($this->_select); $this->_select['limit'] = '0,1'; $sql = $this->_buildSQL(); echo $sql, '<br/><br/>'; } } $s1 = new Select(); $s1->from('aa')->fields('a,b')->fetchAll(); $s1->from('aa')->fields('a,b')->fetchOne();
public static function issetAliasOnLink($link) { $select = new Select(self::$db); $select->from(self::$table, "*")->where("`category_id` = ?", array($link)); $data = self::$db->select($select); }
protected function loadOnField($field, $value) { //загрузить по какому то значению (пользователя по логину или т.д.) $select = new Select(); $select->from($this->table_name, "*")->where("`{$field}` = " . self::$db->getSQ(), array($value)); $row = self::$db->selectRow($select); if ($row) { if ($this->init($row)) { return $this->postLoad(); } } return false; }
private static function getBaseSelect() { $select = new Select(self::$db); $select->from(self::$table, "*"); return $select; }
public static function authUser($login = false, $password = false) { if ($login) { $auth = true; } else { //значит проверка данных в сесии if (!session_id()) { session_start(); } //стартуем сесию if (!empty($_SESSION["auth_login"]) && !empty($_SESSION["auth_password"])) { //если логин и пароль не пустые $login = $_SESSION["auth_login"]; //то данные берутся из сесии $password = $_SESSION["auth_password"]; } else { return; } //если не авторизация и данные не из сесии значит вазвращаемся $auth = false; //а авторизация false } $user = new UserDB(); if ($auth) { $password = self::hash($password, Config::SECRET); } //если авторизация переданный пароль хэшеруем $select = new Select(); //ищем пользователя отвечаютщего запросу (соответствие логина пароля) $select->from(self::$table, array("COUNT(id)"))->where("`login` = " . self::$db->getSQ(), array($login))->where("`password` = " . self::$db->getSQ(), array($password)); $count = self::$db->selectCell($select); //ищем количество соответствующих (логину паролю)пользователей if ($count) { $user->loadOnLogin($login); //загружаем пользователя if ($user->activation != "") { throw new Exception("ERROR_ACTIVATE_USER"); } //если пользователь не активированн выводим ошибку if ($auth) { $user->login(); } //если авторизация делаем логин return $user; //возвращаем юзера } if ($auth) { throw new Exception("ERROR_AUTH_USER"); } //возвращаем ошибку если не был найден пользователем с таким логином и паролем }
public static function getBrandIDonName($name) { $select = new Select(); $select->from(self::$table, array("id"))->where("title = ?", array($name)); return self::$db->selectCell($select); }
/** * Returns an instance of a Select object. * * @param string|array|Expr $columns * @return Select */ public function selectCol($columns = null) { $select = new Select($this->_db); $select->setTable($this); $select->from($this->_name, $columns === null ? Select::SQL_WILDCARD : $columns, $this->_schema); return $select; }
public static function getLinkOnAlias($alias) { $select = new Select(self::$db); $select->from(self::$table, array("link"))->where("`alias` = " . self::$db->getSQ(), array($alias)); return self::$db->selectCell($select); }
public function loadOnField($field, $value) { $select = new Select(); $select->from($this->table_name, "*")->where("`{$field}` = " . self::$db->getSQ(), array($value)); $row = self::$db->selectRow($select); if ($row) { if ($this->init($row)) { return $this->postLoad(); } } return false; }