PHP search for string and return MYSQL

Hi there!

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.

Skills: AJAX, Javascript, MySQL, PHP

See more: mysql contains statement, mysql instr, mysql contains(), search in php mysql with examples, mysql find space in string, mysql find first character in string, mysql locate, mysql if contains, php search form select mysql, http www pornhub com view video php, php search greek characters mysql, php search string inside pdf file, php search string suggestion, php search twitter save mysql, http www facebook com photo php fbid, http www amazon com php programming development database programmer ebook dp b00yfp9qqk ref sr18 s booksie utf8qid 143497830, http www amazon com php programming development database programmer ebook dp b00yfp9qqk ref sr_1_8 s books&ie utf8&qid 143497830, http www bigmoneyptc com index php ref gwango, http www freelance com fr search mission query pour avoir le master card, http www freelancer com users messages index php thread 86387202

About the Employer:
( 3 reviews ) Nottingham, United Kingdom

Project ID: #19276677

Awarded to:


Hello, sir. Thanks for sharing your project with me, and I hope your project doing well. I have read your project description and I can assist you to develop your Web App I have more than 6+ years of strong exper More

£55 GBP in 1 day
(26 Reviews)

44 freelancers are bidding on average £154 for this job


Hi there, I have gone through your project detail and I have the Exact Match skills as per the current project you are looking now. Also take pride of our 5.0/5.0 Rating-Profile with 600+ Nice-Reviews with 99% Co More

£150 GBP in 3 days
(583 Reviews)

I have a few questions regarding your post, Kindly Note - This is not a standard response, I truly like your post, Yet I would first like to get hands-on for a discussion. Once I inferred each little element, I aim More

£261 GBP in 3 days
(226 Reviews)

Hi, Yes, I have great experience in web development and designing . Sure, I will develop as per your needs. I Have 13 years of experience in web development . I developed many websites plea More

£150 GBP in 1 day
(357 Reviews)

Good morning. I am a PHP developer and ready to work with your project. Could we chat for more details? I hope to create a long-term co-operation with you. It's my pleasure to co-operate with you. Best regards, H More

£155 GBP in 3 days
(246 Reviews)

Hello there, We are ready to work with you, Having 7 year experience in website design and developments. Please ping me for discuss more detail about the project, Also see our recent work. https://thelondonsmith More

£94 GBP in 3 days
(151 Reviews)

I have been working as a full stack web developer for over 5 years. I am highly skilled in Web and App so I feel confident that I can do your job without fail. I can start working right now and I will guarantee the q More

£200 GBP in 3 days
(99 Reviews)

Hello, I think my ability is just Suitable for your job and I can complete your Project perfectly, you will get satisfied result… I have Skills in PHP, MySQL, HTML, CSS, LESS/Sass/SCSS, JavaScript, jQuery, Ajax, Boots More

£111 GBP in 5 days
(236 Reviews)

Greetings sir, how are you today sir? hope fine. Sir, I have read your project details and i will develop the php search script that search through mysql table and show the report/result as you described and yes More

£100 GBP in 1 day
(133 Reviews)

Hello, I will develop the PHP search for string and return MYSQL but I have questions which I want you to answer. I’d really like to work with you on this one if possible! I do have a couple of questions, but fi More

£150 GBP in 3 days
(89 Reviews)

Hi there, I am an experienced PHP developer and I think I can do this job for you. I'm a full-time contractor and ready to start work right now. You can estimate my skill level from the reviews of my past projects. More

£150 GBP in 3 days
(20 Reviews)

Hi dear, I have read through your project description carefully and also checked the attached files. I am highly interested to do your task as I have 7 years of experience. It will be really great if you al More

£211 GBP in 3 days
(20 Reviews)

Hi, Sir. I am very interested in your work. If you hire me, i'll do my best for you and I'll finish in time. Best regards.

£33 GBP in 3 days
(69 Reviews)

Hello sir,, i am ready to work on your project , lets discuss the work in more detail on chat , we have experience and expertise in php and all its frameworks, mysql angularjs, nodejs, html, bootstrap please check the More

£200 GBP in 3 days
(67 Reviews)

Greetings noxford1983! Thanks for sharing the idea "PHP search for string and return MYSQL". I'm so much interested in this project and definitely want to take a part. Kindly open a chat with me to find out further de More

£130 GBP in 6 days
(149 Reviews)

Hello!! I am highly interested applying for this I am PHP developer heaving experience of 5+ years. My key skills are wordpress , codeingiter, laravel, core php, html, css, jquery, mysqli. Till now i have worked on 30 More

£135 GBP in 3 days
(60 Reviews)

Hi, sir. I have seen this project carefully. I am a php expert. I am sure I can do this project asap. Plz contact me. Thank you.

£150 GBP in 3 days
(57 Reviews)

100% completed job and 5 stars Hi, there. My name is Lee, and I am an experienced web developer. I read your job description, and I am interested in your project. I have 6+ years of experiences in developing webs More

£133 GBP in 3 days
(28 Reviews)

Hi, I see that you need to search using MYSQL in which you want some customization work. Yes, I can do the changes according to your required output. Here are some examples of my work:- ====================== More

£234 GBP in 3 days
(19 Reviews)

Hello, I am pleasure with your job for PHP search for string and return MYSQL. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a coupl More

£150 GBP in 3 days
(47 Reviews)

The dear hiring manager, I have read your description and i can start immediately I'm very interested in your job As you can see my profile, I am a expert of web development My Profile : [login to view URL] More

£98 GBP in 0 days
(56 Reviews)