how to count and display realtime database queries using ajax and PHP?

Question

It gives great effect when you stream info in real time using ajax. for this example a SEO / webgrader tool called www.teqpad.com gives a nice interface and real time information on each queries into its database. They use PHP/ajax for the purpose.

My questions are:

how do they do it?
What are the methods or steps to take care of?
How php need to be written in to show the same.

I am not asking code but the method or proceedure to write the same.

Thanks in advance

Which specific features do you want to know about? Real time information on that site is probably collected using a web crawler. — el_pup_le
– el_pup_le, Commented May 26, 2011 at 14:30
From your description i think you already know the method / procedure. What do you really want to know? — edwin
– edwin, Commented May 26, 2011 at 14:37
actually how to interact php with ajax and how to write php script to work with.. — john
– john, Commented May 26, 2011 at 14:39

Mostafa Talebi · Accepted Answer · 2015-05-02 13:39:04Z

1

Use the javascript setTimeout() function to invoke GET requests to the server. Server returns data from your database. HTML is updated.

edited May 2, 2015 at 13:39

Mostafa Talebi

9,27718 gold badges69 silver badges110 bronze badges

answered May 26, 2011 at 14:59

zim32

2,6491 gold badge25 silver badges32 bronze badges

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

1 Comment

zim32 Over a year ago

Sory. What do you mean? What periods?

pfernandom · Accepted Answer · 2011-05-27 01:01:48Z

0

You do an AJAX call every few seconds with javascript and refresh the HTML of the page with the response of the call.

You could use JQuery to do the AJAX calls: http://net.tutsplus.com/tutorials/javascript-ajax/5-ways-to-make-ajax-calls-with-jquery/

The call can be done to a PHP script. Depending the kind of information you want to get is the kind of operations you do on PHP.

Here is a simple example: http://www.queness.com/post/328/a-simple-ajax-driven-website-with-jqueryphp

answered May 27, 2011 at 1:01

pfernandom

9391 gold badge10 silver badges22 bronze badges

Collectives™ on Stack Overflow

how to count and display realtime database queries using ajax and PHP?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related