I have a website about movies made in PHP (codeigniter), I intend to use the API of themoviedb.org website to search and show information for users. And the first time I use an API and would like to get some questions.
I can already make the request using cURL, but only one movie at a time using its ID in the URL request. My idea is to display a list of the movies already registered on the site, without having to be doing the search when the user wants to see the information.
The first question is whether there is a way to do multiple API requests by bringing all records, and the second is how best to save the data in my database, save the entire JSON, or separate the data into fields in an EX table: (FILM: movie_title, date_campaign, etc ...).