<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>
