How to fetch values for every id present in array using loop

Question

I have an array with following values:

$test = [2,8,10,12];

and a table 'orderdetails' in database with order_title and order_id columns.

What I want is to fetch order_title of every order using order_id in a loop. Can anyone help?

What I know is:

$test = [2,8,10,12];
foreach($test as $order_id){
$order_name = $wpdb->get_results('SELECT order_title FROM orderdetails WHERE order_id ='. $order_id);
$order_names[] = $order_name;
}

but this will make query run multiple times, any better solution?

UPDATE:

When I try to use IN(), values are getting inserted like this:

SELECT order_title FROM orderdetails WHERE order_id IN(2,8,10,12)

but what problem is here, query is only returning the value for first element in array that is 2

the solution needs to get applied is IN('2','8','10','12') all the values should be in a single quote, but I don't know how to achieve that.

Besides the fact that the given query is vulnerable to SQL injection: why not use IN()? — Nico Haase
– Nico Haase, Commented Feb 23, 2022 at 8:39
@NicoHaase I tried using IN() but the problem is the values needs to be in single invaded comma else it won't work. — Sanad Qazi
– Sanad Qazi, Commented Feb 23, 2022 at 8:41
Whatever you mean by "single invaded comma": please share your attempts such that others can see where this is going wrong — Nico Haase
– Nico Haase, Commented Feb 23, 2022 at 8:41
Did you check whether get_results returns an array that you could iterate over? — Nico Haase
– Nico Haase, Commented Feb 23, 2022 at 9:00

W Kristianto · Accepted Answer · 2022-02-23 08:58:30Z

1

You can use WHERE IN :

$ids = implode("','", [2,8,10,12]); 
$query = "SELECT order_title FROM orderdetails WHERE order_id IN ('$ids')";
$order_name = $wpdb->get_results($query);

Query :

SELECT order_title FROM orderdetails WHERE order_id IN ('2','8','10','12')

edited Feb 23, 2022 at 8:58

answered Feb 23, 2022 at 8:47

W Kristianto

9,3737 gold badges51 silver badges73 bronze badges

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

2 Comments

Sanad Qazi Over a year ago

thanks for quick answer, but problem with this solution is: query is only returning the value for first element in array that is 2 the solution needs to get applied is IN('2','8','10','12') all the values should be in a single quote, but I don't know how to achieve that.

W Kristianto Over a year ago

@SanadQazi check my update

jnko · Accepted Answer · 2022-02-23 08:51:08Z

0

I'd do it like this:

$test = [2,8,10,12];
$inclause = '';
foreach($test as $order_id){
    $inclause .= $order_id . ',';
}
$inclause = rtrim($inclause,',');
$query = 'SELECT order_title FROM orderdetails WHERE order_id IN ('. $inclause . ')';
$order_name = $wpdb->get_results($query);

answered Feb 23, 2022 at 8:51

jnko

1631 silver badge12 bronze badges

2 Comments

Sanad Qazi Over a year ago

thanks for quick answer, but problem with this solution is: query is only returning the value for first element in array that is 2 the solution needs to get applied is IN('2','8','10','12') all the values should be in a single quote, but I don't know how to achieve that.

jnko Over a year ago

How about this then? 3v4l.org/ian7E

Collectives™ on Stack Overflow

How to fetch values for every id present in array using loop

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related