public function getAttrArticle($_attr) { switch ($_attr) { case "headline": $_sql = "select * from article where state=1 and attr like '%headline%' order by id desc limit 1"; return parent::getOne($_sql); break; case "focus": $_sql = "select * from article where state=1 and attr like '%focus%' order by id desc limit 1"; return parent::getOne($_sql); break; case "topic": $_sql = "select * from article where state=1 and attr like '%topic%' order by id desc limit 1"; return parent::getOne($_sql); break; case "recommend": $_sql = "select * from article where state=1 and attr like '%recommend%' order by id desc limit 1"; return parent::getOne($_sql); break; case "pickup": $_sql = "select * from article where state=1 and attr like '%pickup%' order by id desc limit 1"; return parent::getOne($_sql); break; } }
public function getOneJudge() { $_sql = "select * from veling_exam_judge where id=" . $this->id; return parent::getOne($_sql); }
public function getOneLevel() { $_sql = "select * from level where id=" . $this->id; return parent::getOne($_sql); }
public function getOneSearch() { $_sql = "select * from dict where wordname='" . $this->wordname . "' limit 10"; //echo $_sql; return parent::getOne($_sql); }
public function getOneNav() { $_sql = "select * from nav where id=" . $this->id; return parent::getOne($_sql); }
public function getOneDownload() { $_sql = "select * from download where id=" . $this->id; return parent::getOne($_sql); }
public function getOnePermission() { $_sql = "select * from permission where id=" . $this->id; return parent::getOne($_sql); }
/** * 删除图片,根据图片ID * @param int $image_id */ static function delPicByImageId($image_id) { $db_name = PREFIX . 'images i'; $m = new Model(); $data = $m->getOne($db_name, "i.id={$image_id}", "i.path as p, i.big_img as b, i.small_img as s"); foreach ($data as $v) { @self::delFile(ROOT_PATH . $v['p']); @self::delFile(ROOT_PATH . $v['b']); @self::delFile(ROOT_PATH . $v['s']); } $m->del(PREFIX . 'images', "id={$image_id}"); unset($m); }
public function getOneComment() { $_sql = "select * from comment where id=" . $this->id; return parent::getOne($_sql); }
public function getOneOrder() { $_sql = "select * from orders where id=" . $this->id; return parent::getOne($_sql); }
public function get() { $sql = "SELECT id, menu \n\t\t\t\tFROM maipuwx_menu \n\t\t\t\tWHERE id='{$this->id}'"; return parent::getOne($sql); }
public function getOneProduct() { $_sql = "select * from products where id=" . $this->id; return parent::getOne($_sql); }
<?php require_once __DIR__ . '/../mrpropper/db/sqlite.php'; $db = new Model(); $res = $db->getOne($_GET['id']); /* * profession organisation additions salary address contacts search */ if (isset($res[0])) { $title = $res[0]['profession']; } else { header("HTTP/1.0 404 Not Found"); } ?> <html> <head> <?php if ($title) { ?> <meta name="description" content="Вакансия <?php echo $title; ?> в Нягани, а также много других на сайте. Вакансии центра занятости и отдельных предпринимателей." /> <?php } else {
public function getOneUserByEmail() { $_sql = "select * from user where email='" . $this->email . "' and username='******'"; //echo $_sql; return parent::getOne($_sql); }
public function getOnetopic() { $_sql = "select * from topic where id=" . $this->id; return parent::getOne($_sql); }
public function getOneVote() { $_sql = "select * from vote where id=" . $this->id; //echo $_sql; return parent::getOne($_sql); }
public function getOneAdmin() { $_sql = "select * from admin where id=" . $this->id; return parent::getOne($_sql); }
public function getOneCategory() { $_sql = "select * from category where id=" . $this->id; return parent::getOne($_sql); }