tags:

views:

204

answers:

7
Q: 

PHP: Refresh my code

Hello i want to refresh my php every 3 sec this is what i have:

<?php
session_start();
include "../config.php";

$time = time();

$sql1 = "UPDATE login SET lastlogin = '" .$time. "' WHERE id = '" .$_SESSION['userid']. "'"; 
$res1 = mysql_query($sql1) or die(mysql_error());

$onlinetime = "10";  // 10 seconds

$sql3 =  "SELECT * FROM login ORDER BY lastlogin DESC"; 
$res3 = mysql_query($sql3);
    while($row3 = mysql_fetch_array($res3)){

if($row3['lastlogin'] + $onlinetime > time()){

echo '<b><font color="green">&#10004;</font></b> <u>'.$row3['name'].'</u><br />';

        }else{

echo "<b><font color='red'>X</font></b> <u>".$row3['name']."</u><br />";
        }
        }            

?>

This is not refreshing which is really irritating. It shows who's online at my chatbox. Someone help? Thanks.

+1  A: 

The best solution is to use ajax and poll a php script which checks for online users every X seconds.

I highly recommend jQuery for the ajax-part.

alexn  2009-10-26 19:31:00
+1  A: 

Refreshing a browsers content is something the browser should do. Either use the Redirect-After HTML meta-tag (which will result in "flickering"), or use some Javascript to reload the site's content (see AJAX)

Martin Hohenberg  2009-10-26 19:32:40
+7  A: 

I'd suggest using the <meta http-equiv="refresh" content="5" /> tag in the <head> section. This does not depend on JavaScript, and every major browser has this feature implemented.

Seb  2009-10-26 19:33:18
A: 

You may adding some parens around lastlogin + onlinetime:

if($row3['lastlogin'] + $onlinetime > time()){

change to

if(($row3['lastlogin'] + $onlinetime) > time()){
Doug Hays  2009-10-26 19:33:35
What does this have to do with refreshing the page?
Seb  2009-10-26 19:35:02
I was wondering the same.
Homework  2009-10-27 00:35:32
@seb; @joey; you right only answer on my question please. This stuff i could do with the validator...
YourComputerHelpZ  2009-11-08 14:56:41
+4  A: 

I have no idea what you're trying to do. The code has no mention of a refresh in it.

You could put the following in the element of your HTML to force the client to refresh every three seconds.

<meta http-equiv="refresh" content="3" />

Ian

Ian P  2009-10-26 19:34:07
A: 

You could use a javascript reload:

<META HTTP-EQUIV="Refresh" CONTENT="360; /">
Jakub  2009-10-26 19:34:08
+1  A: 

You could refresh using PHP header or something by that means. It works for me every time.

<?php
$url = 'http://google.com/'; $timeout = 5; //Directed URL and timeout.
header('Refresh: ' . $timeout . ';url=' . $url);
?>
Homework  2009-10-27 00:32:17
aI do not know for sure, but it seems to work fine... Thanks.
YourComputerHelpZ  2009-10-27 15:32:13
it does not work, it is not refreshing. i did not change anything about this except the url.
YourComputerHelpZ  2009-10-27 19:09:03
@YourComputerHelpZ Did you place this above everything else? Also, you must change the 5 to your directed time, as you said (3?) seconds...
Homework  2009-10-27 20:14:12

related questions

Remove Quotes and Commas from a String in MySQL
What's the best way of converting a mysql database to a sqlite one?
How do you manage databases in development, test, and production?
Multiple foreign keys?
Add 1 to a field (MySQL)
Issues using MS Access as a front-end to a MySQL database back-end?
Bigger than a char but smaller than a blob
How do I retrieve my MySQL username and password?
Long-time LAMP Developer moving to VB.NET
How do I Concatenate entire result sets in MySQL?
Full complete MySQL database replication? Ideas? What do people do?
SQL: Distribution of table in time
SQLite vs MySQL
How do I create a new Ruby on Rails application using MySQL instead of SQLite?
Multiple Updates in MySQL
MySQL/Apache Error in PHP MySQL query
What all do I need to escape when sending a (My)SQL query?
Auto Generate Database Diagram MySQL
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
Python and MySQL
SQL Server 2005 implementation of MySQL REPLACE INTO?
How to export data from SQL Server 2005 to MySQL
Throw Error In MySQL Trigger
Binary Data in MySQL