<!DOCTYPE html>
<html lang="en">
<?php
session_start();
$title = "Write Title";
include '../includes/header.php';
include '../classes/MovieActorDBO.php';
// turn on errors
ini_set('display_errors', 'On');
$DBO = new MovieActorDB();
$_SESSION['review_title'] = $_GET['review_title'];
$title = str_replace("+", " ", $_SESSION['review_title']);
$rows = $DBO->query("SELECT mov_tv.title, mov_tv.release_country, media.id FROM media\n INNER JOIN (SELECT title, media_id, release_country FROM (\n (SELECT title, media_id, release_country FROM movie)\n UNION ALL\n (SELECT title, media_id, release_country from tvshow)\n ) mov_tv\n ) mov_tv ON mov_tv.media_id = media.id\n WHERE title = '" . $title . "'");
$ratings_siteJSON = $DBO->queryJSON("SELECT id, name, max_rating FROM site");
if (count($rows) > 0) {
?>
<body>
<?php
include '../includes/navigation.php';
?>
<div class="container theme-showcase" role="main">
<div id="blockContent" class="page-header">
<table id="findReviewTable" class="table table-bordered">
<thead>
<td></td>
<td>Title</td>
<td>Release Country</td>
</thead>
<?php
$isGET = TRUE;
include '../../includes/header.php';
$movie_id = $_GET['id'];
} else {
$movie_id = $_POST['id'];
}
// turn on errors
ini_set('display_errors', 'On');
$DBO = new MovieActorDB();
$actorsQ = "\n SELECT person.first_name AS fn, person.last_name AS ln, person.birthdate AS bd FROM movie \n INNER JOIN media ON media.id=movie.media_id\n INNER JOIN media_actor ON media_actor.media_id = media.id\n INNER JOIN actor ON actor.id = media_actor.actor_id\n INNER JOIN person ON person.id = actor.person_id \n WHERE movie.id=" . $movie_id . " \n ORDER BY title\n\n ";
$directorsQ = "\n SELECT person.first_name AS fn, person.last_name AS ln, person.birthdate AS bd FROM movie \n INNER JOIN media ON media.id=movie.media_id\n INNER JOIN media_director ON media_director.media_id = media.id\n INNER JOIN director ON director.id = media_director.director_id\n INNER JOIN person ON person.id = director.person_id \n WHERE movie.id=" . $movie_id . " \n ORDER BY title\n\n ";
$movieQ = "\n SELECT movie.title AS title, DATE_FORMAT(movie.release_date, '%M %d, %Y') AS release_date, movie.release_country AS release_country, movie.runtime AS runtime, movie.content_rating AS content_rating,\n person.first_name AS first_name, person.last_name AS last_name,\n GROUP_CONCAT(DISTINCT genre.genre_type ORDER BY genre.genre_type SEPARATOR ', ') AS genre_type\n FROM movie \n INNER JOIN media ON media.id=movie.media_id\n INNER JOIN media_actor ON media_actor.media_id = media.id\n INNER JOIN actor ON actor.id = media_actor.actor_id\n INNER JOIN person ON person.id = actor.person_id \n INNER JOIN movie_genre ON movie_genre.movie_id = movie.id\n INNER JOIN genre ON genre.id = movie_genre.genre_id\n WHERE movie.id=" . $movie_id . " \n ORDER BY title\n\n ";
$ratingQ = "\n SELECT rating.rating AS rating, rating.rating_url AS rating_url, site.name AS site_name, site.max_rating AS max_rating FROM movie\n INNER JOIN media ON media.id = movie.media_id\n INNER JOIN rating ON rating.media_id = media.id\n INNER JOIN site ON site.id = rating.site_id\n WHERE movie.id=" . $movie_id . "\n ORDER BY site_name;\n ";
$actorRows = $DBO->query($actorsQ);
$directorRows = $DBO->query($directorsQ);
$movieJSON = $DBO->queryJSON($movieQ);
$ratingRows = $DBO->query($ratingQ);
if ($isGET) {
echo "<body>";
include '../../includes/navigation.php';
echo '<div class="container theme-showcase" role="main">';
//echo '<div id="blockContent" class="page-header jumbotron">';
}
?>
<section class="ivt-section">
<div class="col-sm-8 col-8 col-xs-12 no-padding">
<div class="ivt-name">
<ul>
<h1 id='title'> </h1>
<li>Genre(s)</li>
<li>Release Date</li>
<?php
$title = "Add Episode";
include '../classes/MovieActorDBO.php';
$DBO = new MovieActorDB();
$result = $DBO->queryJSON("SELECT episode_title, episode_number, season FROM tvshow_episode \n WHERE tvshow_id = (SELECT id FROM tvshow WHERE title = '" . $_GET['tvshow'] . "') AND\n episode_number = " . $_GET['number'] . " AND\n season = " . $_GET['season'] . "");
$array = json_decode($result);
if (count($array) > 0) {
echo $result;
} else {
$insert = $DBO->queryJSON("INSERT INTO tvshow_episode (tvshow_id, airdate, episode_title, runtime, episode_number, season) VALUES\n ((SELECT id FROM tvshow WHERE title = '" . $_GET['tvshow'] . "'), \n '" . $_GET['date'] . "', '" . $_GET['title'] . "', " . $_GET['runtime'] . ", " . $_GET['number'] . ", " . $_GET['season'] . ")");
}
<!DOCTYPE html>
<html lang='en'>
<?php
$title = "Add to DB";
include '../includes/header.php';
include '../classes/MovieActorDBO.php';
$DBO = new MovieActorDB();
$movieShowJSON = $DBO->queryJSON("\n SELECT movie.title AS title, movie.media_id AS media_id FROM movie\n UNION ALL\n SELECT tvshow.title AS title, tvshow.media_id AS media_id FROM tvshow\n ORDER BY title ASC\n ");
$tvShowJSON = $DBO->queryJSON("\n SELECT title FROM tvshow\n ORDER BY title ASC\n ");
$genresJSON = $DBO->queryJSON("\n SELECT genre.genre_type AS genre FROM genre\n ORDER BY genre ASC\n ");
?>
<body>
<?php
include '../includes/navigation.php';
?>
<div id="addContainer" class="container theme-showcase addForms" role="main">
<div id="blockContent" class="page-header">
<form class="addForms form-inline">
<fieldset>
<legend>Person</legend>
<label for="first_name">First Name:</label>
<input type="text" class="form-control" name="first_name" id="first_name">
<label for="last_name">Last Name:</label>
<input type="text" class="form-control" name="last_name" id="last_name">
<label for="birthday">Birthday:</label>
<input type="date" class="form-control" name="birthday" id="birthday">
<input type="radio" name="role" id="role" value="actor" checked="checked"/>Actor
<input type="radio" name="role" id="role" value="director"/>Director
<?php
$title = "Get Site Max";
include '../classes/MovieActorDBO.php';
// turn on errors
ini_set('display_errors', 'On');
$DBO = new MovieActorDB();
$site = str_replace("+", " ", $_GET['site_name']);
$results = $DBO->queryJSON("SELECT max_rating FROM site WHERE site.name = '" . $site . "'");
echo $results;
}
$ratingString .= ")";
if (!strcmp(substr($queryString, -6), "WHERE ")) {
$queryString .= $ratingString;
} else {
$queryString .= " AND " . $ratingString;
}
}
}
$endString = " GROUP BY id \n ) AS movie_reqs on movie_reqs.id = media.id\n GROUP BY title\n ORDER BY title";
$queryString .= $endString;
$rows = $DBO->query($queryString);
} else {
$rows = $DBO->query("\n SELECT movie.id AS movie_id, title, release_date, release_country, runtime, content_rating, GROUP_CONCAT(genre.genre_type ORDER BY genre.genre_type SEPARATOR ', ') AS genre_type FROM movie \n LEFT JOIN movie_genre ON movie_genre.movie_id = movie.id \n LEFT JOIN genre ON genre.id = movie_genre.genre_id \n GROUP BY title\n ORDER BY title");
}
$genresJSON = $DBO->queryJSON("\n SELECT genre.genre_type AS genre FROM genre\n ORDER BY genre ASC\n ");
?>
<body>
<?php
include '../includes/navigation.php';
?>
;
<div class="container theme-showcase" role="main">
<div id="blockContent" class="page-header">
<table id="mainTable" class="table table-bordered">
<caption id="tableCaption">Movies</caption>
<thead>
<td>Movie Title</td>
<td>Release Date</td>
<td>Release Country</td>
<td>Runtime</td>
include '../../includes/header.php';
$tvshow_id = $_GET['id'];
} else {
$tvshow_id = $_POST['id'];
}
// turn on errors
ini_set('display_errors', 'On');
$DBO = new MovieActorDB();
$actorsQ = "\n SELECT person.first_name AS fn, person.last_name AS ln, person.birthdate AS bd FROM tvshow \n INNER JOIN media ON media.id=tvshow.media_id\n INNER JOIN media_actor ON media_actor.media_id = media.id\n INNER JOIN actor ON actor.id = media_actor.actor_id\n INNER JOIN person ON person.id = actor.person_id \n WHERE tvshow.id=" . $tvshow_id . " \n ORDER BY tvshow.title\n\n ";
$directorsQ = "\n SELECT person.first_name AS fn, person.last_name AS ln, person.birthdate AS bd FROM tvshow \n INNER JOIN media ON media.id=tvshow.media_id\n INNER JOIN media_director ON media_director.media_id = media.id\n INNER JOIN director ON director.id = media_director.director_id\n INNER JOIN person ON person.id = director.person_id \n WHERE tvshow.id=" . $tvshow_id . " \n ORDER BY tvshow.title\n\n ";
$tvshowQ = "\n SELECT tvshow.title AS title, tvshow.start_year AS start_year, tvshow.end_year AS end_year, \n tvshow.release_country AS release_country, tvshow.content_rating AS content_rating,\n person.first_name AS first_name, person.last_name AS last_name,\n GROUP_CONCAT(DISTINCT genre.genre_type ORDER BY genre.genre_type SEPARATOR ', ') AS genre_type\n FROM tvshow \n INNER JOIN media ON media.id=tvshow.media_id\n INNER JOIN media_actor ON media_actor.media_id = media.id\n INNER JOIN actor ON actor.id = media_actor.actor_id\n INNER JOIN person ON person.id = actor.person_id \n INNER JOIN tvshow_genre ON tvshow_genre.tvshow_id = tvshow.id\n INNER JOIN genre ON genre.id = tvshow_genre.genre_id\n WHERE tvshow.id=" . $tvshow_id . " \n ORDER BY title\n\n ";
$episodesQ = "\n SELECT tvshow_episode.airdate AS airdate, tvshow_episode.episode_title AS title, tvshow_episode.runtime AS runtime, tvshow_episode.season AS season, tvshow_episode.episode_number AS number FROM tvshow_episode\n INNER JOIN tvshow ON tvshow.id = tvshow_episode.tvshow_id\n WHERE tvshow.id=" . $tvshow_id . "\n ORDER BY season, number ASC\n ";
$ratingQ = "\n SELECT rating.rating AS rating, rating.rating_url AS rating_url, site.name AS site_name, site.max_rating AS max_rating FROM tvshow\n INNER JOIN media ON media.id = tvshow.media_id\n INNER JOIN rating ON rating.media_id = media.id\n INNER JOIN site ON site.id = rating.site_id\n WHERE tvshow.id=" . $tvshow_id . "\n ORDER BY site_name;\n ";
$actorRows = $DBO->query($actorsQ);
$directorRows = $DBO->query($directorsQ);
$tvshowJSON = $DBO->queryJSON($tvshowQ);
$episodeRows = $DBO->query($episodesQ);
$ratingRows = $DBO->query($ratingQ);
if ($isGET) {
echo "<body>";
include '../../includes/navigation.php';
echo '<div class="container theme-showcase" role="main">';
//echo '<div id="blockContent" class="page-header jumbotron">';
}
?>
<section class="ivt-section">
<div class="col-sm-8 col-8 col-xs-12 no-padding">
<div class="ivt-name">
<ul>
<h1 id='title'> </h1>
<li>Genre(s)</li>
