View Full Version : Jquery/AJAX/PHP and Arrays OH MY!

17 Apr 2012, 02:07 PM
So, I'm trying to learn Jquery/Axaj using an array to execute and update code on different elements within a single function.

Below, I'm trying to update the DIVs with the number of people logged into the site, and the total currency in circulation. The script will update every few seconds.

Can anyone help me correct my syntax or at least tell me what I'm doing wrong here?

<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script type="text/javascript" src="../jquery.js"></script>

<script type="text/javascript">
function updateStats(stat)
var stat = ["online","money"];

var url = "online.php";


$.post(url,{stat: stat} , function(data) {

$("#" + this).html(data);


setInterval('updateStats("updateStats")', 2000);

<body onLoad="updateStats(stats);">

<div id="online"></div>
<div id="money"></div>


$result= $mysqli->query("SELECT loggedin FROM accounts WHERE loggedin !=0");
echo $result->num_rows;

elseif($_POST['stats'] == 'money')
$result = $mysqli->query("SELECT sum(money) AS totalMoney FROM users");
$getData = $result->fetch_assoc();

echo number_format($getData['totalMoney']);




19 Apr 2012, 04:25 AM
this code connect with database ?