fetch the value as array value

Question

I want to fetch the records and display as array.select * from album_comment where SUB_ID='$id' displays the row as displayed in image.

 $sql = "select * from album_comment where SUB_ID='$id'";
$query = mysql_query($sql) or sqlerrorhandler("(" . mysql_errno() . ") " . mysql_error(), $sql, __LINE__);
while ($comment_fet = mysql_fetch_assoc($query)) {
     $content = $comment_fet['CONTENT_VALUE'];
    $datas = json_decode($content);
 }
 echo $get_like = json_encode($content);

I want to fetch the value as

$datas=[{"name":"hello","commentuser":"desc 259 desc","id":8,"date":"2015-12-09T05:40:12.773Z","displayDate":"Wed Dec 09 2015 11:10:12 GMT+0530 (India Standard Time)8","Like":0,"Unlike":0,"rating":0,"reportAbuse":0},

{"name":"hnnb","commentuser":"hjh ghj  ghj ghj","id":68,"date":"2015-12-09T06:00:44.718Z","displayDate":"Wed Dec 09 2015 11:30:44 GMT+0530 (India Standard Time)68","Like":0,"Unlike":0,"rating":0,"reportAbuse":0},

{"name":"56844","commentuser":"689 498 4849 48","id":45,"date":"2015-12-09T06:03:03.178Z","displayDate":"Wed Dec 09 2015 11:33:03 GMT+0530 (India Standard Time)45","Like":0,"Unlike":0,"rating":0,"reportAbuse":0},

{"name":"dcfg","commentuser":"bbnbvbvbnbb","id":60,"date":"2015-12-09T06:49:10.875Z","displayDate":"Wed Dec 09 2015 12:19:10 GMT+0530 (India Standard Time)60","Like":0,"Unlike":0,"rating":0,"reportAbuse":0}]

Mohit maru · Accepted Answer · 2015-12-09 07:34:47Z

2

Just put $datas[] instead of $datas in while loop.

$sql = "select * from album_comment where SUB_ID='$id'";
$query = mysql_query($sql) or sqlerrorhandler("(" . mysql_errno() . ")      " . mysql_error(), $sql, __LINE__);
while ($comment_fet = mysql_fetch_assoc($query)) {
    $content = $comment_fet['CONTENT_VALUE'];
    $datas[] = json_decode($content);
}
echo $get_like = json_encode($content);

answered Dec 9, 2015 at 7:34

Mohit maru

8238 silver badges15 bronze badges

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

Comments

Niranjan N Raju · Accepted Answer · 2015-12-09 07:26:23Z

1

Change your code like this,

while ($comment_fet = mysql_fetch_assoc($query)) {
    $content = $comment_fet['CONTENT_VALUE'];
    $datas[] = json_decode($content);// capture in array
}
echo $get_like = json_encode($datas);// encode array here

answered Dec 9, 2015 at 7:26

Niranjan N Raju

12k4 gold badges24 silver badges41 bronze badges

Comments

roullie · Accepted Answer · 2015-12-09 07:26:37Z

1

you need to save it all to the array like

$datas = array();
while ($comment_fet = mysql_fetch_assoc($query)) {
    $content = $comment_fet['CONTENT_VALUE'];
    $datas[] = json_decode($content);
}
echo $get_like = json_encode($datas);

answered Dec 9, 2015 at 7:26

roullie

2,82019 silver badges26 bronze badges

Collectives™ on Stack Overflow

fetch the value as array value

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related