Format JSON PHP from MySQL Query

Question

I have a question about formating a json in php. Here is my code

public function testing() {

if (!empty($_POST)) {
    $this->db->select('*');
    $this->db->from('trash_table');
    $this->db->where('Description',$_POST['Descp']);
    $q = $this->db->get();

    if($q->num_rows() > 0 )      
     //here should be something better
    print json_encode($q->result());

}

With my current simple php code, I'm just getting everything as a JSONArray.

[

  {"ID":1,"Description":"hello",

  {"ID":2,"Description":"hellou"}

]

But I want to format it on my own way, something like this...Hope you guys help. Thank you in advanced!

{

"Answer": {

    "Success": "Yup"
          },

"List": [

    {"ID":1,    
    "Description":"hello"},

    {"ID":2,    
    "Description":"hellou"}]

}

DCrystal · Accepted Answer · 2014-08-31 12:03:26Z

1

$result = array(
  'Answer' => array('Sucess'=>'Yup'),
  'List' => array(
     array('id' => 1, 'Description' => 'hello'),
  )
);
print json_encode($result);

Will print:

{"Answer":{"Sucess":"Yup"},"List":[{"id":1,"Description":"hello"}]}

edited Aug 31, 2014 at 12:03

answered Aug 31, 2014 at 11:58

DCrystal

7215 silver badges11 bronze badges

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

Comments

dritan · Accepted Answer · 2014-08-31 11:57:30Z

1

try this:

$list = $q->result(); $result = array( "Answer" => array ( "success" => "Yup" ), "List" => $list ); print json_encode($result);

answered Aug 31, 2014 at 11:57

dritan

9022 gold badges9 silver badges23 bronze badges

Collectives™ on Stack Overflow

Format JSON PHP from MySQL Query

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