how to parsing array to MYSQL IN()?

Question

I'm have a problem when I want to query to the database , in this case I want to using IN() mysql function for searching data by value field on array.

example I have array from php

$data = array(1,2,3,4);

and this is my query code to selection data on table Employee

$query = 'SELECT * FROM employee_tbl 
    -> WHERE daily_typing_pages IN ' .$data.;

when I'm execute that code I have error like this

Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array 
SELECT * FROM employee_tbl 
        -> WHERE daily_typing_pages IN Array;

I think that error is come because Array read as string,and don't parse to this format (1,2,3,4)

how i can convert to that format ? any suggestion?

Amber · Accepted Answer · 2012-10-08 03:55:48Z

2

Use implode() to create an actual comma-separated list of items as a string.

$query = 'SELECT * FROM employee_tbl 
    -> WHERE daily_typing_pages IN (' . implode(",", $data) . ")";

answered Oct 8, 2012 at 3:55

Amber

531k89 gold badges643 silver badges558 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Woo · Accepted Answer · 2012-10-08 03:58:41Z

2

Try,

$data = array(1,2,3,4);
$ids = join(',',$data);  
$sql = "SELECT * FROM employee_tbl WHERE daily_typing_pages IN ($ids)";

answered Oct 8, 2012 at 3:58

John Woo

265k70 gold badges509 silver badges500 bronze badges

Comments

Burhan Khalid · Accepted Answer · 2012-10-08 03:56:28Z

1

Use implode()

$x = array(1,2,3,4);
$y = implode(',',$x);

answered Oct 8, 2012 at 3:56

Burhan Khalid

175k20 gold badges254 silver badges291 bronze badges

Comments

Burhan Khalid · Accepted Answer · 2012-10-08 04:13:21Z

1

Try this code, use implode() to converts array into string

 $query = "SELECT * FROM employee_tbl 
        -> WHERE daily_typing_pages IN  ( ".implode(',',$data)." ) ";

edited Oct 8, 2012 at 4:13

Burhan Khalid

175k20 gold badges254 silver badges291 bronze badges

answered Oct 8, 2012 at 3:56

iLaYa ツ

4,0173 gold badges34 silver badges51 bronze badges

Collectives™ on Stack Overflow

how to parsing array to MYSQL IN()?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related