在网站主页上显示数据库重点所需的SQL

Question

Wikipedia http://en.wikipedia.org/wiki/Main_Page , has sections like:

1. Todays featured article,
2. From the news,
3. Did you know etc.

Say in my page, I want to get the main highlights from the database table(s) (multiple databases possible), what is the best possible way to query? I mean create separate connections and then query or use multiple queries? Is it better to use PDO for this purpose? And how can I make a particular section update without refreshing the page say every 10 min? Is the code going to be complicated?

Can anyone please let me know.

Thanks.

Answer 1

If you want to refresh the data, you have two options.

First of all, you could write JavaScript to run away after a set interval and get fresh data. This is a VERY BAD idea - it exposes you to browser specific bugs, it won't work on machines with JavaScript disabled, and far more importantly it means you'll be furnishing your pages with the connection details for your database (and also allowing connections to it from anywhere).

A better solution would be to use AJAX to handle this - which basically means that you serve "just the data" rather than the whole page. Again, it's dependent on Javascript, but then implementing client side behaviour without the benefit of client side scripting will never work anyway!

Martin.