Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function PrintTasks($day)
- {
- global $dbConnection;
- global $dbName;
- $dbName = 'db_planner_laurens';
- $dbConnection = mysqli_connect('127.0.0.1', 'root', '', $dbName);
- $sql = "SELECT * FROM tasks WHERE task_date LIKE '$day'";
- $result = mysqli_query($dbConnection, $sql);
- while($row = mysqli_fetch_assoc($result)) {
- $Name = $row['task_name'];
- $StartTime = substr($row['start_time'], 0, 5);
- $EndTime = substr($row['end_time'], 0, 5);
- $Description = $row['description'];
- $TaskId = $row['task_id'];
- $DropdownId = $TaskId + 1;
- echo
- "
- <div class="task">
- <div class="taskControlAndTitle">
- <p>$Name</p>
- <input type="checkbox" id="$TaskId" onclick="showMenu$TaskId()">
- <label for="$TaskId">
- <img src="mainsource/img/menu.svg">
- </label>
- <div id="$DropdownId">
- hey
- </div>
- </div>
- <div class="taskBody">
- <div class="taskTime">$StartTime | $EndTime</div>
- <div class="divider"></div>
- $Description
- </div>
- </div>
- ";
- echo "
- <script>
- function showMenu$TaskId() {
- if ($('$DropdownId').hasClass('showMenu')) {
- $('$DropdownId').removeClass('showMenu');
- }
- else {
- $('$DropdownId').addClass('showMenu');
- }
- }
- </script>
- ";
- }
- }
Add Comment
Please, Sign In to add comment