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