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