I need help converting an array to a string to use it in a sql statement

Asked Jun 25 '19 at 21:25

Active Jun 25 '19 at 21:28

Viewed 103 times

I need help converting this array to a string

$thingOne = connecting::query('SELECT thing1 FROM accounts WHERE username=:user_name', array(':user_name'=>$user_name));

So I can use it in this statement

$thing= connecting::query('SELECT * FROM accounts WHERE thing1=:thingOne AND username!=: user_name,                 array(':thingOne'=>$thingOne),array(':user_name'=>$ran_dom));

I'm just trying to get all occurrences of thingOne in the accounts table where it's not the same user.

I've already tried using var_export, and json_encode, and they both don't convert it when I print it after using those functions, I still get the raw array data whether using print_r or echo. And when I use implode nothing prints. I am really confused where to go from here.

edited Jun 25 '19 at 21:28

sticky bit

36,626
12
31
42

asked Jun 25 '19 at 21:25

Ammanuel

2

Possible duplicate of [Passing an array to a query using a WHERE clause](https://stackoverflow.com/questions/907806/passing-an-array-to-a-query-using-a-where-clause) – sticky bit Jun 25 '19 at 21:30
thanks i'll check it out – Ammanuel Jun 25 '19 at 21:39
In the second example you are missing quote `'` – Dharman Jun 25 '19 at 22:19
idk that link isn't working for me – Ammanuel Jun 26 '19 at 19:29
Instead of using that join function since it doesn't return anything I'm using json_encode like this : $stringOne = json_encode($thingOne); – Ammanuel Jun 26 '19 at 20:39
and then I use the In clause like this : $matchThing = connecting::query('SELECT * FROM accounts WHERE thing1 IN("$stringOne")'); – Ammanuel Jun 26 '19 at 20:40

I need help converting an array to a string to use it in a sql statement

0 Answers0