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
WTB: Search engine for PHP MSSQL
Moderator: General Moderators
-
fractalvibes
- Forum Contributor
- Posts: 335
- Joined: Thu Sep 26, 2002 6:14 pm
- Location: Waco, Texas
SqlServer etc.
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.
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.