how to implement mysql IN(,) function inside PHP for flutter use

Question

I'm trying to use the mysql IN(,) function for flutter use, to retrieve two values from a single column

"SELECT * from TABLE WHERE COLUMN IN (VAL1,VAL2) "<= Now this works fine in thunder client, I just want to implement it for flutter use, I tried:

"SELECT * from TABLE WHERE COLUMN IN (?,?) " <= but I didn't know how to assign it to the PHP variables.

please help

Does this answer your question? [How to use PDO prepared statements with IN clause?](https://stackoverflow.com/questions/37827340/how-to-use-pdo-prepared-statements-with-in-clause) — Justinas, Apr 28 '23 at 08:17

score 0 · Accepted Answer · answered Apr 28 '23 at 04:35

0

If you just want to concat PHP variable to a string, try this:

"SELECT * from TABLE WHERE COLUMN IN ('".$VAL1."','".$VAL2."') ";

answered Apr 28 '23 at 04:35

Grykarreos

Imploding values would be more appropriate instead of writing them by hand – Justinas Apr 28 '23 at 08:20
yes, but how can you do it if the column datatype is string? You need a wrap the value in qoutes. – Grykarreos Apr 28 '23 at 08:31
`'"' . implode('",', $values) . '"'` - that's how – Justinas Apr 28 '23 at 08:47
no its not. run it then show your result. – Grykarreos Apr 28 '23 at 08:55
1

https://onlinephp.io?s=s7EvyCjg5eLlUilLzClNLVawVYg21FEw0lEwjrUGiacmZ-QrqCupK-gpZOYW5OSnpGqoK-koqesoQHVoAmWA8tYA&v=8.2.5 – Justinas Apr 28 '23 at 08:58

1 Answers1