Search

jbachris

I have a news manager built on my site, with loads of news.

What I am trying to do is develop a page to allow people to search through our new archives.

I guess my question is how do I take the info a person enters into the search <input> field to search the news?

I have the page search_news?q="SEARCH ITEM" setup. How do I get this setup?

etully

Read my post about Swishe here:
http://www.phpbuilder.com/board/showthread.php?t=10322465

You take their string, pass it to Swishe which returns a list of URL's on your site. Swishe is Open Source, it's extremely fast, but it takes an intermediate PHP programmer to write the script that interacts with Swishe.

jbachris

etully wrote:
Read my post about Swishe here:
http://www.phpbuilder.com/board/showthread.php?t=10322465

You take their string, pass it to Swishe which returns a list of URL's on your site. Swishe is Open Source, it's extremely fast, but it takes an intermediate PHP programmer to write the script that interacts with Swishe.

Thanks. Looking over Swish-E, not bad. I'd rather set something up to search without Swish-E.

MarkR

If you're using MySQL, one possibility is to use full-text indexing on your data. Read the MySQL manual for more details. It allows you to do a search by keywords instead of a = or "like", and is efficient because it builds (and automatically maintains) an index containing the keywords which it uses during searches.

Mark

jbachris

MarkR wrote:
If you're using MySQL, one possibility is to use full-text indexing on your data. Read the MySQL manual for more details. It allows you to do a search by keywords instead of a = or "like", and is efficient because it builds (and automatically maintains) an index containing the keywords which it uses during searches.

Mark

Thanks.

My question is then:

I have:

<form>
<input size="50" maxlength="150" type="text" name="search_text">
<input type="Submit" name="submit" value="Search News Archives">
</form>

How do I get it to redirect to search.php?search_text=Test

Where I have this query:

SELECT newsID, news_headline, news_story MATCH (news_headline,news_story) AGAINST ('" . $_GET['search_text'] . "') FROM news;

My question is how do I get the code to work so that when the individual clicks the Search News Archives button it'll redirect them to the search page with the search_text info correctly placed?