Failed to select data with where clause in array

Question

I have an array $DeptID :array(5) { [0]=> string(1) "2" [1]=> string(1) "8" [2]=> string(2) "11" [3]=> string(2) "15" [4]=> string(2) "17" } Then, I want to select from MySQL database to get data where DeptID in array. My query:

$DeptdID = implode(',', $DeptID);
$this->db->select(*)
->from('tabel_data')
->where('DeptID IN ('.$DeptID.')')
->group_by('DeptID', 'ASC')
->get(''):

But an error occur.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near (Array) GROUP BY `DeptID` at line 6.

Maybe someone can give me a solution

Oh yeah. Sory, actually, my query is so long, but I cut it so people read it simply — dede
– dede, Commented Jan 16, 2016 at 2:51
Looks like you either misspelled or are referencing the wrong variable in your where clause. Try referencing $DeptdID in your where() or change $DeptdID to $DeptID in your first line. — dnapierata
– dnapierata, Commented Jan 16, 2016 at 3:04
Relevant: How to write a parameterized WHERE IN (?) condition using CodeIgniter's query() method? and CodeIgniter active record SELECT query with comma-separated value passed to where_in() only returns data for the first id in the string — mickmackusa
– mickmackusa ♦, Commented Jul 14 at 5:58

dnapierata · Accepted Answer · 2016-01-16 02:57:56Z

3

Since you're using CodeIgniter you can try using the where_in function instead of implode and where. The where_in method will do this for you.

$this->db->select(*)
->from('tabel_data')
->where_in('DeptID', $DeptID)
->group_by('DeptID', 'ASC')
->get(''):

answered Jan 16, 2016 at 2:57

dnapierata

1,2331 gold badge18 silver badges29 bronze badges

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

1 Comment

dnapierata Over a year ago

No problem. Lots of usefull stuff about active record can be found here for version <= 2.2 and here for version 3+

wogsland · Accepted Answer · 2016-01-16 02:48:30Z

0

Your $DeptID is an array which when cast as a string comes out as Array. You need to implode it:

$DeptID = '(' . implode(',', $DeptID) . ')';

before putting it in the query.

answered Jan 16, 2016 at 2:48

wogsland

9,54121 gold badges63 silver badges99 bronze badges

2 Comments

dede Over a year ago

Yeah, but it still not working. I will update my question

wogsland Over a year ago

The implode function is kinda critical for getting this to work. ($DeptdID != $DeptID)

Collectives™ on Stack Overflow

Failed to select data with where clause in array

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related