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