为这种特殊情况执行sql操作

Question

Sir,

I am facing a problem and it is shown below: I want to perform where opertion on the output of $this->db->select('*')->from('table'); only when cond1 satisfies

 $result = $this->db->select('*')->from('table');
 if(cond1)
 {
  I want to perform $result->where(); operation
 }

Is it possible and i so what is the exact syntax to do it

Answer 1

try something like this:

$this->db->select('*');
$this->db->from('table');
if ($cond1)
    $this->db->where(...)

$query = $this->db->get();