How to use array variable into mysql query in php/mysql

Question

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);

score 2 · Accepted Answer · answered Mar 14 '14 at 07:04

2

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 '14 at 07:04

Abhik Chakraborty

@Senthilkumar please accept this answer as accepted so it will be marked as solved – Dimag Kharab Mar 14 '14 at 07:14

score 1 · Answer 2 · answered Mar 14 '14 at 07:05

1

use JOIN or IMPLODE

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

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

answered Mar 14 '14 at 07:05

Dimag Kharab

2 Answers2