<?php
require_once __DIR__ . '/../includes/mysqli_connect.php';
require_once __DIR__ . '/../includes/functions.php';
$time_start = microtime(true);
set_time_limit(86400);
$count = 0;
if ($i = $mysqli->query("SELECT id, imdb_id FROM movies")) {
while ($mov = mysqli_fetch_assoc($i)) {
$count++;
$imdb = get_imdb_rating($mov['imdb_id']);
mysqli_query($mysqli, "DELETE FROM imdb WHERE id=" . $mov['id']);
mysqli_query($mysqli, "INSERT INTO imdb VALUES (" . $mov['id'] . ",'{$imdb}','" . date('Y-m-d H:i:s') . "')");
}
}
$mysqli->close();
$time_end = microtime(true);
$execution_time = $time_end - $time_start;
// REPORTING
echo "\n---------------------------\n\n";
echo "Finished executing " . __FILE__ . " at " . date('g:i:s A') . " on " . date('F j, Y') . ".\n";
echo "Total Execution Time: " . $execution_time / 60 . " minutes (" . $execution_time / 3600 . " hours)";
if ($count) {
echo "\n" . $count . " requests in " . $execution_time . " seconds means 1 request in " . $execution_time / $count . " seconds.";
}
echo "\n\n---------------------------\n";
$synopsis = mysql_escape_string($m->overview);
$images = getData("https://api.themoviedb.org/3/movie/{$id}/images?api_key={$apikey}");
if ($images === NULL) {
echo "Error parsing images, id {$id}";
} else {
foreach ($images->backdrops as $bd) {
if ($bd->aspect_ratio > 1.7) {
$backdrop = $bd->file_path;
break;
}
}
}
$img_link = $m->poster_path;
$imdb_id = $m->imdb_id;
if (strlen($imdb_id) > 0) {
$imdb_rating = get_imdb_rating($imdb_id);
$language = get_language($imdb_id);
} else {
$language = ucfirst(mysql_escape_string($m->spoken_languages[0]->name));
}
$popularity = $m->popularity;
$revenue = $m->revenue;
$tagline = mysql_escape_string($m->tagline);
if ($m->adult == "true") {
$adult = 1;
} else {
$adult = 0;
}
$timestamp = date('Y-m-d H:i:s');
// keywords
$keywordData = getData("https://api.themoviedb.org/3/movie/{$id}/keywords?api_key={$apikey}");