displying mysql data in a html page using ajax?

Question

Hi can anyone give me an example of How to just simply display data(no search of filter) form mysql to a html page using ajax.

Answer 1

Theres a simple example using PHP, MySQL and Ajax at http://www.w3schools.com/PHP/php_ajax_database.asp



( Hmmm - there was an extra full stop on the end of the link - I've removed it now )

Answer 2

Right, first off I've had a beer... or a couple as its the 12am here in the UK, also, Im not a website designer, just a application programmer!



Coding in ASP here...and im recaling from memory about a calander I made for a local pub that has live bands playing...



K, how I do it, and I dont know if its the right way or not, but I create the main page, and inport a secondry pay that takes querystings! This secondry page, has linke that call javascript functions! These functions refresh the content div of the main page with the new data from the secondery page!



the page I created is

http://www.blokeintheoak.co.uk



take a look, if this is what u need, email me and I'll help you out further!

[e-mail]



Sorry very vage but need sleep!



Kind regards

M@

Answer 3

There are a few examples of AJAX update, from database, at http://www.web2coders.com.

"table v div challenge" is a bit complex for a start, but "miniblog" use that technique.

Try in on-line first, and, if it looks like what you want, download the script! It is free!

Answer 4

The above link appears to be broken.



Try this one.



http://www.w3schools.com/sql/sql_intro.asp