AGENDA-CALENDAR.PHP

This abstract class contains the methods required to save and get saved agenda calendar entries for all the days of the year. Bellow, you will find the PHP source code for save-entry.ajax.php, and get-entry.ajax.php.

GET-ENTRY.AJAX.PHP

<?
include('agenda-calendar.class.php');

$date = isset($_POST['date']) ? $_POST['date'] : '';

agendaCalendar::createTables();

$entry = agendaCalendar::getEntry($date);
?>
<?= $entry ?>

SAVE-ENTRY.AJAX.PHP

<?
//* : delete this line, it's here to keep my DB from being spammed.

include('agenda-calendar.class.php');

$date = isset($_POST['date']) ? $_POST['date'] : '';
$entry = isset($_POST['entry']) ? stripslashes($_POST['entry']) : '';

$id = agendaCalendar::saveEntry($date, $entry);
?>

agenda-calendar.html agenda-calendar.js agenda-calendar.php

AGENDA-CALENDAR.CLASS.PHP

<?
//Developed by Francisco Charrua
//on April 2011

include('db.inc.php');

abstract class agendaCalendar
{
         public function createTables()
         {
                $connection = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
                
                $sql = 'create table if not exists ac_entries (' .
                       'id int primary key auto_increment, ' .
                       '`date` date, ' .
                       'entry text' .
                       ')';
                       
                $connection->query($sql);
                
                $connection->close();
         }
    
         public function saveEntry($date, $entry)
         {
                $entry = self::sanitize($entry);
             
                $connection = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
                
                $sql = 'select id from ac_entries where ac_entries.date = ?';
                
                $statement = $connection->prepare($sql);
                $statement->bind_param('s', $date);
                $statement->bind_result($id);
                $statement->execute();
                
                if($statement->fetch())
                {
                   $statement->close();
                   
                   $sql = 'update ac_entries set entry = ? where id = ?';
                   
                   $statement = $connection->prepare($sql);
                   $statement->bind_param('si', $entry, $id);
                   $statement->execute();
                }
                else
                {
                   $statement->close();
                   
                   $sql = 'insert into ac_entries (ac_entries.date, entry) values (?, ?)';
                   
                   $statement = $connection->prepare($sql);
                   $statement->bind_param('ss', $date, $entry);
                   $statement->execute();
                   
                   $id = $statement->insert_id;
                }
                
                $statement->close();
                $connection->close();
                
                return($id);
         }
         
         public function getEntry($date)
         {
                $connection = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
                
                $sql = 'select entry from ac_entries where ac_entries.date = ?';
                
                $statement = $connection->prepare($sql);
                $statement->bind_param('s', $date);
                $statement->bind_result($entry);
                $statement->execute();
                
                if(!$statement->fetch()) $entry = '';
                
                $statement->close();
                $connection->close();
                
                return($entry);
         }
         
         private function sanitize($text)
         {
                 $text = trim($text);
                 $text = str_replace("<", "<", $text);
                 $text = str_replace(">", ">", $text);

                 return($text);
         }         
}
?>