How to use array variable into mysql query in php/mysql [duplicate]

Question

This question already has an answer here:

I have an array variable like this

$variable[] = $data['master_software_capability_id'];

How to use this array variable in SQL query

Is this the right way ?

SELECT * FROM software_capability where software_capability_id IN ($variable);

Abhik Chakraborty · Accepted Answer · 2014-03-14 07:04:00Z

up vote 0 down vote accepted

You need to implode the array to comma separated string

$variables_imploded = implode(",",$variable);

"SELECT * 
FROM software_capability 
where software_capability_id IN 
(".$variables_imploded.")";

answered Mar 14 at 7:04

Abhik Chakraborty
4,7831417

Thanks abhik its working. – Senthilkumar Mar 14 at 7:08

You are most welcome !! – Abhik Chakraborty Mar 14 at 7:08

@Senthilkumar please accept this answer as accepted so it will be marked as solved – CodingAnt Mar 14 at 7:14

CodingAnt · Answer 2 · 2014-03-14 07:05:02Z

up vote 0 down vote

use JOIN or IMPLODE

$variables_joins = join(',',$variable);  

SELECT * FROM software_capability where software_capability_id IN ($variables_joins);

answered Mar 14 at 7:05

CodingAnt
51919

Edd A. · Answer 3 · 2014-03-14 07:05:20Z

up vote 0 down vote

You can implode the array first.. like implode(',',$variable)

"SELECT * FROM software_capability where software_capability_id IN (" . implode(',',$variable)  . ")"

answered Mar 14 at 7:05

Edd A.
887

Thanks Edd A. its working – Senthilkumar Mar 14 at 7:08

Great.. Happy to help! – Edd A. Mar 14 at 7:19

marked as duplicate by Shankar Damodaran, Rikesh, Liath, giammin, Sheridan Mar 14 at 8:52