Create a string of values from a do/while loop

Question

I am trying to create a php string with integers separated by commas. The values for the string are coming from a do { }while loop. How would I do this?

//GRAB EC DATA
    $mysql_ec_data = "SELECT `ec_c_id` FROM `e_c` WHERE `ec_id` = '$e_id'";
    $query_ec_data = mysql_query($mysql_ec_data) or die(mysql_error());
    $ec_data = mysql_fetch_assoc($query_ec_data);   

    $string = "";           
    do {

        //There will be values looping through here that I want to add to a single string.
        $string =+ $ec_data['ec_id'];               

    } while ($ec_data = mysql_fetch_assoc($query_ec_data)); 
    //this is how the values from the while loop should look in the string at the end
    $string = 45,52,23;

$string .= $ec_data['ec_id'] . ","; ?? this?

Marco Acierno
– Marco Acierno

2014-02-23 18:57:38 +00:00
Commented Feb 23, 2014 at 18:57 — Marco Acierno
– Marco Acierno, Commented Feb 23, 2014 at 18:57

aksu · Accepted Answer · 2014-02-23 18:58:17Z

2

Use this:

$string .= $ec_data['ec_id'] . ', ';

answered Feb 23, 2014 at 18:58

aksu

5,2365 gold badges26 silver badges39 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-17 20:07:23Z

2

You could use $string =+ $ec_data['ec_id'] . ", "; and after the loop remove the last comma with PHP substr method: https://www.php.net/substr

$string = substr($string, 0, -1);

edited Nov 17, 2023 at 20:07

CommunityBot

11 silver badge

answered Feb 23, 2014 at 18:58

GuyT

4,4562 gold badges20 silver badges34 bronze badges

Comments

faintsignal · Accepted Answer · 2014-02-23 19:01:43Z

2

Be careful with your assignment-concatenation operator, in PHP it is .=. A simple way to handle the comma delimiter is to first put the integers in an array and then "glue" them together after the loop:

$string = "";
$integers = array();           
do {
    $intgers[] = $ec_data['ec_id'];               

} while ($ec_data = mysql_fetch_assoc($query_ec_data)); 

if (count($integers)) {
   $string = implode(",", $integers);
}

answered Feb 23, 2014 at 19:01

faintsignal

1,8363 gold badges22 silver badges30 bronze badges

Collectives™ on Stack Overflow

Create a string of values from a do/while loop

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related