Create SQL from array

Question

I'm trying to create a SQL Query that gets data from my DB depending on what the array includes.

Example:

My array includes 1, 2, 3 then the query should be SELECT * FROM v WHERE category='1' OR category='2' OR category='3'.

Does anyone know a way to achieve this?

Any tips are welcome.

UPDATE:

Using MySQL as DB.

are you not getting desired result as per your given query ? — Hamza Zafeer
– Hamza Zafeer, Commented Jun 24, 2016 at 13:41
@HamzaZafeer The query should work. I just need some help creating the query from my array — Chris
– Chris, Commented Jun 24, 2016 at 13:42

Saty · Accepted Answer · 2016-06-24 13:40:18Z

4

You can use implode function and IN clause as

$sql="SELECT * FROM v WHERE category IN ('".implode("','", $your_array)."')";

answered Jun 24, 2016 at 13:40

Saty

22.5k7 gold badges35 silver badges52 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:08:26Z

2

I would take a look at https://stackoverflow.com/a/14767572/755949, which uses placeholders and PDO to add the parameters to your query. Going with Saty's answer you could risk ending up with a SQL injection.

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Jun 24, 2016 at 13:45

Rob

2,6763 gold badges25 silver badges42 bronze badges

3 Comments

Chris Over a year ago

I'm using PDO at my DB class. All data is sanitized

Rob Over a year ago

FYI I don't know how you santize the data. If you concat a SQL query, with unsantized data, and pass that query to PDO then PDO won't do any sanitizing for you.

Chris Over a year ago

The DB class sanitizes the data.

newage · Accepted Answer · 2016-06-24 13:45:55Z

0

$where = 'WHERE category="' . implode('" OR category="', $array) . '"';

answered Jun 24, 2016 at 13:45

newage

9097 silver badges18 bronze badges

Comments

HarisH Sharma · Accepted Answer · 2016-06-24 15:35:45Z

0

You can also try:

$sql = "SELECT * FROM v WHERE ( FIND_IN_SET(".implode("','", $your_array).", category) ) ";

For more info about FIND_IN_SET: http://www.w3resource.com/mysql/string-functions/mysql-find_in_set-function.php

answered Jun 24, 2016 at 15:35

HarisH Sharma

1,2853 gold badges14 silver badges46 bronze badges

Collectives™ on Stack Overflow

Create SQL from array

4 Answers 4

Comments

3 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

Comments

Comments

Linked

Related