api.php 1.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. <?php
  2. header("Access-Control-Allow-Origin: *");
  3. session_name('default');
  4. session_set_cookie_params(0, '/', '.tankernn.eu');
  5. session_start();
  6. // Database settings
  7. require ("db.php");
  8. $data = new StdClass();
  9. if (!isset($_SESSION['userid'])) {
  10. $data->result = 1;
  11. } else {
  12. $userid = $_SESSION['userid'];
  13. if (isset($_POST['a'])) {
  14. // Additional actions to perform before returning the list
  15. switch ($_POST['a']) {
  16. case 'add':
  17. $title = $_POST['title'];
  18. $text = $_POST['text'];
  19. $deadline = $_POST['deadline'];
  20. $priority = $_POST['priority'];
  21. $data->message = $deadline;
  22. $sql = "INSERT INTO Todo (userid, priority, deadline, title, description) VALUES ($userid, $priority, '$deadline', '$title', '$text')";
  23. $data->result = $conn->query($sql) ? 0 : $conn->error;
  24. break;
  25. case 'rm':
  26. $id = $_POST['id'];
  27. $sql = "DELETE FROM Todo WHERE id=$id AND userid=$userid";
  28. $data->result = $conn->query($sql) ? 0 : $conn->error;
  29. break;
  30. }
  31. }
  32. $sql = "SELECT * FROM Todo WHERE userid=$userid ORDER BY deadline ASC, priority ASC";
  33. $query = $conn->query($sql);
  34. $data->list = array();
  35. while ($row = $query->fetch_array()) {
  36. array_push($data->list, $row);
  37. }
  38. }
  39. echo json_encode($data);
  40. ?>