Remove the last comma from an array of a While

Question

I’m trying to remove the last comma from an Array but I’m not getting it.

I have a CSV file in which I read and remove an array with a code to be used in a Where of a Query sql. I’m using substr($number_Aut,0,-1) but it’s not working.

Follows the code:

<?
while(! feof($CSVfp)) {
    $data = fgetcsv($CSVfp, 1000, ";");


    $number_Aut =  "'$data[13]','"; //Pego o código desejado no arquivo CSV e adiciono Aspas simples e virgula
    if ($data[13] != '') { //Verifico se entre as aspas não tem campos Vazios
    echo substr($number_Aut,0,-1); //Elimino a ultima virgula do ARRAY MAS NÃO ESTÁ FUNCIONANDO
}


?>
<tr>
<td align="center"><?php echo date('d/m/Y', strtotime($data[4])); ?></td>
<td align="center"><?php echo $data[11]; ?></td>
<td align="center"><?php echo $data[13]; ?></td>
<td align="center"><?php echo $data[2]; ?></td>
<td align="center"><?php echo $data[9]; ?>/<?php echo $data[10]; ?></td>
<td align="center"><?php echo number_format( $data[8], 2, ',', '.'); ?></td>
<td align="center"><?php echo number_format( $data[17], 2, ',', '.'); ?></td>
</tr>
<?php


    }
?>

Answer 1

If I understand correctly your problem is only to delete a comma at the end of the string if that’s all you try:

rtrim($number_Aut,',')

But by your code I believe you have to take out the ' too, because you’re adding comma and quotes:

rtrim(rtrim($number_Aut, "'"),",")

Answer 2

When you say in your code comment //I delete the last comma from the ARRAY BUT IT’S NOT WORKING in fact you are eliminating the last simple quotes.

$var="";
if (($handle = fopen("http://dominio.com/Satellite.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
        $num = count($data);
        for ($c=0; $c < $num; $c++) {
             $number_Aut =  "'$data[$c]','"; //Pego o código desejado no arquivo CSV e adiciono Aspas simples e virgula
             if ($data[$c] != '') { //Verifico se entre as aspas não tem campos Vazios
              $var.= substr($number_Aut,0,-1); //AQUI ESTÁ ELIMINANDO UMA ASPA SIMPLES
             }
        }
    }
    fclose($handle);
}

$var= substr($var,0,-1); //AQUI ELIMINA A ULTIMA VIRGULA
echo $var;

The Satellite.csv file is as shown in the figure below: