Creating a Search Class that searches any database

[flaab]

Hi =)

 

I've been requested by a client to implement a search engine on it's website. I told him that he does not need it, but he thundered on and well...Who cares, he' s gonna pay for it.

 

I've made search methods for other sites, but I would like to implement a portable one. A Search Class that could work for any DataBase and with ease of configuration.

 

Maybe de constructor could receive a database name in which to search.

 

And the function search, could receive an array of tables in which to search on and a string to search for on those tables.

 

The question is...how would u implement the way that the class returns results?

 

Nowadays any pro site has the MVC controller. That means that almost all tables in the database have its corresponding model.  Table clientes correspond to the Client Model.

 

How would you implement the results return?

 

Cheers!