search box

Tomcat13

Hello everyone,

I'd like to create a search box on my pages, so when visitors look for a news article by name, date, or whatever, that I have stored in my db, they' ll be able to find it..

Can someone give me the code, or give me a link that explains how the whole thing works, please..

Thank you in advance

bogu

Here u may find the mysql approach: http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html

Tomcat13

Thanks bogu.

I'll check it out.

Tomcat13

OK, I looked at the code.

Now, how do I create the actual search box on my pages? Do I use HTML or a script?

How do I do that?

Thanks

jansky

you have to do some script to able do the search function.


 $string=$_POST["stringsearch"];
   $sql = mysql_query("select * from yourtable where fieldname like '%$string%'");
// process result here

Tomcat13

Tomcat13 wrote:
Hello everyone,

I'd like to create a search box on my pages, so when visitors look for a news article by name, date, or whatever, that I have stored in my db, they' ll be able to find it..

Can someone give me the code, or give me a link that explains how the whole thing works, please..

Thank you in advance

The above is my original messase that I started this topic with.
Now it shouldn't be that hard to get a detailed answer, should it...

I don't want part of the code.
When you throw me 2-3 lines of code, it's worthless to me, to say the least, obviously, because I am not an expert in PHP and MySQL. If I were, I wouldn't be asking questions as such.
I want something more "concrete", something with "detail".

This is what I want:

a form or whatever it takes to create the actual search box.
the code to retrieve an article when a visitor to my website does a search, by "id" or "date" or "article" name, to be able to find or get something, from a single table that I have created in my db,
I don't want a search engine.
All I want is a simple search box to search my db/MySQL, and come up with my articles.

Please...

And last but not least, I will say that in the past I have received a lot of good help in this Forum. Thanks!

j-dearden

If the code is worthless m8 do some reading you wont learn anything jus looking at other peoples code and slapping it in ure work. think of the logic its not difficult at all.

as jansky stated you need to pass the value entered by the user onto a script that will process the information and in turn do something with it. do some searches on how to display query results, theres planty of examples lying on the net, im sure ul sus it out sooner or later.