We have a website that translates srt files through the google widget tool and we had the ability to save translated srt files to the mysql database and possibility to be displayed on our website and from which visitors can search and download saved subtitles from the website database.
More recently, a freelancer worked on this project for us and made a database for subtitles and the ability to display the database and searching option on our website page but didn't do a good securty against SQL injection and someone possible did a SQL inject on our website and deleted all subtitles form the website but not from the database and not from the folder where they are stored in our hosting.
I need someone who has a good understanding of MySQL and php language well to fix this and recover subtitles from the database to be displayed on my website again and that visitors again have the ability to save srt subtitlesas well as search them .
In MySQL database I have all the subtitles in the table and in the folder on my hosting there are all srt files, they just don't show up on my web site and the ability to save srt subtitles doesn't work anymore, so I need that fix:
1. the ability to restore and display all the subtitles from MySQL databases
2. Ability to save srt subtitles via website in mysql database and displey on the website page that visitors can search it and download it in srt/zip format.
The previous freelancer created the script and linked the MySQL database to the php script and you can freely modify and repair the existing script just to correct securty for SQL injection.
And please do not ask for more money than the amount for which you made the bid!
Please do not apply for a job if you cannot complete it, if you need more details feel free to contact me!