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);

?>