public function getId($tel)
{
$sqlHelper = new SqlHelper();
$user = new User();
$sql = "select id from user where tel='{$tel}'";
$res = $sqlHelper->dql_arr($sql);
$user->setId($res[0]['id']);
return $user;
}
public function AdminLogin($username, $password)
{
$sqlHelper = new SqlHelper();
$admin = new Admin();
$sql = "select password,level from admin where username='******'";
$res = $sqlHelper->dql_arr($sql);
if ($res[0]['password'] == md5($password)) {
$admin->setUsername($username);
$admin->setLevel($res[0]['level']);
return $admin;
} else {
return null;
}
}
public function getArticleDetail($id)
{
$sqlHelper = new SqlHelper();
$article = new Article();
$sql = "select * from lavender_article where id={$id}";
$res = $sqlHelper->dql_arr($sql);
$article->setId($res[0]['id']);
$article->setPraise($res[0]['praise']);
$article->setContent($res[0]['content']);
$article->setDate($res[0]['date']);
$article->setReadTime($res[0]['read_time']);
$article->setImg($res[0]['img']);
$article->setNoPraise($res[0]['no_praise']);
$article->setTitle($res[0]['title']);
return $article;
}