PHP Change array to string

Question

I have an array come back from a query but I want to change it to a string for another db query

$test = $go->get_stuff();
$test = array(
    'ONE',
    'TWO',
    'THREE',
    'FOUR'
)

// expected outcome
$sql .= "(table.col IN ('ONE', 'TWO', 'THREE', 'FOUR') OR table.col IS NULL)";

Please, please, please: use prepared statements. Don't just string together queries: Injection is very real, and very common — Elias Van Ootegem, Oct 02 '14 at 14:39
It also sounds like what you REALLY want is to join two tables together - unning a query, getting an array, and then running another query on that array - just use a JOIN in your SQL. — TML, Oct 02 '14 at 14:41
Seems to me like you could use a `JOIN` here rather than creating two queries? — George, Oct 02 '14 at 14:41
This is an accident waiting to happen. As someone else already pointed out; prepare your queries. Don't just blatantly put text straight into your queries. — Coreus, Oct 02 '14 at 14:53

score 2 · Answer 1 · answered Oct 02 '14 at 14:36

2

Use implode() but also be sure to preppend and append a single quote as well:

$string = "'" . implode("','", $test) . "'";
// 'ONE', 'TWO', 'THREE', 'FOUR'

answered Oct 02 '14 at 14:36

John Conde

217,595
99
455
496

score 1 · Answer 2 · edited May 23 '17 at 12:13

This question has been answered before here: How to convert array to a string using methods other than JSON?

Essentially, you will need to use the implode function for your data set.

$test = $go->get_stuff();
$test = array(
    'ONE',
    'TWO',
    'THREE',
    'FOUR'
)

// Implode array to string
$string = "'" . implode("','", $test) . "'";
// Deliver desired output
$sql .= "(table.col IN (".$string.") OR table.col IS NULL)";

score 0 · Accepted Answer · answered Oct 02 '14 at 14:36

0

Implode the array:

$str = "'" . implode("', '", $test) . "'";

Then you can add it to your SQL:

$sql .= "(table.col IN ($str) OR table.col IS NULL)";

answered Oct 02 '14 at 14:36

danmullen

2,556
3
20
28

1

You're missing the quotes – John Conde Oct 02 '14 at 14:37
1

@danmullen this will result in `ONE, TWO, THREE, FOUR` (missing quotes) – andrew Oct 02 '14 at 14:40
Thanks knew I had to use implode but just couldnt figure out getting the quotes in – Pierce McGeough Oct 02 '14 at 15:30

score 0 · Answer 4 · answered Oct 02 '14 at 14:38

0

Use implode(). Try this..

$in = "'".implode("','", $test)."'";
$sql .= "(table.col IN (".$in.") OR table.col IS NULL)";

answered Oct 02 '14 at 14:38

MH2K9

11,951
7
32
49

score 0 · Answer 5 · answered Oct 02 '14 at 14:38

0

Another way would be to foreach and rtrim: foreach($test as $v) { $str .= "'$v',"; } $str = rtrim($str, ',');

answered Oct 02 '14 at 14:38

TML

12,813
3
38
45

score 0 · Answer 6 · answered Oct 02 '14 at 14:38

0

You can do that with "implode" function.

Try this:

$test = $go->get_stuff();
$test = array(
    'ONE',
    'TWO',
    'THREE',
    'FOUR'
)

// expected outcome
$sql .= "(table.col IN ('".implode("','", $test)."') OR table.col IS NULL)";

answered Oct 02 '14 at 14:38

Rodrigo Techera

251
1
9

PHP Change array to string

6 Answers6