PHP - Split a String into parts with quote marks

Question

I have a string such as this "$names = "name1,name2".

I am going to be writing these names into an SQL IN statement such as "... IN('name1','name2')";

How can I seperate the "name1,name2" into 'name1' , 'name2'?

This is essential for the SQL statement to work correctly.

`php explode string` query will show __millions__ of answers. — u_mulder, May 11 '20 at 14:47
thanks guys @Rocky, im really new to PHP. any example code for my situation? — AaronRogers3, May 11 '20 at 14:48
@Rocky ive used explode to get them into an array before. But they do not have the quote marks around them in the array and it does not print correctly into the SQL statement.? — AaronRogers3, May 11 '20 at 14:56
Have a look at https://stackoverflow.com/questions/907806/passing-an-array-to-a-query-using-a-where-clause. — Nigel Ren, May 11 '20 at 15:00

score 1 · Answer 1 · answered May 11 '20 at 16:21

Was able to use explode and implode as described by the comments. Then ran into the problem of a space before one of my first names, where I had to remove the whitespace.

Works 100%!

 foreach ($usernames as $details) {
        $names = $details->meta_value;
        $sortednames = preg_replace('/\s*,\s*/', ',', $names);
        $explodednames = explode(',',$sortednames);
        echo "explodednames".$explodednames;
        $implodednames = implode("','",$explodednames);
        }

PHP - Split a String into parts with quote marks

1 Answers1