将两个查询合并到一个JSON对象

Question

I have two queries:

1) $result = $this->_db->get_where("wishes",array("is_open"=>1))->result_array();
2) $requirements_result = $this->_db->get("requirements")->result_array();

I'm trying to output the data in this JSON format:

{
    [
      {
        id:12,
        title:"Meet Messi",
        image_url:"http://dsadsa.dsadsa",
        previewImageUrl:"http://kdjfla.com"
        is_open:"true"
        requirements: [
      {
        id: 123,
        title:"kiss Messi",
        is_complete: true
      }
    ]
      }

    ]
  }
}

I created two models (one for each query). This is what I've done so far:

$result = $this->_db->get_where("wishes",array("is_open"=>1))->result_array();
$requirements_result = $this->_db->get("requirements")->result_array();

$return_array = array();
foreach ($result as $value)
{                   
    $wishes_model = new wishes_model(); 
    $wishes_model->init_wishes($value);
    $return_array[] = $wishes_model;
}
return $return_array;

How to i insert the requirements result to create this JSON?

Answer 1

First, create your wishes array as an associative array, with the ID as the key:

$wishes_array = array();
foreach ($results as $value) {
    $wishes_model = new wishes_model();
    $wishes_model->init_wishes($value);
    $wishes_array[$value['id']] = $wishes_model;
}

Then you can add the requirements to the appropriate wish:

foreach ($requirements_results as $req) {
    $wishes_array[$req['wish_id']]->requirements[] = $req;
}

I'm making some assumptions about which things in your application are associative arrays versus objects. You should be able to adjust this to match your specific implementation.