Esempio n. 1
0
 function test($name)
 {
     $this->table = LZ_MYSQL_PREFIX . 'item';
     $data = parent::query("SELECT * FROM `lz_item` WHERE `name` like '" . $name . "%' ORDER BY user_id DESC;");
     var_dump($data);
     $this->table = LZ_MYSQL_PREFIX . 'user';
     return $data;
 }
Esempio n. 2
0
 function get_prev_next($curCid = "")
 {
     $map = "SELECT category_id FROM `lz_category` WHERE parent_id=1 AND status=1 ORDER BY category_id desc limit 1";
     if (isset($curCid)) {
         $map = $map = "SELECT * FROM `lz_category` WHERE parent_id=1 AND category_id=" . $curCid . " AND status=1 ORDER BY category_id DESC  LIMIT 1";
     }
     $lastestId = parent::query($map);
     $lastestId = $lastestId[0]['category_id'];
     $prevId = parent::query("SELECT * FROM `lz_category` where `category_id`<" . $lastestId . "  and `parent_id`=1 and `status`=1 order by `category_id` desc limit 1");
     $prevId = $prevId[0]['category_id'];
     $nextId = parent::query("SELECT * FROM `lz_category` where `category_id`>" . $lastestId . "  and `parent_id`=1 and `status`=1 order by `category_id` asc limit 1");
     $nextId = $nextId[0]["category_id"];
     return array("prev" => $prevId, "cur" => $lastestId, "next" => $nextId);
 }