PHP Implode get expected result for IN query

Question

Please help me How can I get my expected result and thanks in advance plus sorry for my weak English.

PHP:

  $dog = implode(',', $data['dogbreed']);
  $query .= "AND `dog_breeds`.`id` IN ('".$dog."')";

OUTPUT:

AND `dog_breeds`.`id` IN ('9,31')

EXPECTED RESULT:

AND `dog_breeds`.`id` IN ('9','31')

Array:

([0] => 9 [1] => 31)

Of course, you should really be using parametrised queries, which in the case of IN() are rather tricky things to construct. :-( — Strawberry
– Strawberry, Commented Apr 28, 2017 at 7:18

Death-is-the-real-truth · Accepted Answer · 2017-04-28 10:38:09Z

2

Try this:-

$dog = implode("','", $data['dogbreed']);
$query .= "AND `dog_breeds`.`id` IN ('".$dog."')";

edited Apr 28, 2017 at 10:38

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

answered Apr 28, 2017 at 6:22

Ashok

1281 silver badge8 bronze badges

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

1 Comment

Suresh Over a year ago

Remove that . which exist before =.

Death-is-the-real-truth · Accepted Answer · 2017-04-28 06:59:55Z

0

Change your line:-

$dog = implode(',', $data['dogbreed']);

to:-

$dog = implode("','", $data['dogbreed']);

And your code will work fine.(don't change anything else)

Check output here:- https://eval.in/784234

Note:-

Please don't change this line:-

$query .= "AND `dog_breeds`.`id` IN ('".$dog."')";

edited Apr 28, 2017 at 6:59

answered Apr 28, 2017 at 6:21

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

2 Comments

trincot Over a year ago

@shahrushabh, please pay attention. You must put the extra quotes in the first argument of implode. Don't waste people's time by trying with code that is not exactly as provided to you.

Death-is-the-real-truth Over a year ago

@shahrushabh please read my answer properly. and you will get the answer

Zaid Bin Khalid · Accepted Answer · 2017-04-28 06:27:49Z

0

Here is the change. Try this

$data['dogbreed']   =   array(9,10);
$dog = implode('","', $data['dogbreed']);
print  $query = 'AND dog_breeds.id IN ("'.$dog.'")';

answered Apr 28, 2017 at 6:27

Zaid Bin Khalid

7639 silver badges27 bronze badges

Collectives™ on Stack Overflow

PHP Implode get expected result for IN query

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related