Adding single quotes around items in a list

[Michael Sharman]

Is there a PHP function which can add single quotes around each item
in a list?

So if I have:

$myList = "michael,frank,peter,sally,june";

What I want to end up with is:

$myList = "'michael','frank','peter','sally','june'";

I know I can loop over the list and do it manually, I was wondering if
there was a cool function to do it automatically.

I want to add this to the "IN" part of a database "WHERE" clause.

Thanks in advance

[ELINTPimp]

On May 26, 6:48 am, Michael Sharman <[e-mail]:

Is there a PHP function which can add single quotes around each item
in a list?

So if I have:

$myList = "michael,frank,peter,sally,june";

What I want to end up with is:

$myList = "'michael','frank','peter','sally','june'";

I know I can loop over the list and do it manually, I was wondering if
there was a cool function to do it automatically.

I want to add this to the "IN" part of a database "WHERE" clause.

Thanks in advance

Use array_walk and implement the change in a callback function.
http://us3.php.net/manual/en/function.array-walk.php
<?php

//modified $myList to make it an actual array
$myList = array("michael","frank","peter","sally","june");

function addWrapper (&$value, $key, $wrapper) {
$value = $wrapper.$value.$wrapper;
//no return, passed by reference
}

array_walk($myList, 'addWrapper', "'");
print_r($myList);
?>

[sheldonlg]

Michael Sharman wrote:

Is there a PHP function which can add single quotes around each item
in a list?

So if I have:

$myList = "michael,frank,peter,sally,june";

What I want to end up with is:

$myList = "'michael','frank','peter','sally','june'";

I know I can loop over the list and do it manually, I was wondering if
there was a cool function to do it automatically.

I want to add this to the "IN" part of a database "WHERE" clause.

Thanks in advance

I haven't tested it, but you might try this:

IN "('" . str_replace(",", "','", $myList) . "')"

for the IN part of the WHERE clause.

[Michael Fesser]

..oO(Michael Sharman)

>Is there a PHP function which can add single quotes around each item
in a list?

So if I have:

$myList = "michael,frank,peter,sally,june";

What I want to end up with is:

$myList = "'michael','frank','peter','sally','june'";

I know I can loop over the list and do it manually, I was wondering if
there was a cool function to do it automatically.

You could replace the commas with ',' or use a combination of explode()
and implode():

$myList = "'".str_replace(",", "','", $myList)."'";

or

$myList = "'".implode("','", explode(",", $myList))."'";

HTH
Micha

[Michael Sharman]

On May 26, 9:14 pm, Michael Fesser <[e-mail]:

.oO(Michael Sharman)

Is there a PHP function which can add single quotes around each item
in a list?

So if I have:

$myList = "michael,frank,peter,sally,june";

What I want to end up with is:

$myList = "'michael','frank','peter','sally','june'";

I know I can loop over the list and do it manually, I was wondering if
there was a cool function to do it automatically.

You could replace the commas with ',' or use a combination of explode()
and implode():

$myList = "'".str_replace(",", "','", $myList)."'";

or

$myList = "'".implode("','", explode(",", $myList))."'";

HTH
Micha

Thanks all for the great ideas, I ended up going with:

IN('" . str_replace(",", "','", $myList) . "')"

That was the simplest for what I was doing.

[sheldonlg]

Michael Sharman wrote:

On May 26, 9:14 pm, Michael Fesser <[e-mail]:

>.oO(Michael Sharman)

>>Is there a PHP function which can add single quotes around each item
in a list?
So if I have:
$myList = "michael,frank,peter,sally,june";
What I want to end up with is:
$myList = "'michael','frank','peter','sally','june'";
I know I can loop over the list and do it manually, I was wondering if
there was a cool function to do it automatically.

You could replace the commas with ',' or use a combination of explode()
and implode():

$myList = "'".str_replace(",", "','", $myList)."'";

or

$myList = "'".implode("','", explode(",", $myList))."'";

HTH
Micha

Thanks all for the great ideas, I ended up going with:

IN('" . str_replace(",", "','", $myList) . "')"

That was the simplest for what I was doing.

I assume there was a " before the IN or a " followed by the previous
part of the query before the IN.

[Michael Sharman]

On May 27, 4:50 am, sheldonlg <sheldonlgwrote:

Michael Sharman wrote:

On May 26, 9:14 pm, Michael Fesser <[e-mail]:

.oO(Michael Sharman)

>Is there a PHP function which can add single quotes around each item
in a list?
So if I have:
$myList = "michael,frank,peter,sally,june";
What I want to end up with is:
$myList = "'michael','frank','peter','sally','june'";
I know I can loop over the list and do it manually, I was wondering if
there was a cool function to do it automatically.
You could replace the commas with ',' or use a combination of explode()
and implode():

$myList = "'".str_replace(",", "','", $myList)."'";

or

$myList = "'".implode("','", explode(",", $myList))."'";

HTH
Micha

Thanks all for the great ideas, I ended up going with:

IN('" . str_replace(",", "','", $myList) . "')"

That was the simplest for what I was doing.

I assume there was a " before the IN or a " followed by the previous
part of the query before the IN.

There was, sorry...I should have posted the complete source.

Thanks sheldonlg

[Joseph Taylor]

On May 26, 3:48 am, Michael Sharman <[e-mail]:

Is there a PHP function which can add single quotes around each item
in a list?

So if I have:

$myList = "michael,frank,peter,sally,june";

What I want to end up with is:

$myList = "'michael','frank','peter','sally','june'";

I know I can loop over the list and do it manually, I was wondering if
there was a cool function to do it automatically.

I want to add this to the "IN" part of a database "WHERE" clause.

Thanks in advance

This is a bit late, but...

If $my_list is tainted (i.e. it originated from the user) you'd be
wise to escape the list items. I've attached two ways of doing this.
The first uses implode/explode and array_map (I call this the
"functional" approach) and the second uses preg_replace with a
callback.

<?php

$my_list = "michael,frank,peter,sally,june";

// =====================================
// = First Method, Somewhat Functional =
// =====================================

$my_new_list = implode(
',',
array_map(
create_function(
'$a',
'return "\'"
. mysql_real_escape_string($a)
. "\'";'
),
explode(',', $my_list)
)
);

// =============================
// = Second Method, With Regex =
// =============================

$my_newer_list = preg_replace_callback(
'/(^|,)([^,]+)/',
create_function(
'$matches',
'return "$matches[1]\'"
. mysql_real_escape_string($matches[2])
. "\'";'
),
$my_list
);

// ==========
// = Result =
// ==========

echo $my_new_list, "\n", $my_newer_list;

?>

jt