Get values from DB field into an array with PHP

Question

I have a field in my DB that holds value separated by commas like;

$tmp_list = "COB,ISJ,NSJ,"

Now when I fetch that the row, I would like to have them in an array. I have used array($tmp_list) but I get the values in one line only like:

[0] => 'COB,ISJ,NSJ,'

instead of

[0] => 'COB',
[1] => 'ISJ',
[2] => 'NSJ'

All help is appriciated.

karim79 · Accepted Answer · 2010-05-29 18:00:13Z

4

Use explode:

$arr = explode(',', $tmp_list);

If you like, remove the trailing comma using rtrim first:

$arr = explode(',', rtrim($tmp_list, ','));

You can also trim each element if there's a chance of getting any unwanted leading/trailing whitespace in one or more elements (as per @machine's suggestion):

$arr = array_map('trim', explode(',', rtrim($tmp_list, ',')));

edited May 29, 2010 at 18:00

answered May 29, 2010 at 17:52

karim79

343k67 gold badges420 silver badges408 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PatrikAkerstrand Over a year ago

you might also want to run all elements through the trim-function, in case it's saved with spaces in the database: array_map( 'trim', explode( ',', $tmp_list ) );

Collectives™ on Stack Overflow

Get values from DB field into an array with PHP

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related