Search entire database?

Kuraden

Hello I am wondering if it is possible to search an entire database with php, not just a certain table or column. If so, what is the coding for it? Thanks!

tasistro

Can you be more descriptive on your needs. Do you have a sample database?

Kuraden

I have a database for my website and each table represents a section of content for the site. I want to have a search engine that would go through each table in the database to find information.

Weedpacket

You could keep another table of searchable tables/columns
(each searchable column in each table would be represented by a record naming the table and column) ... a bit different from just using PHP's functions to extract all the information about a database, because there would no doubt be a lot of fields you wouldn't be interested in searching on.

Then loop through that in your search.

s_shrum

I believe what you are looking for is specifically refered to as FULL TEXT searching.

What database are you using? (I'd assume MySQL but I've learned better than to assume much).

Sean Shrum
http://www.shrum.net