JaZoN Time Index :   9:35:02 AM

=DATE(DATE_SUB(NOW(), INTERVAL 2 DAY)) "); $row5 = mysql_fetch_array ($sql); $sql= mysql_query("SELECT COUNT(time_value) FROM `timeindex` WHERE date>=DATE(DATE_SUB(NOW(), INTERVAL 2 DAY)) "); $row5 = mysql_fetch_array ($sql); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>
  • 7 Days

  • 1 Month

  • 6 Month

  • 1 Year

  • Full

7 Day Moving Avg.
6 Month Moving Avg.
1 Month Moving Avg.
1 Year Moving Avg.
Full Index Moving Avg.
Current Value:   ".$row['time_value'] ." "; $total= ($row['time_value']) - ($row1['time_value']); $total1= number_format($total, 2, '.', ''); if($total1 < 0 ){ echo "   Change:  ".$total1 ."
"; } elseif($total1 > 0 ){ echo "   Change:  +".$total1."
"; } $avg=$row3['AVG(time_value)']; echo "
Index Average:   ". (number_format($avg, 2, '.', '')) ." Last Entry:   ". date(' M, d, G:i.s, ', strtotime($row['date'])) ."
Total # of Entries:   ".$row3['COUNT(time_value)'] ." Total # of Entries 48 Hours:   ".$row5['COUNT(time_value)'] ."
Index High:   ".$row3['MAX(time_value)'] ." Index Low:   ".$row3['MIN(time_value)'] ."
=DATE(DATE_SUB(NOW(), INTERVAL 360 DAY)) GROUP BY date ORDER BY unix_timestamp(date)*1000 DESC ) as timeindex"; $result = mysql_query($sql) or die('Query failed: ' . mysql_error()); if ($result) { while ($rowb = mysql_fetch_assoc($result)) { //add to data areray $data6[]=array($rowb['unix_timestamp(date)*1000'] , $rowb['count']); } } $sql="select * from (select id_value, unix_timestamp(date)*1000, date, time_value AS 'count' from timeindex WHERE date>=DATE(DATE_SUB(NOW(), INTERVAL 6 MONTH)) GROUP BY date ORDER BY unix_timestamp(date)*1000 DESC ) as timeindex"; $result = mysql_query($sql) or die('Query failed: ' . mysql_error()); if ($result) { while ($rowb = mysql_fetch_assoc($result)) { //add to data areray $data5[]=array($rowb['unix_timestamp(date)*1000'] , $rowb['count']); } } $sql="select * from (select id_value, unix_timestamp(date)*1000, date, time_value AS 'count' from timeindex WHERE date>=DATE(DATE_SUB(NOW(), INTERVAL 7 DAY)) GROUP BY date ORDER BY unix_timestamp(date)*1000 DESC ) as timeindex"; $result = mysql_query($sql) or die('Query failed: ' . mysql_error()); if ($result) { while ($rowb = mysql_fetch_assoc($result)) { //add to data areray $data4[]=array($rowb['unix_timestamp(date)*1000'] , $rowb['count']); } } $sql="select * from (select id_value, unix_timestamp(date)*1000, date, time_value AS 'count' from timeindex WHERE date>=DATE(DATE_SUB(NOW(), INTERVAL 30 DAY)) GROUP BY date ORDER BY unix_timestamp(date)*1000 DESC ) as timeindex"; $result = mysql_query($sql) or die('Query failed: ' . mysql_error()); if ($result) { while ($rowb = mysql_fetch_assoc($result)) { //add to data areray $data3[]=array($rowb['unix_timestamp(date)*1000'] , $rowb['count']); } } $sql="select * from (select id_value, unix_timestamp(date)*1000, date, time_value AS 'count' from timeindex GROUP BY date ORDER BY unix_timestamp(date)*1000 DESC ) as timeindex "; $result = mysql_query($sql) or die('Query failed: ' . mysql_error()); if ($result) { while ($rowb = mysql_fetch_assoc($result)) { //add to data areray $data2[]=array($rowb['unix_timestamp(date)*1000'] , $rowb['count']); } } ?>

Individual Sessions

Session :Session Name:Avg. Value :Index Name :Last Update :