Spotlight search with PHP -

I want to add a spotlight search functionality - Display search results with rich content such as thumbnails etc in a drop down menu Keeping data in the MySQL InnoDB table, on each keyboard event - such as apple.com search - on the site - is basically showing search results based on the portion of the query that already has input (so on Not complete myself B) is based on.

The data is spread across different tables for categories, help pages, blog pages, and more. Search scripts should only keep in mind a subset of columns.

Since this is a popular demand, I think that there are some PHP search engine projects (preferably with open-source and memcatch support), which can be used for regular export of data related to working DB / tables. On the basis can be integrated into the existing system.

Is there a solution there? Which one would you recommend? Or maybe it would be better to implement it in another way?

Thanks

This will be a job for AJAX implementation of JQuery about it See:

Create PHP scripts that display your results, such as someone typed them and clicked a button for 'search', then use an AJAX call on that script and use any Or the proper HTML tag)

Something like this:

Hello.fp

  & lt ;? Php echo "Hello World"; ? & Gt;  

index.html

  & lt; Html & gt; & Lt; Top & gt; & Lt; Script language = "javascript" & gt; Function update_results () {$ .ajax ({url: 'hello.php', success: function (data) {$ ('# result') .html (data);}}); } & Lt; / Script & gt; & Lt; / Head & gt; & Lt; Body & gt; & Lt; Label & gt; Spotlight: & lt; Input id = "q" type = "text" onkeypress = "update_results ()" /> & Lt; / Label & gt; & Lt; Div id = "result" & gt; & Lt; / Div & gt; & Lt; / Body & gt; & Lt; / Html & gt;  

Where Hello. FTP is setup with your beautiful page