删除php-mysql中foreach查询中的最后一个逗号 - Removing last comma in the foreach query in php mysql

Removing last comma in the foreach query in php mysql

我使用foreach循环从数据库中回显一些值，并用逗号分隔每个值，但最后用逗号分隔我们如何删除

echo $string='"paymentmethods":';
echo $string='"Bank":[';
$sql2 = "SELECT  * FROM paymentmethods where cid=587 ";
$query = $this->db->query($sql2);
foreach ($query->result() as $row){
       echo '{';
       echo $string = 'accname:'.$row->acc.',' ;
       echo $string = 'country:'.$row->IBAN.',' ;
       echo $string = 'Iban:'.$row->Bankname.',' ;
       echo $string = 'Bankname:'.$row->Bankname.',' ;
       echo $string = '},';  
}  
echo $string = '],';
"paymentmethods":"Bank":[{accname:0034430430012,country:AE690240002520511717801,Iban:ARABIC BANK NAME,Bankname:ARABIC BANK NAME,},{accname:0506796049,country:DE690240002520511717801,Iban:ARABIC BANK NAME,Bankname:ARABIC BANK NAME,},]

这里看到逗号在名称结束后重复。以及括号结束后

逗号之所以存在，是因为您已经在代码中写入了它。将行更改为：

 // same as above
 echo $string = 'Bankname:'.$row->Bankname. ;
       echo $string = '}';  
}  
echo $string = ']';

一种常见的方法是这样做：

$sep = '';
$result = '';
foreach($myarray as $value) {
    $result .= $sep.$value;
    $sep = ',';
}

这样，就没有了逗号的开头或结尾。但正如评论所说，你正在自己做一个"json_encode"。。。您应该使用jsonencode/decode。