时间戳

首页 > 解决方案 > 条件之后的条件或条件在codeigniter中不起作用

php - 条件之后的条件或条件在codeigniter中不起作用

问题描述

当我只使用OR3 个OR条件中的一个条件时，该where子句不起作用。

 $this->db->where('(delivery_date BETWEEN "'.$from.'" AND "'.$to.'") ');
    $this->db->or_where('order_date BETWEEN "'.$odfrom.'" AND "'.$odto.'"');
     $this->db->or_where('mumbai_date BETWEEN "'.$mdfrom.'" AND "'.$mdto.'"');
    $this->db->where('order_location',$sess_location);
    $this->db->where('designer_id',$sess_designer_id);
    $this->db->where('is_deleted=',0);
    $query= $this->db->limit($length,$start)->get();
return $query->result();

标签： phpcodeigniter

解决方案

在带括号的 codeigniter 轮“or_where”条件中；

$this->db->where('(delivery_date BETWEEN "'.$from.'" AND "'.$to.'") ');
$this->db->where('((order_date BETWEEN "'.$odfrom.'" AND "'.$odto
                 .'") OR (mumbai_date BETWEEN "'.$mdfrom.'" AND "'.$mdto.'"))',NULL,false);

$this->db->where('order_location',$sess_location);
$this->db->where('designer_id',$sess_designer_id);
$this->db->where('is_deleted=',0);
$query= $this->db->limit($length,$start)->get();

推荐阅读