时间:2021-07-01 10:21:17 帮助过:3人阅读
public function find()
{
$sql = "SELECT * FROM qsj_user_profile
RIGHT JOIN qsj_user ON qsj_user.uid = qsj_user_profile.uid";
if(!empty($_GET['email']))
{
$sql.="AND qsj_user.email=".$_GET['email'];
}
if(!empty($_GET['nickname']))
{
$sql.="AND qsj_user_profile.nickname = ".$_GET['nickname'];
}
if(!empty($_GET['province']))
{
$sql.="AND qsj_user_profile.province =".$_GET['province'];
}
if(!empty($_GET['city']))
{
$sql.="AND qsj_user_profile.city =".$_GET['city'];
}
if(!empty($_GET['dist']))
{
$sql.="AND qsj_user_profile.dist = ".$_GET['dist'];
}
if(!empty($_GET['style']))
{
$sql.="AND qsj_user_profile.style =".$_GET['style'];
}
$query = $this->db->query($sql);
return $query->result_array();
}