Example #1
0
<?php

/*
AJAX script that returns:
1. How many days an event has been recorded
2. Last day event was recorded
3. List of other days event was recorded
*/
ini_set('display_errors', 1);
require_once '../../../../../includes/classes/Db.php';
require_once '../../inc/Diary.php';
$diary = new Diary();
$diary->dbConn('../../../../../_db/diary.php');
require '../func.php';
// Prevent access if not logged in!
require '../../../../../includes/classes/Login.php';
# Login class.
$login = new Login($diary->sess_dir);
$login->startsession();
if (!isset($_SESSION[$diary->sessname])) {
    die('It was a dark, cloudy morning!');
}
// End if.
// End Access check code.
if (isset($_POST['load'])) {
    $r = $diary->link->prepare("SELECT relatedmainid, text FROM diary_related WHERE date=?");
    $r->execute(array($_POST['sel']));
    list($relatedmainid, $relatedtext) = $r->fetch(PDO::FETCH_NUM);
    $r = $diary->link->prepare("SELECT related_id, DATE_FORMAT(date, '%d/%m/%Y') FROM diary_related WHERE relatedmainid=? ORDER BY date");
    $r->execute(array($relatedmainid));
    $strrelateddates = '';