json jquery format issue

Question

this is my code on server side

$results = array();
while($rw = $objS->row($rs))
 {
$results[]=array('id'=>$rw["id"],
'agent_id'=>$rw["agent_id"],
'agent'=>$rw["agent"]);
}
echo json_encode($results);

on client side i have this coding

success: function( data ) {
var forum = data.results;
for(i = 0, l = forum.length; i < l; i++) {
row = forum[i];
alert(row.id);
}

how to develop json on server side? my json returns is

[{"id":"1","agent_id":"1","agent":"Rustomadmin"}]

i need like this

{"results":[{"id":1,"agent_id":"888","agent":"Emili"}]}

You need it like that because your client-side code accesses data.results. Maybe you can just write var forum = data; instead, or simply use data directly? — Frédéric Hamidi
– Frédéric Hamidi, Commented Apr 13, 2013 at 9:29
Yes, it is an array of two objects, the same thing data.results would have given you if your server-side code generated a results object. Try using data directly instead of forum in your loop. — Frédéric Hamidi
– Frédéric Hamidi, Commented Apr 13, 2013 at 9:40
@user2244804 : You said, the problem only from server side, then whats the reason to discuss on client side script.. Is there also any problem? — Ranjith
– Ranjith, Commented Apr 13, 2013 at 9:46

Ranjith · Accepted Answer · 2013-04-13 10:03:01Z

1

Your array() declaration is totally wrong.. Try this..

To populate multiple record values means,

<?php
    while($rw = $objS->row($rs))
     {
       $results[] = $rw;         // It generate Array of Array
     }

   $agentResult['results']  = $results;

   $jsonResult = json_encode($agentResult);
  echo $jsonResult;
?>

edited Apr 13, 2013 at 10:03

answered Apr 13, 2013 at 9:29

Ranjith

2,8393 gold badges24 silver badges42 bronze badges

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

2 Comments

user2244804 Over a year ago

sir this is also not working...sir how to create it exactly like this...{"results":[{"id":1,"agent_id":"888","agent":"Emili"}]}

user2244804 Over a year ago

this is good,but i want to add another query in while loop and get some value and want to pass in result array also..

Collectives™ on Stack Overflow

json jquery format issue

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related