Add quotation marks to comma delimited string in PHP

php string comma delimited quotation-marks
Per picture Per · Oct 7, 2012 · Viewed 11.9k times · Source

I have a form which is a select multiple input which POSTs values like this: option1,option2,option3 etc..

How is the best way to convert this to 'option1','option2','option3' etc...

Currenty I'm doing this, but it feels wrong??

$variable=explode(",", $variable);
$variable=implode("','", $variable);

The reason why I'm doing this is because I want to use the form select multiple inputs in a SQL Query using IN.

SELECT * FROM TABLE WHERE some_column IN ('$variable')

Answer

JRL picture JRL · Oct 7, 2012

You can wrap whatever code in a function to make the "feels wrong" feeling disapear. E.g.:

function buildSqlInClauseFromCsv($csv)
{
        return "in ('" . str_replace(",", "','", $csv) . "') ";
}

Related questions

PHP remove commas from numeric strings

In PHP, I have an array of variables that are ALL strings. Some of the values stored are numeric strings with commas. What I need: A way to trim the commas from strings, and ONLY do this for numeric strings. …

Read More
Cannot work out a php str_replace() to remove comma

In a PHP project, I have: $string = "1,555"; str_replace(',', '', $string); echo $string; //is still 1,555 str_replace does not remove the comma. If I var_dump. I get string(5) "1,555" Any ideas? I just simply need to remove the …

Read More
How do I check if a string contains a specific word?

Consider: $a = 'How are you?'; if ($a contains 'are') echo 'true'; Suppose I have the code above, what is the correct way to write the statement if ($a contains 'are')?

Read More