function make_episode_cell($id, $html_under_cell = "")
{
$episode = get_episode_by_id($id);
if ($episode == null) {
die("Episode not found.");
}
$output = "";
$url = "video.php?e=" . $id;
$output .= "<li>";
$output .= "<div class=\"video_item\">";
$output .= "<a href=\"" . $url . "\">";
$thumbnail = "images/thumbnails/" . $episode["EpID"] . ".jpg";
$output .= "<img src=\"";
file_exists($thumbnail) ? $output .= $thumbnail : ($output .= "images/thumbnails/default.jpg");
$output .= "\">";
$output .= "</a>";
$output .= "<a class=\"episode_name_link\" href=\"" . $url . "\">";
$output .= "<div class=\"episode_name\"> " . $episode["EpName"] . " </div> ";
$output .= "</a>";
$output .= "<div class=\"category_link_wrapper\">";
$output .= "Category: ";
$category1_url = "category.php?category=" . $episode["Category1"];
$category1_name = get_category_by_id($episode["Category1"])["name"];
$output .= "<a class=\"category_link\" href=\"" . $category1_url . "\">" . ucfirst($category1_name) . "</a>";
$output .= "<script>console.log( " . $episode["Category2"] . " ) </script> ";
if ($episode["Category2"] != "0") {
$output .= ", ";
$category2_url = "category.php?category=" . $episode["Category2"];
$category2_name = get_category_by_id($episode["Category2"])["name"];
$output .= "<a class=\"category_link\" href=\"" . $category2_url . "\">" . ucfirst($category2_name) . "</a>";
}
$output .= "</div>";
$output .= "<div> Season " . $episode["Season"] . " , Episode " . $episode["EpNum"] . " </div>";
$output .= "</div>";
$output .= $html_under_cell;
$output .= "</li>";
return $output;
}
<?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();
$current_episode = get_episode_by_id($_GET["episode"]);
if (!$current_episode) {
// Subject ID was missing or invalid or
// subject couldn't be found in database.
redirect_to("manage_content.php");
}
$id = $current_episode["EpID"];
$query = "DELETE FROM episodes WHERE EpID = {$id} LIMIT 1";
$result = mysqli_query($connection, $query);
// Test if there was a query error
if ($result && mysqli_affected_rows($connection) == 1) {
// Success
$_SESSION["message"] = "Episode deleted.";
redirect_to("manage_content.php");
} else {
// Failure
$_SESSION["message"] = "Episode deletion failed." . mysqli_error($connection);
redirect_to("manage_content.php");
}
<?php
require_once "../includes/session.php";
require_once "../includes/db_connection.php";
require_once "../includes/functions.php";
include "../includes/layouts/header.php";
if (!isset($_GET["e"])) {
set_error_output("No episode selected. ");
} else {
$episode = get_episode_by_id($_GET["e"]);
if ($episode == null) {
set_error_output("Episode not found. ");
}
}
?>
<div class="row">
<div class="large-9 medium-9 columns">
<div class="panel">
<h3><?php
echo $episode["EpName"];
?>
</h3>
<!-- going to have to replace these query strings in my php -->
<!--iframe src="http://videowing.me/embed/85ef0549e876ca9759874370ffc7f133?w=718&h=438" scrolling="no" width="718" height="438" marginheight="0" marginwidth="0" frameborder="0"></iframe-->
<iframe src="<?php
echo $episode["VidLink"];
?>
"
scrolling="no" width="680" height="438" marginheight="0" marginwidth="0" frameborder="0"></iframe>
