I'd like a PHP that searches through a MySQL table called SRT.
I've screenshot and attached the MySQL structure. This table within the database, stores SRT files (attached example) - which are subtitles for films.
I'd like the user to search for part of a film quote: for example "I'm batman" and it will search through the table.
The required output:
-show the IMDBID and TMDBID (also stored in the table) that the quote is in.
-show the quote and the time that it is in the film.
-have an "in context button" - which shows the previous line and next line of the quote.
-If the quote appears in the film more than once, open to show the other occurrences. Therefore each film must only appear once.
- the search should be able to search through potentially 1000s of SRT files quickly.
This is a simplified version of: [login to view URL]
No CSS styling is required.