How to fetch value from MySQL table based on array value using PHP and MySQL

Question

I need one help .I need to fetch values from Database but it should depends on some data present inside an array using PHP and Mysql.I am explaining my code below.

$arr=['1','2','4','5','12','13'];

The above array has some value which is also present inside table as one column which is given below.

db_user:

id    name    supplier_id    city


1    Rocky     1             bbsr

2    Raj       4             CTC

3    Moynk     6             bLS

4    Nilima    1              CTC


5   Biswa      2             BBSR

6   Deepak     12            NPR

7   Rajua      13            OMP

8   Girija      10           CTC

9   Joyes      2            KKR

In the above table the array value are present inside column supplier_id here i need query to fetch all values whose supplier_id are belongs to that array and that also in descending order.Please help me.

My guess is that @subhra doesn't know what a SELECT is... SELECT * FROM db_user WHERE supplier_id=X OR supplier_id=Y OR ... OR supplier_id=Z ORDER BY supplier_id DESC — joninx
– joninx, Commented May 19, 2016 at 10:04

Hanky Panky · Accepted Answer · 2016-05-19 10:02:05Z

4

You can use an IN clause for this. First of all take your array and implode it on , so you get a list of numbers you want to search against. Then provide that list to that IN clause and get your results.

$arr=['1','2','4','5','12','13'];
$values=implode(",",$arr);
$query="SELECT * FROM db_user WHERE supplier_id IN ($values) ORDER BY supplier_id DESC";

Now run that query

answered May 19, 2016 at 10:02

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

1 Comment

joninx Over a year ago

This is a better query than mine.

Collectives™ on Stack Overflow

How to fetch value from MySQL table based on array value using PHP and MySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related