<tbody> <?php $sort = " "; if (isset($_GET['name'])) { $sort = 2; } if (isset($_GET['topic'])) { $sort = 6; } if (isset($_GET['time'])) { $sort = 3; } if (isset($_GET['status'])) { $sort = 5; } if (isset($_GET['school'])) { $sort = 7; } $data = new DataLayer(); $res = $data->getAll($sort, $_SESSION['school'], $_SESSION['sec']); foreach ($res as $row) { echo "<tr>\n <td>{$row['2']}</td>\n <td>{$row['3']}</td>\n <td>{$row['6']}</td>\n <td>{$row['7']}</td>\n <td>{$row['8']}</td>\n <td>{$row['5']}</td>\n <td><a href='{$row['4']}'>{$row['4']}</a></td>\n </tr>"; } ?> </tbody> </table> </div> </div> </div> </div> </body>
$sort = 2; } if (isset($_GET['topic'])) { $sort = 3; } if (isset($_GET['status'])) { $sort = 5; } if (isset($_GET['time'])) { $sort = 6; } if (isset($_GET['select_ses'])) { $school = strip_tags(trim($_GET['school'])); $sec = strip_tags(trim($_GET['sec'])); if (isset($school) && isset($sec)) { $res = $data->getAll($sort, $school, $sec); } } else { $res = $data->getAll($sort); } foreach ($res as $row) { echo "<tr>\n <form method='post' onsubmit='return validateFields();' action='topicApproval.php'>\n <td>{$row['2']}</td>\n <td>{$row['3']}</td>\n <td>{$row['6']}</td>\n <td>{$row['5']}</td>\n <td>\n <select name='status' id='status'>\n <option value='pending'>Pending</option>\n <option value='approved'>Approved</option>\n <option value='denied'>Denied</option>\n </select>\n </td>\n <td>\n <input type='hidden' name='id' id='id' value='{$row['0']}' />\n <input type='submit' name='change_status' value='update'/>\n </td>\n </form>\n </tr>"; } } ?> </tbody> </table> </div> </div> </div> </div>