<?php

require_once 'php/utils.php';
header('Content-type: text/html; charset=utf-8');
//expect param as YYYYMMDD which is last updated date
if (empty($_GET)) {
    //ERR1 - "No date given"
    die("ERR1");
} else {
    $checkDate = validateAndConvertInputDate($_GET['date']);
    if (!is_string($checkDate)) {
        die($checkDate[1]);
    } else {
        require_once 'php/db.php';
        $query = "SELECT * FROM jgnGeneric WHERE ModifiedDate > '{$checkDate}'";
        $result = mysql_query($query, $link);
        if (!$result) {
            die(mysql_error());
        }
        //$hasUpdate =  (mysql_num_rows($result) > 0) ? true : false;
        $p = mysql_num_rows($result) > 0 ? "Yes" : "No";
        print $p;
    }
}
Beispiel #2
0
ini_set('display_errors', 1);
error_reporting(E_ALL);
require_once 'php/utils.php';
require_once 'php/db.php';
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
//expect param as YYYYMMDD
if (empty($_GET)) {
    //TODO: Change this to be current date OR just return all values....?
    $pDate = "20130101";
} else {
    $pDate = $_GET['date'];
}
//$pDate = $_GET["date"];
$checkDate = validateAndConvertInputDate($pDate);
if (!is_string($checkDate)) {
    die($checkDate[1]);
} else {
    $query = "SELECT * FROM jgnGeneric WHERE ModifiedDate > '{$checkDate}' and Active = 1";
    $result = mysql_query($query, $link);
    $query2 = "SELECT ID FROM jgnGeneric WHERE ModifiedDate > '{$checkDate}' and Active = 0";
    $result2 = mysql_query($query2, $link);
    if (!$result or !$result2) {
        die(mysql_error());
    }
    //$hasUpdate =  (mysql_num_rows($result) > 0) ? true : false;
    if (mysql_num_rows($result) > 0 or mysql_num_rows($result2) > 0) {
        $xml = new XMLWriter();
        //$xml->openURI("php://output");
        $xml->openMemory();