$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');
4 Answers
Update your query like as
$sql="SELECT * FROM products WHERE color IN ('".implode("','", $color)."')";
//^^ ^^ ^^ ^^ Added
answered Jun 24, 2016 at 6:08
Narendrasingh Sisodia
21.4k6 gold badges51 silver badges54 bronze badges
Comments
Try this:
$sql = "SELECT * FROM products WHERE color IN ('".implode("','", $color)."')";
Comments
Use It like this:
$sql = "select * from products where color IN ('".implode("','", $color)."')";
Comments
While using ' around implode and "','" as a glue works like a charm in this situation you can also use array_map to surround each value of the array with ' and then implode with simple ,
$color = ['red', 'green', 'blue'];
$string = implode(
',',
array_map(
function ($value) {
return "'{$value}'";
},
$color
)
);
echo $string; // => 'red','green','blue'
It might be overkill in this case and it may be a little slower than other answers.
'".implode("','", $color)."';// output 'red','green','blue'