File source
<?php
class CalendarSource{
function __construct(){
}
function getData($count = -1){
$q = "SELECT * FROM calendar WHERE `date` >= CURDATE() ORDER BY `date` ASC" ;
if($count > 0){
$q.=" LIMIT ".intval($count);
}
$r = mysql_query($q);
$o = Array();
while(($row = mysql_fetch_assoc($r)) !== false){
$o[] = $row;
}
return $o;
}
function getRelativeDate($date, $toDate = false){
if(!$toDate) $toDate = strtotime(Date("Y-m-d"));
$date = strtotime($date);
$diff = ($date - $toDate) / 3600;
if($diff >= 0){
if($diff < 24){
return "dnes";
}else if($diff < 48){
return "zajtra";
}else if($diff < 72){
return "pozajtra";
}else if($diff < 168){
return $this->getDayName($date);
}
}
return Date("d.m.", $date);
}
function getDayName($date){
$days = Array("nedeľa", "pondelok", "utorok", "streda", "štvrok", "piatok", "sobota");
return $days[Date("w", $date)];
}
function add($date, $text){
return mysql_query(sprintf("INSERT INTO calendar SET `date` = '%s', `text` = '%s' ",
mysql_real_escape_string(Date("Y-m-d", strtotime($date))),
mysql_real_escape_string($text)
));
}
function remove($id){
return mysql_query(sprintf("DELETE FROM calendar WHERE `id` = %d LIMIT 1", $id));
}
}