how to loop data from database separated with comma in php

Question

I have a variable called $to. I want this variable to contain data separated by a comma like below:

$to='[email protected], [email protected]';

If there is only one email there will no comma; if there are multiple emails there will not be a comma after the last email.

You can use group_concat if you like to concatenate column values in mysql. — informer
– informer, Commented Jul 26, 2017 at 9:43

B. Desai · Accepted Answer · 2017-07-26 09:49:36Z

4

You can use explode to convert it into array. Then you can traverse from array

<?php
 $to='[email protected], [email protected]';
 $to_array = explode(",", $to);
 foreach ($to_array as $key => $value) {
   echo $value;
 }

If you want to do opposite you can use implode

$to_array = array('[email protected]', '[email protected]');
$to = implode(",",$to_array);
echo $to;

edited Jul 26, 2017 at 9:49

answered Jul 26, 2017 at 9:44

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

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

2 Comments

Tobias F. Over a year ago

This is the opposite of what the OP asks for. The goal is to get the string with the values, not to split them.

B. Desai Over a year ago

@TobiasF. read question heading. OP asked for how to loop data from database seperated with coma in php which I have explain. BTW I have edited both

gaurang vyas · Accepted Answer · 2017-07-26 09:45:13Z

2

try 
    $result = implode(',',$to);

answered Jul 26, 2017 at 9:45

gaurang vyas

669 bronze badges

Comments

Mohammad · Accepted Answer · 2017-07-26 09:47:26Z

2

use implode()

for example:

$emails = ["[email protected]","[email protected]","[email protected]"];

$to = implode(',',$a);

answered Jul 26, 2017 at 9:47

Mohammad

3,5576 gold badges50 silver badges77 bronze badges

Comments

Lucarnosky · Accepted Answer · 2017-07-26 09:57:50Z

1

You can save all your eMails address in an array and then you can implode it with comma, it automatically handle all the cases

$addresses= array()
$addresses[] = '[email protected]';
$addresses[] = '[email protected]';
$to = implode(",",$addresses);

You will find in $to all your addresses separated by comma except the last one

answered Jul 26, 2017 at 9:57

Lucarnosky

5145 silver badges19 bronze badges

Collectives™ on Stack Overflow

how to loop data from database separated with comma in php

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related