<?php require_once __DIR__ . '/../includes/mysqli_connect.php'; require_once __DIR__ . '/../includes/functions.php'; $time_start = microtime(true); set_time_limit(86400); header('Content-Type: text/html; charset=utf-8'); $mysqli->set_charset("utf8"); $count = 0; if ($i = $mysqli->query("SELECT id FROM actors")) { while ($person = mysqli_fetch_assoc($i)) { $id = getPersonType($person['id']); mysqli_query($mysqli, "UPDATE actors SET person_id = {$id} WHERE id = {$person['id']}"); } } $mysqli->close(); $time_end = microtime(true); $execution_time = $time_end - $time_start; //execution time of the script // 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";
// assume you have an actor id $id. Also assume you have included includes/functions.php (so you have getData) // you should have an array of queries at the end: one for movies, one for keywords, one for movie_keywords, one for imdb, $moviesQuery at the end, to insert the movie. // check if we already have this person in DB $count = mysqli_fetch_assoc($mysqli->query("SELECT COUNT(id) FROM actors WHERE id={$id}")); $doNotHave = $count['COUNT(id)'] == 0 ? true : false; $queryArr = array(); if ($doNotHave) { $a = getData("https://api.themoviedb.org/3/person/{$id}?api_key={$apikey}"); if ($a === NULL) { echo 'Error parsing json'; continue; } if (strlen($a->name) > 0) { $name = $a->name; $person_id = getPersonType($id); $photo = $a->profile_path; $about = $a->biography; $dob = $a->birthday; $dod = $a->deathday; $imdb_id = $a->imdb_id; //mysqli_query($mysqli, "DELETE FROM actors WHERE id=$id"); $b = getData("https://api.themoviedb.org/3/person/{$id}/tagged_images?api_key={$apikey}"); $backdrop = ""; $backdrop_id = 0; if ($b->results[0]) { foreach ($b->results as $bd) { if ($bd->aspect_ratio > 1.7) { $backdrop = $bd->file_path; $backdrop_id = $bd->media->id; break;