How can I answer with array?

Asked May 22 '20 at 16:34

Active May 23 '20 at 06:01

Viewed 30 times

i can explain with an example

$sorgu=$db->prepare("SELECT * FROM table WHERE name=:name1 OR name=:name2");
$sorgu->execute(['name1' => "John",'name2' => "Aydin"]);
$cikti=$sorgu->fetchAll(PDO::FETCH_ASSOC);

i can get what i want this way but should there be a more practical way? is there like this one way?

$answers=['John','Aydin'];
$sorgu=$db->prepare("SELECT * FROM table WHERE name=:names");
$sorgu->execute(['names' => $answers]);
$cikti=$sorgu->fetchAll(PDO::FETCH_ASSOC);

i think this isn't work but i want to know there's should better way?

edited May 23 '20 at 02:25

Isaac Bennetch

11,830
2
32
43

asked May 22 '20 at 16:34

Aydın Safi

[PHP - Using PDO with IN clause array](https://stackoverflow.com/questions/14767530/php-using-pdo-with-in-clause-array) – gre_gor May 22 '20 at 16:48
Thank You that's what i looking for – Aydın Safi May 22 '20 at 17:02
i am sorry, i need help. `(products_category IN (:category))` it's not working only on category, if :category is 1 not problem but 1,22,23 it's not working – Aydın Safi May 22 '20 at 19:05
It's explained in the second link. – gre_gor May 22 '20 at 21:04
yep it's true i am sorry – Aydın Safi May 26 '20 at 19:33

How can I answer with array?

0 Answers0