SQL+PHP: how can i return all PHP array existed values from SQL table?

Question

Hello All

I have a simple php array, For Example:

$numbers=array("12345","65432","98765");

And SQL Table named: "phones" with the column "TNumbers" and the rows: 654654, 12345, 87878.

Now, What will be the fastest way to return all the values from the array that exist in the SQL server table? (So it should return only this: ("12345"))

Thank you Very Much!!

[What have you tried?](http://www.whathaveyoutried.com/) See [ask advice](http://stackoverflow.com/questions/ask-advice), please. — John Conde, Feb 20 '13 at 16:09
use IN clause in your sql, set into it implode(',', $numbers) — sanj, Feb 20 '13 at 16:13
@LukasKnuth thanks for the info, I always thought of w3schools being an official W3C website. I just used the first result for the google search "sql in". — Misch, Feb 21 '13 at 10:40

score 0 · Accepted Answer · answered Feb 20 '13 at 16:16

0

After some more search i have found the answer, Sorry for that:

$ids = join(',',$numbers);  
$sql = "SELECT * FROM phones WHERE TNumbers IN ($ids)";

Thank you anyway!

answered Feb 20 '13 at 16:16

Eran Levi

877
2
12
31

this is prone to SQL injections, so make sure that your `$numbers` array doesn't contain malicious code! – Misch Feb 20 '13 at 16:33

SQL+PHP: how can i return all PHP array existed values from SQL table?

1 Answers1