how to send database query result in json and display results in javascript?

Question

Can any one give me example or reference for converting mysql database query results in to json object and send it to javascript file then parse the json and display results in javascript file using jquery?

Thanks.

gen_Eric · Accepted Answer · 2010-10-20 20:59:53Z

2

If you are using PHP, you can use json_encode to convert a PHP array to JSON. Usually mysql results are given in arrays.

Using jQuery, you can give the $.ajax method a dataType of 'json', so it will parse the JSON into a JavaScript array for you. (I'm assuming you are using AJAX.)

Or, you can save load the PHP variable in a JS one by doing this:

var sqlResults = <?=$results?>;

I hope this helps.

answered Oct 20, 2010 at 20:59

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

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

Collectives™ on Stack Overflow

how to send database query result in json and display results in javascript?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related