create.php
770 Bytes
<?php
include '../connection.php';
try {
$params = json_decode(file_get_contents('php://input'));
unset($params->id);
$statement = $db->prepare('insert into task (title, list_id, due, reminder, done, note) values(:title, :list_id, :due, :reminder, :done, :note)');
foreach($params as $key => &$value) {
$statement->bindParam(":$key", $value);
}
if(!$statement->execute()) {
throw new Exception(implode(', ', $statement->errorInfo()));
}
$params->id = $db->lastInsertId();
$jsonResult = array(
'success' => true,
'tasks' => $params
);
} catch(Exception $e) {
$jsonResult = array(
'success' => false,
'message' => $e->getMessage()
);
}
echo json_encode($jsonResult);
?>