removing last record comma

Question

I want to remove the last record comma from fetched value. I used $album1 = substr($album,0,-1); to remove last character comma from the value `$ album'. I caught:

SyntaxError: Unexpected token ,'

Whats wrong with this in substr()?

$album = {"media_type":"image/png","pic_id":"zhadb"},
         {"media_type":"image/png","pic_id":"zhadb"},
         {"media_type":"image/video","pic_id":"kg5k4"},

while($fet_pic=mysql_fetch_array($albpic)) {  
    $album.=$fet_pic['CONTENT_VALUE'].',';
}

$album1 = substr($album,0,-1);

score 1 · Answer 1 · answered Nov 24 '15 at 07:08

1

use PHP rtrim Strip whitespace (or other characters) from the end of a string

rtrim($album, ",")

Full code

<?php 
$album = '{"media_type":"image/png","pic_id":"zhadb"},
         {"media_type":"image/png","pic_id":"zhadb"},
         {"media_type":"image/video","pic_id":"kg5k4"},';

         echo rtrim($album, ",");

Demo

answered Nov 24 '15 at 07:08

Abhishek Sharma

6,689
1
14
20

my $album={"media_type":"image/png","pic_id":"zhadb"}, {"media_type":"image/png","pic_id":"zhadb"}, {"media_type":"image/video","pic_id":"kg5k4"}, – user3386779 Nov 24 '15 at 07:32
is any other solution to do – user3386779 Nov 24 '15 at 07:32

score 0 · Answer 2 · answered Nov 24 '15 at 07:01

0

you can uses trim to remove last comma from the string

like this

$album1 = trim($album, ',');

answered Nov 24 '15 at 07:01

Snehal S

865
4
13

rtrim or trim. both should work – Snehal S Nov 24 '15 at 07:03
still having problem – user3386779 Nov 24 '15 at 07:06
where is it causing problem? check the line number and whether that issue is same? – Snehal S Nov 24 '15 at 07:08

score 0 · Answer 3 · answered Nov 24 '15 at 07:03

0

Try with following code :

$rows = array();
while($fet_pic=mysql_fetch_array($albpic))
{  
    $rows[] = $fet_pic['CONTENT_VALUE'];
}
$album = implod(", ",$rows);

answered Nov 24 '15 at 07:03

ranakrunal9

13,320
3
42
43

removing last record comma

3 Answers3