douyunjiaok300404 2015-06-16 07:32
浏览 67
已采纳

关联数组转换为Codeigniter中的OR子句

using CI I'm trying to set up query with three parameters: user_id, content_type and content_id in which content_id is array of IDs.

So I need to get up with something like this:

SELECT name FROM content WHERE user_id = 2 AND content_type = file AND (content_id = 4 OR content_id = 5 OR content_id = 7 ...).
  1. question: is this right query to get all the content_ids?
  2. does CI have any function where I can say

        $this->db->select('name');
        $this->db->from('content');
        $this->db->where('user_id', $user_id);
        $this->db->where('content_ids', $content_ids);
        $this->db->where('content_type', $content_type);
    

    just so that middle where clause is actually where with nested ORs in between and its filled with associative array ($content_ids)?

Thank you for answers.

EDIT: I have found a solution: where_in command does exactly what I need.

  • 写回答

1条回答 默认 最新

  • dongpeng0127 2015-06-16 08:42
    关注

    You can use IN clause to replace many OR conditions

    So your query within Active Records looks like

    $content_ids = array(4,5,7);
    $where = array('user_id' => $user_id,'content_type' => $content_type);
    $this->db->select('name');
    $this->db->from('content');
    $this->db->where($where);//created array of where clause
    $this->db->where_in('content_type', $content_ids);
    return $this->db->get()->result_array();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 用C语言完成一个复杂的游戏
  • ¥15 如何批量更改很多个文件夹里的文件名中包含文件夹名?
  • ¥50 MTK手机模拟HID鼠标出现卡顿
  • ¥20 求下下面这个数据结构代码
  • ¥20 前端 二进制文件流图片转化异常
  • ¥15 github上的这个C语言项目如何跑起来
  • ¥15 java 判断某个数 区间是否存在
  • ¥15 appium控制多个雷电模拟器问题
  • ¥15 C# iMobileDevice
  • ¥15 谁会做这个啊#ensp#Boson NetSim