echo "<pre>"; var_dump($movies); } elseif ($_GET["action"] == 'sanatizeall') { $query = "SELECT * from movies"; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); $i = 0; while ($row = mysql_fetch_assoc($result)) { $query = "\n\t\t\t\t\t\tUPDATE `flamestr`.`movies` \n\t\t\t\t\t\tSET\n\t\t\t\t\t\turl = '" . sanitize($row['title'] . "-" . $row['tmdb_id']) . "'\n\t\t\t\t\t\tWHERE id = '" . $row['id'] . "'"; mysql_query($query) or die('Query failed: ' . mysql_error()); $i++; } echo $i . " sanatized"; echo "<a href='import.php' class='btn'>Ready, go back</a>"; } elseif ($_GET["action"] == 'importarray') { ob_end_flush(); $rated = $tmdb->getAccountRatedMovies($_SESSION['tmdb_id'], $_SESSION['tmdb_session_id']); $ratedArr = array(); if ($rated['total_pages'] > 1) { for ($page = 1; $page < $rated['total_pages'] + 1; $page++) { $rated = $tmdb->getAccountRatedMovies($_SESSION['tmdb_id'], $_SESSION['tmdb_session_id'], $page); for ($i = 0; $i < count($rated['results']); $i++) { $ratedArr[] = $rated["results"][$i]['id']; } } } else { for ($i = 0; $i < count($rated['results']); $i++) { $ratedArr[] = $rated["results"][$i]['id']; } } foreach ($ratedArr as $r) { addedit($tmdb, $r, 'rated');