PHP Select::from方法代码示例

 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);
 }