WTB: Search engine for PHP MSSQL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
dkizerian
Forum Newbie
Posts: 7
Joined: Thu Sep 12, 2002 3:32 pm
Location: SLC UTah

WTB: Search engine for PHP MSSQL

Post by dkizerian »

Hi,
I'm looking for a search engine to access an MSSQL DB from PHP. I only need to go through articles in one table, so i don't really think I need to fancy of one.
Any help will be greatly apreciated

Dave
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

SqlServer etc.

Post by fractalvibes »

Your best "Search Engine" in this case is none other than SQL.

You are only needing to query 1 table, so perhaps give them options to
choose to search by date, author, or text within the article, and any other relevant criteria you are storing in the table.

Handle the search in your PHP code via sql queries using appropriate wildcards like:
......WHERE AUTHOR LIKE '" . txtAuthorName . "%'"

You may want to have your DBA examine the table and see where additional indices may speed up the searches.

Phil J.
Post Reply