PHP AJAX Full search (Quick Search)

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.