PHP While Loop dealing with last item in loop

Question

I have the following code:

$query6 = "SELECT TIMESTAMP As sDate, COUNT( TIMESTAMP ) AS Total 
           FROM tresults GROUP BY TO_DAYS( timestamp ) ";

$result6 = $mysqli->query($query6);

while($row6 = $result6->fetch_row())
    {
        $dt = new DateTime($row6[0]);
        $sd = $dt->format('M j');

        echo "['".$sd."',  ".$row6[1]."],";

    }

This works fine, but what I am struggling with is that I need the echo to be different the for the last one in the loop. It needs to be (the comma is missing after the ] for reference):

    echo "['".$sd."',  ".$row6[1]."]";

I've been trying to do a count of the number of arrays but cannot get that to work. Any suggestions welcomed.

You could just add them into an array ($yourArray[] = "['".$sd."', ".$row6[1]."]";) then implode(',', $yourArray) after your while statement. — Joe
– Joe, Commented Jun 5, 2014 at 18:16
You could do that but what about much simpler: call substr($sd, 0, -1) after the while? — marekful
– marekful, Commented Jun 5, 2014 at 18:17

souslov · Accepted Answer · 2014-06-05 18:23:42Z

3

You can get the total number of rows and define a counter. After that you can compare them in the loop :

$result6 = $mysqli->query($query6);
$num = $resut6->num_rows;
$i = 0;
while($row6 = $result6->fetch_row())
{
    if($num != $i){
       /* code for all elements except the last one*/
    } else {
       /* code for the last element*/
    }
    $i++;
}

Or you can do something like this using implode() :

$final = array();
while($row6 = $result6->fetch_row()){
    $dt = new DateTime($row6[0]);
    $final[] =  "['" . $dt->format('M j') . "',  ".$row6[1]."]";
}
echo implode(', ', $final);

edited Jun 5, 2014 at 18:23

answered Jun 5, 2014 at 18:17

souslov

44.7k11 gold badges92 silver badges113 bronze badges

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

1 Comment

Homer_J Over a year ago

Perfect (small change to variable need from $resukt6 to $result6!

Collectives™ on Stack Overflow

PHP While Loop dealing with last item in loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related