|
|
Posted by flashvarss on 08/24/07 23:53
On Aug 25, 2:02 am, Toby A Inkster <usenet200...@tobyinkster.co.uk>
wrote:
> 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/
So ajax is the best then
i have a question now
a simple normal script to call the msg from the database is like that:
<title>Display Messages</title>
<script type="text/javascript" src="no_click.js"></script> <--//
refresh script with no click sound when refreshing
</head>
<body>
<?php
mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_select_db("chat") or die(mysql_error());
$data = mysql_query("SELECT * FROM chat") or die(mysql_error());
while($info = mysql_fetch_array( $data )) {
Echo " "said ".$info['words'] . " ";
}?>
</body>
</html>
Is there an ajax simple example for that?
Thnaks
Navigation:
[Reply to this message]
|