php mysql query strings array

Question

i am building a string that i check in mysql db.

eg:
formFields[] is an array - input1 is: string1
array_push(strings, formFields)
1st string and mysql query looks like this:
"select * from my table where id in (strings)"

formFields[] is an array - input2 is: string1, string2
array_push(strings, formFields)
2nd string and mysql query looks like this:
"select * from my table where id in (strings)"

formFields[] is an array - input3 is: string1, string2,string3
array_push(strings, formFields)
3rd string and mysql query looks like this:
"select * from my table where id in (strings)"

i will like to add single quotes and a comma to the array so that i have this for the array strings: "select * from my table where id in ('string1', 'string2','string3')"

i tried using array implode, but still no luck any ideas? thanks

score 7 · Accepted Answer · answered Apr 14 '10 at 13:37

7

'SELECT ... WHERE id IN ("' . implode('","', $strings) . '")';

answered Apr 14 '10 at 13:37

hsz

148,279
62
259
315

Works really well! I want to ask a question, what are the dots exactly doing, are they acting like "+" to glue the quotes with the implode result? – deckoff Oct 29 '12 at 20:44

score 1 · Answer 2 · answered Apr 14 '10 at 13:41

1

implode() is the solution but you shouldn't forget about escaping data:

$data = array(...);
array_walk($data, function(&$elem, $key) {
    $elem = mysql_real_escape_string($elem);
});
$sql = 'SELECT ... id IN ("' . implode('", "', $data) . '");';

answered Apr 14 '10 at 13:41

Crozin

43,890
13
88
135

score 0 · Answer 3 · answered Apr 14 '10 at 13:37

0

implode("','",$array);

answered Apr 14 '10 at 13:37

Your Common Sense

156,878
40
214
345

this doesn't add a quote before and after the very beginning and end of the strings. thanks anyway! – NULL Apr 14 '10 at 13:51
@Chocho you don't know concatenation too? You desperately need basic PHP classes then. – Your Common Sense Apr 15 '10 at 06:12

php mysql query strings array

3 Answers3