PHP JSON Encode: Formatting

Question

I wanted to have an json output format like this

{
    "data":
    [
        ["FAMILY: Isopropyl Alcohol 250ml","32.34"],
        ["AMBROXOL Expel 6mg-mL 15ML Drops","75.04"]

    ]

}

However, it is showing differently as wanted. The first items keeps on replicated. The result is:

{
"data":
[
    ["FAMILY: Isopropyl Alcohol 250ml","32.34"],
    ["FAMILY: Isopropyl Alcohol 250ml","32.34","AMBROXOL Expel 6mg-mL 15ML Drops","75.04"]

]

}

This is my php code:

foreach ($this->cases_model->test() as $row)        {

                $new_row[]=$row['name'];
                $new_row[]=$row['dp'];
                $row_set['data'][] = $new_row; //build an array
          }

      echo json_encode($row_set); //format the array into json data

Thamilhan · Accepted Answer · 2016-06-06 10:35:55Z

4

$new_row is not cleared, so it holds the data of the previous iteration. So, change your foreach to:

foreach ($this->cases_model->test() as $row){
    $new_row = []; //Reset the array for every loop
    $new_row[]=$row['name'];
    $new_row[]=$row['dp'];
    $row_set['data'][] = $new_row; //build an array
}

answered Jun 6, 2016 at 10:35

Thamilhan

13.3k5 gold badges40 silver badges60 bronze badges

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

Comments

Prasad Khode · Accepted Answer · 2016-06-06 11:08:13Z

1

foreach ($this->cases_model->test() as $row)        {

    $new_row[]=$row['name'];
    $new_row[]=$row['dp'];
    $row_set['data'][] = $new_row; //build an array
    $new_row = NULL;     
}

edited Jun 6, 2016 at 11:08

Prasad Khode

6,77712 gold badges48 silver badges62 bronze badges

answered Jun 6, 2016 at 10:41

kiran gadhvi

2282 silver badges16 bronze badges

Collectives™ on Stack Overflow

PHP JSON Encode: Formatting

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related