<?php
include("../db.php");


if (!isset($_GET['start']) || !isset($_GET['end'])) {
  die("Please provide a date range.");
}

$range_start = mysqli_real_escape_string($dblink, $_GET['start']);
$range_end = mysqli_real_escape_string($dblink, $_GET['end']);

$result = dbQuery("SELECT * FROM content WHERE scheduled_date >= '$range_start' AND scheduled_date <= '$range_end'",false); 
if(is_array($result)) { 
	$counter = 0;
	foreach($result as $row) { 
		$out[$counter]['title'] = $row['title']; 
		
		$out[$counter]['url'] = 'publish.php?scheduled_date='.$row['scheduled_date'];
		$out[$counter]['start'] = $row['scheduled_date'];
		$counter++; 
	}
	
}

echo json_encode($out);