how i print strings in implode function

Question

$color is array

$sql=" SELECT * FROM products  WHERE color IN (".implode(',', $color).")";

its showing result is

SELECT * FROM products WHERE color IN (red,green,blue);
SELECT * FROM products WHERE color IN ('red','green','blue');

Answer 1

Update your query like as

$sql="SELECT * FROM products  WHERE color IN ('".implode("','", $color)."')";
                                           //^^         ^^  ^^          ^^ Added

Answer 2

Try this:

$sql = "SELECT * FROM products  WHERE color IN ('".implode("','", $color)."')";