Php array into mysql select query

Question

$multiples_names is an array.

For eg $multiple_names = ['1','2','3','4'];

How do I pass it to php mysql query so that I can select all items pertaining to that array.

$multiple_names = $_POST['multiple_names'];  

$multiple_names_array = implode(',', $multiple_names);

$stmt1 = $conn->prepare("SELECT * from attendance where name in (?) and today_date between ? and ? order by id ASC");

$stmt1->execute(array($multiple_names_array, $checkInDateFinal, $checkOutDateFinal));

I want the results of query to look something like that

Names   Product
1       Product A
1       Product A
2       Product B
3       Product C
3       Product C
4       Product D

Try a lot of methods but still could not get the results I want.

Possible duplicate of Bind Param with array of parameters

node_modules
– node_modules

2017-08-08 07:45:43 +00:00
Commented Aug 8, 2017 at 7:45 — node_modules
– node_modules, Commented Aug 8, 2017 at 7:45
pl check my edit answers

Mahipal Patel
– Mahipal Patel

2017-08-08 11:05:34 +00:00
Commented Aug 8, 2017 at 11:05 — Mahipal Patel
– Mahipal Patel, Commented Aug 8, 2017 at 11:05

MinistryOfChaps · Accepted Answer · 2017-08-08 08:44:02Z

0

You can make placeholders depending on the size of $multiple_names_array. You should never put values directly into a query like in your code because (as said in the comments) you are vulnerable to SQL injection. I would also put all of the values into one array.

This is the solution you are looking for. All values are binded.

//Assuming the names are separated by commas, e.g "John,Jack,Jill';
$multiple_names = $_POST['multiple_names'];  
$multiple_names_array = explode(',',$multiple_names);

$placeholders = implode(', ',  array_fill(0, count($multiple_names_array), '?'));

//Put all values into one array.
$arguments = array_merge(array(), $multiple_names_array);
array_push($arguments, $checkInDateFinal);
array_push($arguments, $checkOutDateFinal);

// SELECT * FROM attendance WHERE name IN (?, ?, ?, ?, etc...) AND today_date BETWEEN ? AND ? ORDER BY id ASC
$stmt1 = $conn->prepare("SELECT * from attendance where name in ($placeholders) and today_date between ? and ? order by id ASC");
$stmt1->execute($arguments);

edited Aug 8, 2017 at 8:44

answered Aug 8, 2017 at 8:07

MinistryOfChaps

1,49219 silver badges32 bronze badges

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

2 Comments

MinistryOfChaps Over a year ago

@xingtan This is the final solution, I've read through and fixed the entire code correctly.

MinistryOfChaps Over a year ago

@xingtan glad it worked, make sure to tick the answer as the solution for others to notice if they come across the same problem.

Collectives™ on Stack Overflow

Php array into mysql select query

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related