public function addqueue()
{
if ($this->chars == 9) {
$sql = "SELECT id FROM movies\n \t\t\t\t\tWHERE imdbid = :imdbid";
$resultfrommovies = $this->db->select_query($sql, array(':imdbid' => $_POST['imdbid']));
if (sizeof($resultfrommovies)) {
header("Location:" . URL . "movie/display/" . $resultfrommovies[0]['id']);
break;
}
$sql = "SELECT id FROM queue\n \t\t\t\t\tWHERE imdb = :imdbid";
$resultfromqueue = $this->db->select_query($sql, array(':imdbid' => $_POST['imdbid']));
if (sizeof($resultfromqueue)) {
header("Location:" . URL . "movie/queue");
break;
}
$imdb = new Imdb();
$imdbid = $this->imdbid;
$movieData = $imdb->getMovieInfoById($imdbid);
$title = trim($movieData['title']);
$year = $movieData['year'];
$sql = "SELECT title FROM movies\n\t\t\t\t\tWHERE movies.title = :title\n\t\t\t\t\tUNION\n\t\t\t\t\tSELECT title FROM queue\n\t\t\t\t\tWHERE queue.title = :title";
$result = $this->db->select_query($sql, array(':title' => $title));
if (sizeof($result) == 0) {
$sql = "INSERT INTO queue (imdb , title, year, added)\n\t \t\t\t\t\tVALUES (:imdbid, :title, :year, CURDATE())";
$imdbidt = $this->imdbid;
$result = $this->db->select_query($sql, array(':imdbid' => $imdbidt, ':title' => $title, ':year' => $year));
$mid = $this->db->lastInsertId('id');
foreach ($movieData['genres'] as $genre) {
$param[] = array(':genre' => $genre);
}
$sql = "SELECT id FROM genres\n\t\t\t\t\t\tWHERE genre = :genre";
$result = $this->db->multi_query($sql, $param);
echo '<pre>';
var_dump($result);
echo '</pre>';
foreach ($result as $key => $value) {
echo sizeof($value);
if (sizeof($value) == 0) {
$insertparam[] = $param[$key];
} else {
$genreparam[] = $value[0];
}
}
$sql = "INSERT INTO genres (genre)\n\t\t\t\t\t\tVALUES(:genre)";
$this->db->multi_query($sql, $insertparam);
$gid = $this->db->lastInsertId('id');
for ($i = $gid - sizeof($insertparam) + 1; $i <= $gid; $i++) {
$genreparam[] = $i;
}
$ar = new ArrayTools();
$genres = $ar->unique_flat_array($genreparam);
foreach ($genres as $value) {
$genresin[] = array(':gid' => $value, ':mid' => $mid);
}
$sql = "INSERT INTO genresinqueue (movie_id,genre_id)\n\t\t\t\t\t\tVALUES (:mid,:gid)";
$this->db->multi_query($sql, $genresin);
header("Location:" . URL . "movie/queue");
} else {
$sql = "SELECT id FROM movies\n\t\t\t\t\t\tWHERE title = :title";
$resultfrommovies = $this->db->select_query($sql, array(':title' => $title));
if (sizeof($resultfrommovies) > 0) {
header("Location:" . URL . "movie/display/" . $resultfrommovies[0]['id']);
break;
} else {
header("Location:" . URL . "movie/queue");
}
}
break;
}
$this->viewModel->set('urlValues', $this->urlValues);
$this->viewModel->set('pageTitle', TITLE . 'Köa en film');
return $this->viewModel;
}
