| Server IP : 103.233.192.212 / Your IP : 18.217.218.162 Web Server : Apache/2 System : Linux sv1.inde.co.th 3.10.0-1160.36.2.el7.x86_64 #1 SMP Wed Jul 21 11:57:15 UTC 2021 x86_64 User : sumpatuan ( 1058) PHP Version : 5.5.38 Disable Function : symlink,shell_exec,exec,proc_close,proc_open,popen,system,dl,putenv,passthru,escapeshellarg,escapeshellcmd,pcntl_exec,proc_get_status,proc_nice,proc_terminate,pclose,ini_alter,virtual,openlog,ini_restore MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/sumpatuan/public_html/backup/ |
Upload File : |
<html>
<head>
</head>
<body>
<?php
error_reporting(0);
error_reporting(E_ERROR | E_PARSE);
//*** By Weerachai Nukitram ThaiCreate.Com ***//
//*** Connect MySQL ***//
mysql_connect("localhost","sumpatuan","Mb4iEgAI97");
mysql_select_db("sumpatuan_db");
//*** 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 ************************//
// 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="85%" border="1" bordercolor="red" align="left">
<tr>
<td colspan="2"><div align="center"><img src="counter.gif"> จำนวนผู้เข้าชมเว็บไซต์</div></td>
</tr>
<tr>
<td width="98"><div align="center"></i>วันนี้</div></td>
<td width="75"><div align="center"><?php echo number_format($strToday,0);?></div></td>
</tr>
<tr>
<td><div align="center">เมื่อวาน</div></td>
<td><div align="center"><?php echo number_format($strYesterday,0);?></div></td>
</tr>
<tr>
<td><div align="center">เดือนนี้ </div></td>
<td><div align="center"><?php echo number_format($strThisMonth,0);?></div></td>
</tr>
<tr>
<td><div align="center">เดือนก่อน</div> </td>
<td><div align="center"><?php echo number_format($strLastMonth,0);?></div></td>
</tr>
<tr>
<td><div align="center">ปีนี้ </div></td>
<td><div align="center"><?php echo number_format($strThisYear,0);?></div></td>
</tr>
<tr>
<td><div align="center">ปีก่อน </div></td>
<td><div align="center"><?php echo number_format($strLastYear,0);?></div></td>
</tr>
</table>
</body>
<html>