i have created a search option for a site to get movie details using mysql database BUT i want to connect them using the omdb api but i cant figure out please help me with this
this is my db connection using mysql database
<?php
//variables
$server = "localhost";
$username = "root";
$password = "";
$dbname = "devsearch";
$conn = mysqli_connect($server, $username, $password, $dbname);
OMDb API: http://www.omdbapi.com/?i=tt3896198&apikey=[MY_API_KEY]
If your question is about how to retrieve information from the Open Movie Database, with a PHP script, you can use this PHP code:
function getImdbRecord($ImdbId, $ApiKey)
{
$path = "http://www.omdbapi.com/?i=$ImdbId&apikey=$ApiKey";
$json = file_get_contents($path);
return json_decode($json, TRUE);
}
$data = getImdbRecord("tt3896198", "f3d054e8");
echo "<pre>";
print_r($data);
echo "</pre>";
Please read the tip in the PHP manual about fopen wrappers if you have trouble reading from an URL.
The code above will return this result:
Array
(
[Title] => Guardians of the Galaxy Vol. 2
[Year] => 2017
[Rated] => PG-13
[Released] => 05 May 2017
[Runtime] => 136 min
[Genre] => Action, Adventure, Comedy, Sci-Fi
[Director] => James Gunn
[Writer] => James Gunn, Dan Abnett (based on the Marvel comics by), Andy Lanning (based on the Marvel comics by), Steve Englehart (Star-Lord created by), Steve Gan (Star-Lord created by), Jim Starlin (Gamora and Drax created by), Stan Lee (Groot created by), Larry Lieber (Groot created by), Jack Kirby (Groot created by), Bill Mantlo (Rocket Raccoon created by), Keith Giffen (Rocket Raccoon created by), Steve Gerber (Howard the Duck created by), Val Mayerik (Howard the Duck created by)
[Actors] => Chris Pratt, Zoe Saldana, Dave Bautista, Vin Diesel
[Plot] => The Guardians struggle to keep together as a team while dealing with their personal family issues, notably Star-Lord's encounter with his father the ambitious celestial being Ego.
[Language] => English
[Country] => USA
[Awards] => Nominated for 1 Oscar. Another 12 wins & 42 nominations.
[Poster] => https://m.media-amazon.com/images/M/MV5BMTg2MzI1MTg3OF5BMl5BanBnXkFtZTgwNTU3NDA2MTI@._V1_SX300.jpg
[Ratings] => Array
(
[0] => Array
(
[Source] => Internet Movie Database
[Value] => 7.7/10
)
[1] => Array
(
[Source] => Rotten Tomatoes
[Value] => 84%
)
[2] => Array
(
[Source] => Metacritic
[Value] => 67/100
)
)
[Metascore] => 67
[imdbRating] => 7.7
[imdbVotes] => 489,848
[imdbID] => tt3896198
[Type] => movie
[DVD] => 22 Aug 2017
[BoxOffice] => $389,804,217
[Production] => Walt Disney Pictures
[Website] => https://marvel.com/guardians
[Response] => True
)