Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Looping For in PHP (add , into array) [duplicate]

This is my code :

$query = mysql_query("SELECT * FROM `member` ORDER BY Code");
$fieldNum = mysql_num_fields($query);
for($q=0; $q<$fieldNum; $q++){
    $value = "'value$q'";
    echo "$value";
    echo ",";
}

I want the output
value0,value1,value2, ... ,value5
but I got the output
value0,value1,value2, ... ,value5,

I want to delete a last comma, what should I do?

like image 819
Danti Iswandhari Avatar asked Nov 16 '25 04:11

Danti Iswandhari


2 Answers

Simple way

$value = array();
for($q=0;$q<$fieldNum;$q++){
        $value [] = 'value'.$q;
      }
echo implode (',', $value);

http://php.net/manual/en/function.implode.php

like image 181
Thesee Avatar answered Nov 18 '25 20:11

Thesee


One possibility:

for($q=0; $q<$fieldNum; $q++){
    $value = "'value$q'";
    echo "$value";
    if ($q != $fieldNum - 1) echo ",";
}
like image 45
Berriel Avatar answered Nov 18 '25 19:11

Berriel