PDA

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



prosportal
17 Apr 2012, 01: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">
<head>
<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";

$.each(stat,function(stat){

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

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

})
}

setInterval('updateStats("updateStats")', 2000);
</script>


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

<div id="online"></div>
<div id="money"></div>
</body>
</html>
----------------

<?php

if($_POST['stats']=='online')
{
$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']);

}

$mysqli->close();

?>

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