api.php 1.1 KB

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