运动桌:
id name
1 Athletics
2 Aerobics
用户表:
id sports_type
1 1,2
2 1
型号查询:
function select_sports($sports)
{
$this->db->select('id');
$this->db->like('name', $sports);
$query = $this->db->get('sports');
//print_r($query);exit();
return $query->row();
}
function get_filterde_user()
{
$sql = "SELECT * FROM users";
$query = $this->db->query($sql);
return $query->result();
}
控制器:
$sports = $this->input->post('sports');
$query = $this->user_model->select_sports($sports);
$sport_id = $query->id;
$sport_get = explode(',',$sport_id);
$query = $this->user_model->get_filterde_user();
$arr = array();
foreach ($query as $row=>$value) {
if ($value->sports_type != 0 && $value->user_type != 1) {
$sports_type = explode(',', $value->sports_type);
foreach ($sport_get as $search) {
if (in_array($search, $sports_type)) {
echo $arr[$row]['name'] = $value->user_name; die;
}
}
}
}
但这并没有提供所有与字段相关的sports_type
从您的数据库结构来看,它似乎很困难但可行,我建议如下数据库结构:
运动桌:
id sport_name
用户表:
id用户名user_adress
user_sports:
id users_id(用户表pk)sports_id(运动表pk)
然后尝试搜索操作,这将非常容易
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句