<?php require_once "../includes/session.php"; require_once "../includes/db_connection.php"; require_once "../includes/functions.php"; require_once "../includes/validation_functions.php"; $episode_set = episode_search("EpID"); $episodes_per_page = 16; if ($episode_set == null) { die("Value not found. "); } else { $total_episodes = mysqli_num_rows($episode_set); $pages = (int) ceil($total_episodes / $episodes_per_page); } $table = ""; if ($total_episodes == 0) { $table .= "No episodes found. "; } for ($page = 1; $page <= $pages; $page++) { $table .= "<script>console.log(\"pages:" . $pages . "\");</script>"; $table .= "<script>console.log(\"total_episodes:" . $total_episodes . "\");</script>"; $table .= "<script>console.log(\"total_episodes / episodes_per_page:" . $total_episodes / $episodes_per_page . "\");</script>"; $episode = mysqli_fetch_assoc($episode_set); /* sometimes this thing will say it has more rows than there are acutally episodes, this is coming from sql. I do this check here to stop the program from generating an unecesary page. */ if ($episode) { $table .= "<ul class=\"medium-block-grid-4 episode_search_result_table\" id=\"episode_result_page_" . $page . "\""; $table .= ">"; $count = 1; while ($episode && $count <= $episodes_per_page) {
<?php require_once "../includes/session.php"; require_once "../includes/db_connection.php"; require_once "../includes/functions.php"; require_once "../includes/validation_functions.php"; confirm_logged_in(); $episode_set = episode_search(); $episodes_per_page = 12; if ($episode_set == null) { die("Value not found. "); } else { $total_episodes = mysqli_num_rows($episode_set); $pages = (int) ceil($total_episodes / $episodes_per_page); } $table = ""; for ($page = 1; $page <= $pages; $page++) { $table .= "<table class=\"cms_episode_search_result_table\" id=\"cms_episode_result_page_" . $page . "\""; $table .= "<thead>"; $table .= "<th>Episodes</th>"; $table .= "<th>Actions</th>"; $table .= "</thead>"; $table .= "<tbody>"; $count = 1; $episode = mysqli_fetch_assoc($episode_set); while ($episode && $count <= $episodes_per_page) { $table .= "<tr id=\"EpID_" . $episode["EpID"] . "\" class=\"cms_episode_search_result_row\">"; $table .= "<td class=\"cms_episode_search_result_name\">" . htmlentities($episode["EpName"]) . "</td>"; $table .= "<td><a href=\"edit_episode.php?episode=" . urlencode($episode["EpID"]) . "\">Edit</a>"; $table .= " <a href=\"delete_episode.php?episode=" . urlencode($episode["EpID"]) . "\""; $table .= " onclick=\"return confirm('Are you sure?');\"";