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 1 · Accepted Answer · answered Mar 14 '14 at 07:04

1

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

Thanks abhik its working. – Senthilkumar Mar 14 '14 at 07:08
You are most welcome !! – Abhik Chakraborty Mar 14 '14 at 07:08
@Senthilkumar please accept this answer as accepted so it will be marked as solved – Dimag Kharab Mar 14 '14 at 07:14

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

0

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