Convert an array into format for an WHERE IN mysql clause

Question

I have an array that contains strings

e.g array('14183f6c-9bf5', '074306fb-6eaf')

I want to convert this into a format readable for an mysql query with an IN statement but I keep getting issues as its a string..

Essentially get this to be formatted as such in my sql query - I am using implode but to no avail.. any ideas

Guid IN ("14183f6c-9bf5", "074306fb-6eaf")

$Guids = array('14183f6c-9bf5', '074306fb-6eaf');
$csv = implode('",', $Guids);

http://stackoverflow.com/questions/907806/php-mysql-using-an-array-in-where-clause?rq=1 — WeCanBeFriends, Aug 14 '15 at 17:44

score 5 · Accepted Answer · edited Jun 16 '22 at 05:09

5

Try something like this

$whereIn = implode('","', $array);
$sql = 'SELECT * FROM table WHERE col IN ("'.$whereIn.'")';

edited Jun 16 '22 at 05:09

linktoahref

answered Jan 21 '15 at 15:09

krzysiej

1

Warning: this answer is DANGEROUS, allowing SQL injection – Your Common Sense Jun 16 '22 at 05:14

score 0 · Answer 2 · answered Jan 21 '15 at 15:18

0

try with this :

$whereIn = '("' . implode('","', $array) . '")';

answered Jan 21 '15 at 15:18

Halayem Anis

2 Answers2