PHP- Convert more than one Json string into a single array

Question

I have a result set which looks something like this:

For each entry, there can be more than one category and I'm trying to decode these JSON strings and save it in a single array. That means, all these categories will be decoded and saved in an array. This data is fetched from database.

This is the code I tried:

//$resultset contains the entire resultset
$resultset_JSON='[["first","second","third","fourth"],["fifth","sixth","seventh","eight","ninth"]‌,["life","death","business" ,"editing","light"]]';

$data= array();
while($row=mysqli_fetch_array($resultset))
{
    $data       =   json_decode($row['category']); 
    //$data[]   =   json_decode($row['category']);                      
}
print_r($data);

But I'm not getting the desired result. I'm only able to fetch the last row.

Can anyone help me figure this out?

This is the output I'm trying to get:

Array 
( 
  [0] => first
  [1] => second
  [2] => third
  [3] => fourth
  [4] => fifth
  [5] => sixth
  [6] => seventh
  [7] => eighth
  [8] => ninth
  [9] => life 
  [10] => death 
  [11] => business 
  [12] => editing 
  [13] => light 
)

Tried that. JSON encoded output of the array if i do so is [["first","second","third","fourth"],["fifth","sixth","seventh","eight","ninth"],["life","death","business" ,"editing","light"]] @Saty — version 2
– version 2, Commented Jun 15, 2016 at 6:30
Okk use it as $data[] = $row['category']; and outside while loop json_decode($data) — Saty
– Saty, Commented Jun 15, 2016 at 6:33
$data[]=json_decode($row['category'],true); and use array_merge — JYoThI
– JYoThI, Commented Jun 15, 2016 at 6:38

JYoThI · Accepted Answer · 2016-06-15 06:51:44Z

1

try this

$final_array = array();

while($row=mysqli_fetch_array($resultset))
{

  $temp_data       =   json_decode($row['category'],true); 
  $final_array     =   array_merge($final_array ,$temp_data);  

 }

 print_r($final_array );

answered Jun 15, 2016 at 6:51

JYoThI

12.1k1 gold badge13 silver badges26 bronze badges

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

Comments

Killan · Accepted Answer · 2016-06-15 06:30:09Z

1

You can use array_merge in your loop

http://php.net/manual/fr/function.array-merge.php

answered Jun 15, 2016 at 6:30

Killan

3411 gold badge6 silver badges15 bronze badges

Comments

Gaurav Mahajan · Accepted Answer · 2016-06-15 06:51:47Z

1

Please try this code:

$data= array();
$ds= array();
$f ='';
while($row=mysqli_fetch_array($resultset)){
{
    $data      =   json_decode($row['category']);   
    $f .= implode(',',$data);                       
}
if(!empty($f)) {
  $ds = explode(',',$f);
}
print_r($ds);

answered Jun 15, 2016 at 6:51

Gaurav Mahajan

2901 silver badge5 bronze badges

Comments

ksealey · Accepted Answer · 2016-06-15 06:47:25Z

0

  $resultset_JSON='[["first","second","third","fourth"],["fifth","sixth","seventh","eight","ninth"]‌,["life","death","business" ,"editing","light"]]';

  $all_data = array();
  while($row=mysqli_fetch_array($resultset)){
      //Fetch array
      $data       =   json_decode($row['category']); 
      $all_data   =   array_merge($all_data,$data);                      
  }
  var_dump($all_data);

answered Jun 15, 2016 at 6:47

ksealey

1,7381 gold badge17 silver badges16 bronze badges

Collectives™ on Stack Overflow

PHP- Convert more than one Json string into a single array

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related