dongma1666 2015-09-19 22:02
浏览 65
已采纳

CodeIgniter嵌套在where条件中

I want to run this query on CodeIgniter

select * from connections where (first_user=$u_id and second_user=$id) OR (first_user=$id and second_user=$u_id)

Controller I written for creating above code as follows

$where = array('first_user' => $this->session->userdata('u_id') , 'second_user'=> $this->uri->segment(4));
$or_where = array('first_user' => $this->uri->segment(4) , 'second_user'=> $this->session->userdata('u_id'));
$data['friendship']=$this->user_model->get_sql_select_data_or_where('connections', $where, $or_where, NULL, '1');

and the function get_sql_select_data_or_where is as follows

public function get_sql_select_data_or_where($tablename, $where = '', $or_where = '', $feild = '', $limit = '', $order_by = '', $like = '') {

    if (!empty($feild))
        $this->db->select($feild);

    if (empty($feild))
        $this->db->select();

    if (!empty($where))
        $this->db->where($where);

    if (!empty($or_where))
        $this->db->or_where($or_where);

    if (!empty($limit))
        $this->db->limit($limit);

    if (!empty($like))
        $this->db->like($like);

    if (!empty($order_by))
        $this->db->order_by($order_by);

    $this->db->from($tablename);
    $query = $this->db->get();
    return $query->result();
}

But when I print the query ,the result is as below

SELECT * FROM (`connections`) WHERE `first_user` = '28' AND `second_user` = '20' OR `first_user` = '20' OR `second_user` = '28' LIMIT 1 

Where I expected AND condition instead of second OR. What could possibly go wrong?

展开全部

  • 写回答

2条回答 默认 最新

  • dongle19863 2015-09-19 23:56
    关注

    You can use this

     $where = "(first_user='".$this->session->userdata('u_id')."' AND second_user='". $this->uri->segment(4)."') OR ( second_user= '".$this->session->userdata('u_id')."' AND first_user= '".$this->uri->segment(4)."') ";
    

    Referance : How to give two or where condition in mysql query in codeigniter

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 在更新角色衣服索引后,Sprite 并未正确显示更新的效果该如何去解决orz(标签-c#)
  • ¥15 VAE代码如何画混淆矩阵
  • ¥15 求遗传算法GAMS代码
  • ¥15 雄安新区高光谱数据集的下载网址打不开
  • ¥66 android运行时native和graphics内存详细信息获取
  • ¥100 求一个c#通过CH341读取数据的Demo,能够读取指定地址值的功能
  • ¥15 rk3566 Android11 USB摄像头 微信
  • ¥15 torch框架下的强化学习DQN训练奖励值浮动过低,希望指导如何调整
  • ¥35 西门子博图v16安装密钥提示CryptAcquireContext MS_DEF_PROV Error of containger opening
  • ¥15 mes系统扫码追溯功能
手机看
程序员都在用的中文IT技术交流社区

程序员都在用的中文IT技术交流社区

专业的中文 IT 技术社区,与千万技术人共成长

专业的中文 IT 技术社区,与千万技术人共成长

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

客服 返回
顶部