a nice and easy way to implement class for "What happened today?" for websites.
Note that if the class cannot find an event on the current date, it will take out the last occurence of an event.
<?php
/**
* --
* -- Table structure for table `events`
* --
*
* CREATE TABLE `events`
* (
* `id` int(8) NOT NULL auto_increment,
* `date` date NOT NULL default '0000-01-01',
* `event` text NOT NULL,
* PRIMARY KEY (`id`)
* );
**/
class eventClass
{
var $day;
var $table = "events";
var $columnText = "event";
var $columnID = "id";
var $columnDate = "date";
var $myEventArray = array
(
"eventID" => array(),
"eventText" => array(),
"eventDate" => array(),
);
/**
* @return Array/Boolean
* @desc Returns the events array from database. Return false if failed.
*/
function get()
{
$this->checkDate(date('d'));
return $this->myEventArray;
}
/**
* @return Boolean
* @param String $text
* @param Integer $month
* @param Integer $day
* @param Integer $year
* @desc Inserts a new event into database. Returns false if failed.
*/
function set($text, $month, $day, $year)
{
$date = $year . "-" . $month . "-" . $day;
$query = "insert into " . $this->table . "(" . $this->columnText . ", " . $this->columnDate . ") values('" . $text . "', '" . $date . "')";
$result = mysql_query($query);
if($result)
{
if(mysql_affected_rows())
return true;
else
return false;
}
else
return false;
}
/* FUNCTIONS*/
/**
* @return Boolean
* @param Integer $id
* @desc Deletes event from database
*/
function delete($id)
{
$query = "delete from " . $this->table . " where " . $this->columnID . "=" . $id;
$result = mysql_query($query);
if($result)
{
if(mysql_affected_rows())
return true;
else
return false;
}
else
return false;
}
