Use PHP to extract values from database and pass the results as a variable to JavaScript

Question

I have a JS/Html file and a PHP script. The PHP file creates a database connection and returns the result of the DB query.

The html page uses an ajax request to get the data and echos it back to the html page - but it is returned as text (xmlhttp.responseText), which I can display, but can't easily manipulate.

I would like to return the data as an array that I can process in JavaScript.

Is there a way for an ajax request to include the response as a variable, instead of as raw text?

If I can provide more information to make it easier to answer, let me know!

thanks!

Look into the JSON formatting. Php can echo your variables using json_encode(), which javascript can read and decode. — Fanis Hatzidakis
– Fanis Hatzidakis, Commented Dec 18, 2010 at 13:44
What about returning the response as XML with xmlhttp.responseXML? That allows you to access the individual nodes if the returned data is valid xml. The JSON option is probably easier though. — devius
– devius, Commented Dec 18, 2010 at 17:24

Anush Prem · Accepted Answer · 2010-12-18 14:14:54Z

2

Check PHP, JSON and JavaScript usage

answered Dec 18, 2010 at 14:14

Anush Prem

1,4718 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Use PHP to extract values from database and pass the results as a variable to 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