PHP add single quotes to comma separated list

Question

When I implode my array I get a list that looks like this:

qwerty, QTPQ, FRQO

I need to add single quotes so it looks like:

'qwerty', 'QTPQ', 'FRQO'

Can this be done using PHP?

First try to implode your array into this format: `qwerty', 'QTPQ', 'FRQO` then you can add the quotes at the start and the end — Rizier123, Dec 23 '15 at 17:12
You could do a search and replace... where "," replace with "', '". — durbnpoisn, Dec 23 '15 at 17:13

score 104 · Accepted Answer · answered Dec 23 '15 at 17:32

104

Use ' before and after implode()

$temp = array("abc","xyz");

$result = "'" . implode ( "', '", $temp ) . "'";

echo $result; // 'abc', 'xyz'

answered Dec 23 '15 at 17:32

Ypages Onine

1,262
1
8
8

score 20 · Answer 2 · answered Jan 14 '18 at 20:03

Here is another way:

$arr = ['qwerty', 'QTPQ', 'FRQO'];

$str = implode(', ', array_map(function($val){return sprintf("'%s'", $val);}, $arr));

echo $str; //'qwerty', 'QTPQ', 'FRQO'

sprintf() is a clean way of wrapping the single quotes around each item in the array

array_map() executes this for each array item and returns the updated array

implode() then turns the updated array with into a string using a comma as glue

score 9 · Answer 3 · answered Aug 17 '20 at 14:41

9

It can also be as short as this:

sprintf("'%s'", implode("', '", $array))

answered Aug 17 '20 at 14:41

Gale Yao

133
1
10

Simple enough and worked great for me!!! – Umar Niazi Feb 25 '23 at 09:52

score 5 · Answer 4 · answered Dec 23 '15 at 17:14

5

You can set the glue to ', ' and then wrap the result in '

$res = "'" . implode ( "', '", $array ) . "'";

http://codepad.org/bkTHfkfx

answered Dec 23 '15 at 17:14

Musa

96,336
17
118
137

score 1 · Answer 5 · answered Dec 23 '15 at 17:20

Similar to what Rizier123 said, PHP's implode method takes two arguments; the "glue" string and the "pieces" array.

so,

$str = implode(", ", $arr);

gives you the elements separated by a comma and a space, so

$str = implode("', '", $arr);

gives you the elements separated by ', '.

From there all you need to do is concatenate your list with single quotes on either end.

score 1 · Answer 6 · answered Nov 20 '19 at 14:00

1

    $ids = array();
    foreach ($file as $newaarr) {
        array_push($ids, $newaarr['Identifiant']);

    }
   $ids =array_unique($ids);
    //$idAll=implode(',',$ids);

     $idAll = "'" . implode ( "', '", $ids ) . "'";

answered Nov 20 '19 at 14:00

Ashish Pathak

827
8
16

1

Please add some explanation to your code such that others can learn from it – Nico Haase Nov 20 '19 at 16:39

score 1 · Answer 7 · edited May 23 '22 at 04:21

1

You can use the method called 'implode' in the PHP. That will help you to concatenate all the array values with th given delimiter.

$arr = ['qwe', 'asd', 'zxc'];
echo implode(',', array_map(function($i){return "'".$i."'";}, $arr));

You output will be something like below:

'qwe','asd','zxc'

edited May 23 '22 at 04:21

Punit Gajjar

4,937
7
35
70

answered May 22 '22 at 21:37

1rx

43
1
5

score 0 · Answer 8 · answered Dec 28 '20 at 09:15

function implode_string($data, $str_starter = "'", $str_ender = "'", $str_seperator = ",") {
    if (isset($data) && $data) {
        if (is_array($data)) {
            foreach ($data as $value) {
                $str[] = $str_starter . addslashes($value) . $str_ender . $str_seperator;
            }
            return (isset($str) && $str) ? implode($str_seperator, $str) :  null;
        }
        return $str_starter . $data . $str_ender;
    }
}

PHP add single quotes to comma separated list

8 Answers8

Linked