How to check two values in array mysql using codeigniter

Question

I'm new to codeigniter. I having a problem checking two values in field using a model with codeigniter.

I'm trying to check if "status" value is "Available" or "Notavailable"

I'm using this model to check but only one value. 'Available' Only.

public function withdraw_check($data)
{
    $this->db->select('game');
    $where = array('id_user' => $this->session->userdata('user_id'),
                   'status' => 'Available', 
                   'game' => $data,
                   'site' => $this->system_library->sitename()
                  );
    $this->db->where($where);
}

Pro Dev · Accepted Answer · 2015-06-19 06:36:24Z

2

Why not use a WHERE IN statement:

$this->db->where_in('status',array('Available','Notavailable'));

SQL Produced:

WHERE status IN ('Available', 'Notavailable')

Final Code:

$this->db->select('game');
$this->db->where('id_user',$this->session->userdata('user_id'));
$this->db->where_in('status',array('Available','Notavailable'));
$this->db->where('game',$data);
$this->db->where('site', $this->system_library->sitename());

edited Jun 19, 2015 at 6:36

Pro Dev

6841 gold badge9 silver badges28 bronze badges

answered Jun 19, 2015 at 5:23

vijaykumar

4,8367 gold badges40 silver badges56 bronze badges

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

1 Comment

Pro Dev Over a year ago

I'll try that @Jeemusu tnx

Pro Dev · Accepted Answer · 2015-06-19 05:26:56Z

0

Try like this,

 $this->db->select('game');
 $where = array
                (
                    'id_user' => $this->session->userdata('user_u_id'),
                    'game' => $data,
                    'site' => $this->system_library->sitename()
                );
$this->db->where('status=' ,'Pending');
$this->db->or_where('status=' ,'Hold');
$this->db->where($where);

edited Jun 19, 2015 at 5:26

Pro Dev

6841 gold badge9 silver badges28 bronze badges

answered Jun 19, 2015 at 5:14

Pramod

1,0313 gold badges13 silver badges26 bronze badges

1 Comment

Pramod Over a year ago

` ''Pending' ` something wrong here. Double quotes coming there. Verify it again.

Collectives™ on Stack Overflow

How to check two values in array mysql using codeigniter

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related