doufu1504 2015-07-08 07:24
浏览 63

调用未定义的方法CI_DB_mysql_driver :: get_compiled_select()?

I've the following sql active record query which is giving this error. I have inner select queries so that why I tried to use this method that i found on google but it's giving error that get_complied_select is not defined. How to solve this error or is there any other better way to write following queries? Thanks!

        $this->db->select('id_dem');
    $this->db->from('dem_demos');
    $this->db->where('id_dem IN (".implode("," ,$id_v).") OR maindemo_dem IN (".implode(",",$id_v).")');
    $innermost_query = $this->db->get_compiled_select();

    $this->db->select('COUNT(demo_vis) as tot_visits');
    $this->db->from('sta_views');
    $this->db->where('countvisit_wis != "N" AND demo_vis IN $innermost_query AND date_vis BETWEEN 
    ".$date_s." AND ".$date_e."');
    $first_query = $this->db->get_compiled_select();

    $this->db->select('COUNT(demo_vis) as tot_visits');
    $this->db->from('sta_views');
    $this->db->where('countvisit_wis != "N"
                  AND demo_vis IN $innermost_query AND date_vis BETWEEN ".$date_s." AND ".$date_e." AND 
                  invited_vis = 0');
    $second_query = $this->db->get_compiled_select();

    $this->db->select('COUNT(demo_vis) as tot_visits');
    $this->db->from('sta_views');
    $this->db->where('countvisit_wis != "N"
                  AND demo_vis IN $innermost_query AND date_vis BETWEEN ".$date_s." AND ".$date_e." AND 
                  invited_vis > 0');
    $third_query = $this->db->get_compiled_select();

    $this->db->select('COUNT(conversion_vis)');
    $this->db->from('sta_views');
    $this->db->where('countvisit_wis != "N"
                  AND demo_vis IN $innermost_query AND date_vis BETWEEN ".$date_s." AND ".$date_e." AND 
                  invited_vis = 0 AND conversion_vis = 1');
    $fourth_query = $this->db->get_compiled_select();

    $this->db->select('COUNT(buy_vis)');
    $this->db->from('sta_views');
    $this->db->where('countvisit_wis != "N"
                  AND demo_vis IN $innermost_query AND date_vis BETWEEN ".$date_s." AND ".$date_e." AND 
                  buy_vis = 1');
    $fifth_query = $this->db->get_compiled_select();

    $this->db->select('COUNT(distinct session_vis) as unique_visits');
    $this->db->from('sta_views');
    $this->db->where('countvisit_wis != "N"
                  AND demo_vis IN $innermost_query AND date_vis BETWEEN ".$date_s." AND ".$date_e."');
    $sixth_query = $this->db->get_compiled_select();

    $query  = $this->db->select('$first_query as total_views, $second_query as website_views, $third_query as demosent_views,
    $fourth_query as website_conversions, $fifth_query as buy_now_clicks, $$sixth_query as unique_views');
    if ($query->num_rows() > 0){
        return $query->row_array();
    }else{
        return FALSE;
    }
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 iOS开发关于快捷指令截屏后如何将截屏(或从截屏中提取出的文本)回传给本应用并打开指定页面
    • ¥15 unity连接Sqlserver
    • ¥15 图中这种约束条件lingo该怎么表示出来
    • ¥15 VSCode里的Prettier如何实现等式赋值后的对齐效果?
    • ¥15 流式socket文件传输答疑
    • ¥20 keepalive配置业务服务双机单活的方法。业务服务一定是要双机单活的方式
    • ¥50 关于多次提交POST数据后,无法获取到POST数据参数的问题
    • ¥15 win10,这种情况怎么办
    • ¥15 如何在配置使用Prettier的VSCode中通过Better Align插件来对齐等式?(相关搜索:格式化)
    • ¥100 在连接内网VPN时,如何同时保持互联网连接