I\\\'m trying to develop a script to show which users are active on the site. I\\\'m using a simple database called ActiveUsers that has two fields - Username and Timestamp. The script works in firefox, but the second time it reloads the list of users it comes up blank, after that it seems to reload the information fine. In IE it loads the list once, but afterwards it just keeps the same information up on the page. The code is below.
PHP Code
<?php
include "./protected/dbConn.inc\";
$mysqlConn = mysql_connect(\"$host\", $username, $password) or die(\"Couldn\'t connect to database\");
mysql_select_db($database, $mysqlConn);
if(isset($_COOKIE[\'uID\'])) {
$un = $_COOKIE[\'un\'];
$uID = $_COOKIE[\'uID\'];
$query_session = \"select * from Users where username=\'$un\' and userid=\'$uID\'\";
$session_result = mysql_query($query_session, $mysqlConn);
if(!$session_result && mysql_numrows($session_result) < 1) {
header(\"Location: login.html\");
}
} else {
header(\"Location: login.html\");
}
?>
<html>
<head>
<title>ChrisVinecombe.com - Active Users</title>
<link rel=\"stylesheet\" href=\"style.css\" type=\"text/css\" charset=\"utf-8\" />
<script language=\"JavaScript\">
var user;
var AJAX;
function initAJAX() {
user = document.getElementById(\'user\').value;
try {
AJAX = new XMLHttpRequest();
} catch(e) {
try {
AJAX = new ActiveXObject(\"Msxml2.XMLHTTP\");
} catch(e) {
try {
AJAX = new ActiveXObject(\"Microsoft.XMLHTTP\");
} catch(e) {
alert(\"Your browser can\'t use AJAX!\");
return false;
}
}
}
setRefresh(1);
setRefresh(30000);
}
function setRefresh(num) {
setTimeout(\"UpdateActive()\", num);
}
function UpdateActive() {
AJAX.onreadystatechange = function() {
if(AJAX.readyState == 4) {
var disp = document.getElementById(\'ShowUsers\');
disp.innerHTML = AJAX.responseText;
}
}
var ran= Math.floor(Math.random() * 1001);
AJAX.open(\"GET\", \"getactive.php?user=\"+user+\"&ie=\"+ran, true);
AJAX.send(null);
setRefresh(30000);
}
</script>
</head>
<body onload=\"initAJAX()\">
<div id=\"header\">
<h1>Page</h1>
</div>
<div id=\"nav\">
<ul>
<li class=\"first\"><a href=\"index.html\"><em>H</em>ome</a></li>
<li><a href=\"scripts.html\"><em>S</em>cripts</a></li>
<li><a href=\"/forum/\"><em>F</em>orum</a></li>
<li><a href=\"/hireme/\"><em>H</em>ire Me</a></li>
</ul>
</div>
<div id=\"content\"><div class=\"i\">
<form>
<?php print \"<input type=\'hidden\' id=\'user\' value=\'$un\'>\";
</form>
<h2>Online Users</h2>
<div id=\"ShowUsers\"></div>
</div></div>
<div id=\"buffer\"></div>
<div id=\"footer\"></div>
</body>
</html>
|
