/    Sign up×
Community /Pin to ProfileBookmark

Loading a Listbox with AJAX/PHP

Ok, I bought a book on CSS/DHTML/AJAX and the AJAX section only has a part where static text is returned.

I want to have PHP/MySQL query results returned. I am hoping this is possible? Where would I begin to get the results I want?

to post a comment
JavaScript

1 Comments(s)

Copy linkTweet thisAlerts:
@toicontienFeb 13.2007 — You might want to check out JSON (JavaScript Object Notation). http://www.json.org/

It allows you to return plain text from your PHP script, and then have a browser JavaScript parse the returned text using the eval() function and turn it directly into a usable javascript object, array or variable. Say your PHP script returns this in the responseText of the AJAX call:
{name: 'Barry', age: 31}
In your callback javascript function:
<i>
</i>var respObj = eval('('+responseText+')');
alert('Name: '+respObj.name);
alert('Age: '+respObj.age);
×

Success!

Help @Evie spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.20,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...