//建立資料庫連線
$xoopsDB =& Database::getInstance();
//找出今天日期
$today=date("Y-m-d");
//將今天的計數抓出來
$sql="select counter from page_count where day='{$today}'";
$result = $xoopsDB->query($sql) ;
list($counter)=$xoopsDB->fetchRow($result);
//將計數加1
$counter++;
//以新值取代掉原值
$sql="replace into page_count (day,counter) values('{$today}',$counter)";
$xoopsDB->queryF($sql) ;
//秀出計數器的新值
echo "{$today}共有 {$counter} 人次來訪";