PHP AJAX Full search (Quick Search)
- or -
Post a project like this1482
£30(approx. $38)
- Posted:
- Proposals: 10
- Remote
- #2708253
- Awarded
18 years expert in PHP, MySQL, HTML, CSS, JavaScript, jQuery, Ajax, Bootstrap, Chrome Extension, VB, VBA, AutIT Programming & Website Data Scraping
Ambala
WordPress Expert✮Shopify Expert✮Graphic Designer✮AutoCAD 2D & 3D✮CV Writer & Designer✮Fullstack developer
Rawalpindi
23247645108912174511243300244952135656033592621363657336897583707432
Description
Experience Level: Entry
Hi
I am looking for someone to help me build a search box that will search "multiple tables" and return a dropdown of the results using something similar to mysql LIKE %keyword%.
I have 3 tables.
Contacts
id, firstname, lastname, tel
Leads
id, uid, firstname, lastname, postcode, tel, mob
Jobs
id, uid, firstname, lastname, house_number, postcode, tel, mob
I need a search box to search all 3 of these tables and if the keyword matches the above to display in a dropdown box just how Google would do
please note, I would like it so that if someone typed in two keywords "house_number postcode" eg "16 LS26 0JJ" or "firstname lastname" eg "Joe Bloggs" to pull this data from the database. I have seen from some examples that it will only match one column.
The following will be required,
- Bootstrap search box and dropdown styling
- post be submitted live via jquery/ajax
- have PHP file to catch the POST data and return back to Ajax
- must be coded in OOP with PDO with binding
Please note. I do not need a full script building such as database classes etc as I already have a full working login system. I would just like the code that would capture the Ajax POST and the jquery to display it back to the page.
I am looking for someone to help me build a search box that will search "multiple tables" and return a dropdown of the results using something similar to mysql LIKE %keyword%.
I have 3 tables.
Contacts
id, firstname, lastname, tel
Leads
id, uid, firstname, lastname, postcode, tel, mob
Jobs
id, uid, firstname, lastname, house_number, postcode, tel, mob
I need a search box to search all 3 of these tables and if the keyword matches the above to display in a dropdown box just how Google would do
please note, I would like it so that if someone typed in two keywords "house_number postcode" eg "16 LS26 0JJ" or "firstname lastname" eg "Joe Bloggs" to pull this data from the database. I have seen from some examples that it will only match one column.
The following will be required,
- Bootstrap search box and dropdown styling
- post be submitted live via jquery/ajax
- have PHP file to catch the POST data and return back to Ajax
- must be coded in OOP with PDO with binding
Please note. I do not need a full script building such as database classes etc as I already have a full working login system. I would just like the code that would capture the Ajax POST and the jquery to display it back to the page.
Martin H.
100% (13)Projects Completed
7
Freelancers worked with
7
Projects awarded
33%
Last project
9 Feb 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies