Execute($sql);
header('Location:index.php?ok=1');
}
//////////////////////////////////////////////////////
// get Data
function getDayCountData($d=false,$sql=false) {
global $db;
if(!$d) {
$d = mktime();
}
if(!$sql) {
$sql = 'SELECT COUNT(*) as co FROM chicki WHERE DATE_FORMAT(d, "%Y%m%d") = "'.date('Ymd',$d).'" GROUP BY DATE_FORMAT(d, "%Y%m%d")';
}
$result = $db->execute($sql);
$A = $result->getRowAssoc(false);
if($A['co']) {
return $A['co'];
}
return 0;
}
// get yesterday
$Data['yesterday'] = getDayCountData(mktime()-60*60*24);
// get today
$Data['today'] = getDayCountData();
// get last
$Data['last'] = date('d.m.Y H:i',getDayCountData(false,'SELECT UNIX_TIMESTAMP(d) AS co FROM chicki ORDER BY id DESC'));
$Data['last_sec'] = mktime()-getDayCountData(false,'SELECT UNIX_TIMESTAMP(d) AS co FROM chicki ORDER BY id DESC');
$Data['last_F'] = floor($Data['last_sec']/60/60/24).'d '.floor($Data['last_sec']/60/60%24).'h '.floor($Data['last_sec']/60%60).'m '.($Data['last_sec']%60).'s';
//////////////////////////////////////////////////////
?>
Chicki