You are here: Re: real time sql query « PHP Programming Language « IT news, forums, messages
Re: real time sql query

Posted by Toby A Inkster on 08/24/07 23:02

flashvarss wrote:

> Any one in here knows how to get data from sql database without having
> to refresh page?

Other than periodically refreshing the page, you have two options:

1. Using AJAX to continuously poll the server;
2. The "multipart/x-mixed-replace" MIME type;
3. Server-sent events <http://labs.opera.com/news/2006/09/01>.

A page refresh will offer the widest range of browser support. AJAX will
work in any reasonably modern browser with Javascript enabled. Multipart/
X-Mixed-Replace is an old Netscape 1.x push technology, which is still
supported in Gecko-based browsers, plus Opera and Safari, but not Internet
Explorer. Server-sent events, although the neatest solution are only
supported by one browser so far -- Opera 9.x -- expect wider browser
support in the future.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 65 days, 2:30.]

TrivialEncoder/0.2
http://tobyinkster.co.uk/blog/2007/08/19/trivial-encoder/

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация