<?php

include 'config.php';

// SELECT COMMAND
if (isset($_GET['Action'])) {
	if ($_GET['Action'] == 'Add') {
		$insert_query = "INSERT INTO `todo` (address, subject,description,start,end, calendar, status) 
			VALUES ('".$_GET['Address']."','".$_GET['Subject']."','".$_GET['Description']."','".$_GET['From']."','".$_GET['To']."','".$_GET['Agent']."','".$_GET['Status']."')";
		echo $insert_query;				
			
		$mysqli->query($insert_query);
	}
}
else{

	
$query = "SELECT * FROM `todo`";// WHERE OwnerID=".$_GET['OwnerID'];


$result = mysqli_query($mysqli, $query) or die("SQL Error 1: " . mysqli_error());

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
	
    $List[] = array(
		'id' => $row['id'],
        'status' => $row['status'],
        'description' => $row['description'],
		'address' => $row['address'],
		'subject' => $row['subject'],
		'name' => $row['name'],
		'style' => $row['style'],
		'calendar' => $row['calendar'],
		'start' => $row['start'],
		'end' => $row['end'],
    );
}


echo json_encode($List);

$result->close();
}
$mysqli->close();
?>