<?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; } }
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();