Take all the names and put comma to separate them

Question

When I get the names and add them to a variable, I can’t separate them with a comma normally.

• has to be by comma and period at the end
• I can’t put each name in line break using

It’s hard to explain, but here’s an example:

while ($listintegrantes = mysqli_fetch_array($query1)) {
        $integrantes = "$integrantes" . $listintegrantes['nome'] . ",";
}

that is, this will show so:

John, Cyrax, john2,

But I want you to stay:

John, Cyrax and john2.

How is it possible to do this?

-SOLUTION

Follow the resolution of the problem posted above, all resolutions are correct, I adapted to my problem to return me my correct objective.

        $query1 = mysqli_query($conexao, $sql1);
        $integrantes = "";
        $i = mysqli_num_rows($query1);
        $x = 1;
        while ($listintegrantes = mysqli_fetch_array($query1)) {
            $integrantes = $integrantes . $listintegrantes['nome'];
            if ($x < $i - 1) {//antes do penultimo
                $integrantes = $integrantes . ", ";
            }elseif($x == $i-1){//penultimo
                $integrantes = $integrantes . " e ";
            }elseif($x == $i){//ultimo
                $integrantes = $integrantes . ".";
            }
            $x++;
        }

follows below the above algorithm feedback: Cyrax, John, Serana and Smigol.

when there is only one member record: Serana.

Answer 1

You can do it like this:

$sinal = ", ";
$size = mysqli_num_rows($query1);
$i = 1;
while ($listintegrantes = mysqli_fetch_array($query1)) 
{
    if($i == $size-1) 
        $sinal = " e ";
    elseif($i == $size) 
        $sinal = ".";

    $integrantes .= $listintegrantes['nome'] . $sinal;
    $i++;
}

Answer 2

Another way would be to simply remove the last element of the array, use implode to place the commas if there is enough name for the separation and then replace the last element back.

    function names( array $names )
    {
        $_names = array_pop( $names );

        if( count( $names ) > 0 )
        return implode( ', ' , $names ) . ' e ' . $_names;

        return 'só ' . $_names;
    }

    // output: só eu
    echo names( ['eu'] );

    // output: eu e tu
    echo names( ['eu' , 'tu' ] );

    // output: eu, tu e ele
    echo names( ['eu' , 'tu' , 'ele' ] );

Answer 3

Another way to do it is to use contrary logic, concatenate the string with e(yes has spaces) and at the end use preg_replace to replace all the e for , except the last one, this control is done with the fourth parameter which is the number of substitutions.

In the example of an array with five elements will become a string with four e, now just know the number of replacements made which is the total of elements minus two which is 3.

Example 1

$itens = 1;
while ($listintegrantes = mysqli_fetch_array($query1)) {
       $integrantes = "$integrantes" . $listintegrantes['nome'] . " e ";
       $itens++;
}

$str = preg_replace('/ e /', ', ', $integrantes, $itens - 2);

Example 2 ideon

$arr = array('john', 'Cyrax', 'john', 'Sonia', 'Sector');
$str = implode(' e ', $arr);
$itens = count($arr);
$str_formatada = preg_replace('/ e /', ', ', $str, count($arr)-2);
echo $str_formatada;

saida : john, Cyrax, john, Sonia e Sector

Answer 4

It could be so:

while ($listintegrantes = mysqli_fetch_array($query1)) {
    $integrantes = "$integrantes" . $listintegrantes['nome'] . ",";
}

$integrantes = rtrim($integrantes, ',') . '.';

Answer 5

Another possible solution to get the position of the last occurrence of the character in the string strrpos and replace substr_replace, example:

$arr = array('john', 'Cyrax', 'john', 'Sonia', 'Sector');
$str = implode(', ',$arr);
$str = substr_replace($str, ' e', strrpos($str,','), 1);
echo $str;

Ideone example