Guest User

Untitled

a guest
Jul 21st, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. function PrintTasks($day)
  2. {
  3. global $dbConnection;
  4. global $dbName;
  5.  
  6. $dbName = 'db_planner_laurens';
  7. $dbConnection = mysqli_connect('127.0.0.1', 'root', '', $dbName);
  8.  
  9. $sql = "SELECT * FROM tasks WHERE task_date LIKE '$day'";
  10. $result = mysqli_query($dbConnection, $sql);
  11.  
  12. while($row = mysqli_fetch_assoc($result)) {
  13. $Name = $row['task_name'];
  14. $StartTime = substr($row['start_time'], 0, 5);
  15. $EndTime = substr($row['end_time'], 0, 5);
  16. $Description = $row['description'];
  17. $TaskId = $row['task_id'];
  18.  
  19. $DropdownId = $TaskId + 1;
  20.  
  21. echo
  22. "
  23. <div class="task">
  24. <div class="taskControlAndTitle">
  25. <p>$Name</p>
  26. <input type="checkbox" id="$TaskId" onclick="showMenu$TaskId()">
  27. <label for="$TaskId">
  28. <img src="mainsource/img/menu.svg">
  29. </label>
  30.  
  31. <div id="$DropdownId">
  32. hey
  33. </div>
  34. </div>
  35.  
  36. <div class="taskBody">
  37. <div class="taskTime">$StartTime | $EndTime</div>
  38. <div class="divider"></div>
  39. $Description
  40. </div>
  41. </div>
  42. ";
  43.  
  44. echo "
  45. <script>
  46. function showMenu$TaskId() {
  47. if ($('$DropdownId').hasClass('showMenu')) {
  48. $('$DropdownId').removeClass('showMenu');
  49. }
  50. else {
  51. $('$DropdownId').addClass('showMenu');
  52. }
  53. }
  54. </script>
  55. ";
  56. }
  57. }
Add Comment
Please, Sign In to add comment