Json_encode to be a loop of database query values

Question

I have json_encoded an array of a mysql result as shown here:

$allquery="SELECT * FROM wp_users";
$names = array();   
$allresult=mysql_query($allquery) or die(mysql_error()); ?>

<?php while($rows=mysql_fetch_array($allresult)){  

  $names[] = $rows['display_name']; 

}

print json_encode( array( 

  "res" =>  $names,
  "fvdfvv" => "sdfsd"

) 
);

My problem is... when it gets back to the client-side, I am unsure about how to display it. I try and alert the reply on success:

  success: function(result){
            var allresult = result.res
            $('#result').html(  allresult  );

            alert(allresult);
        //$("#notice_div").hide(); 

      }

But this doesnt return anything. In fact, the success handler doesnt even begin.

Any ideas?

Thanks

charlietfl · Accepted Answer · 2012-03-02 14:58:54Z

2

First check in console if request is made, and status. If path is bad in request will see a 404.

If status is 200 will be able to see what is returned. If nothing returned there is problem in php, can echo error handler

To loop over the resulting response array:

 success: function(response) {
    var html='';

    var names=response.res
    $.each(names, function( i, name){
       html+= "<li>" + name + "</li>";
    });
    $('#result').html(  html  );


 },

answered Mar 2, 2012 at 14:58

charlietfl

172k14 gold badges125 silver badges154 bronze badges

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

Comments

outrunthewolf · Accepted Answer · 2012-03-02 14:49:06Z

1

I would check your making a JSON request with your request call, I know mootools can be funny about that not sure what framework your using is it jQuery?

I would use echo instead of print (buts thats my preference)

Do you get any results at all? have you alerted out "result"?

if your definitely sure the success handler isn't firing, the problem is elsewhere. Perhaps you can expand your post with more of your code.

answered Mar 2, 2012 at 14:49

outrunthewolf

3834 silver badges13 bronze badges

7 Comments

JamesG Over a year ago

No I know the success is working ok, the problem comes when I try and get the database result to show in client side. I am alerting an array right? So im unsure about how to parse the array in javascript.

outrunthewolf Over a year ago

ok. Well it will be a JSON Object. Have you got firefox / Chrome? Can you turn on your firebug / developer tools and instead of: alert(result), use console.log(result) and you should see your object returned in the console. That will give you a better idea of whats coming back

JamesG Over a year ago

Ahh yes... its returning "undefined"

JamesG Over a year ago

So... i guess I need to know how to access or loop through the returned data? becuase its in an array right?

outrunthewolf Over a year ago

Does "result" return undefined or "result.res"?

|

Hamza Waqas · Accepted Answer · 2012-03-02 14:44:14Z

1

1).Make an alert message after the initializing the function of success. Make a return false statement. If it makes an alert message means your process is going fine else try to check your url and data sent in the ajax call.

2). If it makes alert then look over decoding the incoming json object data.

This will work fine for you!. Thanks.

answered Mar 2, 2012 at 14:44

Hamza Waqas

6274 silver badges12 bronze badges

Comments

András Váczi · Accepted Answer · 2012-03-02 14:48:16Z

0

Possibly you should use GET, not POST (if it remained so since your previous post). Then do what Hamza told you to do.

answered Mar 2, 2012 at 14:48

András Váczi

3,02025 silver badges30 bronze badges

Collectives™ on Stack Overflow

Json_encode to be a loop of database query values

4 Answers 4

Comments

7 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related