1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 |
- <?php
- header("Access-Control-Allow-Origin: *");
- session_name('default');
- session_set_cookie_params(0, '/', '.tankernn.eu');
- session_start();
- // Database settings
- require ("db.php");
- $data = new StdClass();
- if (!isset($_SESSION['userid'])) {
- $data->result = 1;
- } else {
- $userid = $_SESSION['userid'];
- if (isset($_POST['a'])) {
- // Additional actions to perform before returning the list
- switch ($_POST['a']) {
- case 'add':
- $title = $_POST['title'];
- $text = $_POST['text'];
- $deadline = $_POST['deadline'];
- $priority = $_POST['priority'];
- $data->message = $deadline;
- $sql = "INSERT INTO Todo (userid, priority, deadline, title, description) VALUES ($userid, $priority, '$deadline', '$title', '$text')";
- $data->result = $conn->query($sql) ? 0 : $conn->error;
- break;
- case 'rm':
- $id = $_POST['id'];
- $sql = "DELETE FROM Todo WHERE id=$id AND userid=$userid";
- $data->result = $conn->query($sql) ? 0 : $conn->error;
- break;
- }
- }
- $sql = "SELECT * FROM Todo WHERE userid=$userid ORDER BY deadline ASC, priority ASC";
- $query = $conn->query($sql);
- $data->list = array();
- while ($row = $query->fetch_array()) {
- array_push($data->list, $row);
- }
- }
- echo json_encode($data);
- ?>
|