Check to see if database contains array values

Question

I am new to writing server code, anyway I have a SQL DB that contains a list of numbers, I am wanting to check to see if an array that contains a list of numbers has any overlap with the DB.

Database:
ID  Number
1    3
2    5
3    7
4    11
5    13
6    19

For example, in PHP/psuedocode:

$numbers = $_REQUEST['NUMBERS']  // array of numbers i.e. [3, 7, 20, 54]

This is what I'm looking for:

echo json_encode($result) // returns [3, 7]

iivannov · Accepted Answer · 2013-12-15 19:16:12Z

1

Just do a query selecting the rows containing the numbers from the request:

$numbers = implode(',', $_REQUEST['NUMBERS']);
$query = "SELECT Number FROM TableName WHERE Number IN ($numbers)";

edited Dec 15, 2013 at 19:16

answered Dec 15, 2013 at 19:06

iivannov

4,3961 gold badge20 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Check to see if database contains array values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related