<?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?');\"";
