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.

Kemahiran: AJAX, Javascript, MySQL, PHP

Lihat lagi: 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

Tentang Majikan:
( 3 ulasan ) Nottingham, United Kingdom

ID Projek: #19276677

Dianugerahkan kepada:


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 Lagi

£55 GBP dalam sehari
(26 Ulasan)

44 pekerja bebas membida secara purata £154 untuk pekerjaan ini


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 Lagi

£150 GBP dalam 3 hari
(583 Ulasan)

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 Lagi

£261 GBP dalam 3 hari
(226 Ulasan)

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 Lagi

£150 GBP dalam sehari
(357 Ulasan)

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 Lagi

£155 GBP dalam 3 hari
(246 Ulasan)

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 Lagi

£94 GBP dalam 3 hari
(151 Ulasan)

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 Lagi

£200 GBP dalam 3 hari
(99 Ulasan)

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 Lagi

£111 GBP dalam 5 hari
(236 Ulasan)

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 Lagi

£100 GBP dalam sehari
(133 Ulasan)

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 Lagi

£150 GBP dalam 3 hari
(89 Ulasan)

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. Lagi

£150 GBP dalam 3 hari
(20 Ulasan)

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 Lagi

£211 GBP dalam 3 hari
(20 Ulasan)

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 dalam 3 hari
(69 Ulasan)

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 Lagi

£200 GBP dalam 3 hari
(67 Ulasan)

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 Lagi

£130 GBP dalam 6 hari
(149 Ulasan)

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 Lagi

£135 GBP dalam 3 hari
(60 Ulasan)

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 dalam 3 hari
(57 Ulasan)

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 Lagi

£133 GBP dalam 3 hari
(28 Ulasan)

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:- ====================== Lagi

£234 GBP dalam 3 hari
(19 Ulasan)

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 Lagi

£150 GBP dalam 3 hari
(47 Ulasan)

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] Lagi

£98 GBP dalam 0 hari
(56 Ulasan)