to find a value within the array in mysql

Question

i want to search data in an array .How can i search using mysql select command. i wrote the query as

$this->db->query("SELECT * FROM client_details WHERE dob IN ({implode(',', $data})");

$data is an array of dates .Please Help me for solving this..

Error Number: 1064 Erreur de syntaxe prÃ¨s de '})' Ã la ligne 1 SELECT * FROM client_details WHERE dob IN ({implode(',', 03/03/2015}) error showing like this — Fiona
– Fiona, Commented Mar 18, 2015 at 10:27
You have to properly escape the string, use mysql_real_escape_string — Pankaj katiyar
– Pankaj katiyar, Commented Mar 18, 2015 at 10:29

Pankaj katiyar · Accepted Answer · 2015-03-18 10:58:15Z

2

try with

$data =array('0'=>'2015-01-23','1'=>'2015-01-22','2'=>'2015-01-21');
$tmp = implode('","', $data);
$tmp ='"'.$tmp.'"';
$sql= 'SELECT * FROM client_details WHERE dob IN ('.$tmp.')';
echo $sql;
$this->db->query($sql);

answered Mar 18, 2015 at 10:58

Pankaj katiyar

46410 silver badges26 bronze badges

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

Comments

Prerak Sola · Accepted Answer · 2015-03-18 11:09:45Z

0

You can do something like this:

Option 1

$tmp = implode(',', $data);
$this->db->query("SELECT * FROM client_details WHERE dob IN ($tmp)");

Option 2

$this->db->query("SELECT * FROM client_details WHERE dob IN (".implode(',', $data).")");

Also, there is a mistake in your bracket formation.

It should be dob IN ({implode(',', $data)}"); [Curly braces should close after the closing parenthesis].

edited Mar 18, 2015 at 11:09

answered Mar 18, 2015 at 10:28

Prerak Sola

10.1k8 gold badges40 silver badges77 bronze badges

17 Comments

Fiona Over a year ago

Severity: Warning Message: implode(): Invalid arguments passed ..showing this error

Fiona Over a year ago

Error Number: 1064 Erreur de syntaxe prÃ¨s de ')' Ã la ligne 1 SELECT * FROM client_details WHERE dob IN () and also this error showing

Fiona Over a year ago

03/03/201504/13/201505/11/201506/08/201509/04/201512/06/201503/08/201606/09/201609/10/201603/01/201703/01/201902/27/202702/29/202003/18/201504/28/201505/26/201506/23/201509/19/201512/21/2

Fiona Over a year ago

$data values are this

Prerak Sola Over a year ago

Try removing { } from your initial query. And what is the datatype of your dob column?

|

Collectives™ on Stack Overflow

to find a value within the array in mysql

2 Answers 2

Comments

17 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

17 Comments

Your Answer

Sign up or log in

Post as a guest

Related