How to set variable in where condition in codeigniter if variable is set?

Question

Below is my code

$state = $data['state'];
$this->db->select("state")->from('table')
    ->where('en_movingfrom_state', $state)
    ->where('status', 3);

I want to execute this query, if $state is set then where condition will execute.

So please help me how can i do this?

Sinto · Accepted Answer · 2017-11-09 09:53:15Z

1

Try this:

$state = $data['state'];

// checking `$state has set`
if (isset($state) && (trim($state) != '')) {
    $this->db->where('en_movingfrom_state', $state)
}
$result = $this->db->select("state")->from('table')
    ->where('status', 3)
    ->get()->result_array();

// Output
print_r($result);

answered Nov 9, 2017 at 9:53

Sinto

3,97712 gold badges41 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

geeth · Accepted Answer · 2017-11-09 09:55:52Z

0

you can use isset() function to check whether $state is set

$state = $data['state'];
$this->db->select("state")->from('table');
if(isset($state) && $state != ""){
   $this->db->where('en_movingfrom_state', $state);
}
$this->db->where('status', 3);
$this->db->get()->result_array();

answered Nov 9, 2017 at 9:55

geeth

7142 gold badges19 silver badges44 bronze badges

Collectives™ on Stack Overflow

How to set variable in where condition in codeigniter if variable is set?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related