PHP Search Script

[ElaineB]

Horrible newbie Elaine here again ...

I am looking to find a PHP script or possibly write one that will allow me to search (boolean etc) my mySQL db and return results into an HTML formatted page. Is there some kind of simple way of doing this in PHP or should I look for a prewritten script to do this?

Thank you in advance.

Elaine

[keith73]

It depends on how sophisticated your search needs to be.

If it needs to search big blocks of test for multiple words or phrases, try a Full Text search.

http://www.mysql.com/doc/en/Fulltext_Search.html

If you just need to match certain columns that are limited in character length, such as a username field, just use a WHERE username = or WHERE username like '%username%'

• keith

[ElaineB]

Keith

Much thanks for the information. Will I be limited to what i can search for in that the person can only type specific strings of text?

Sorry if that question makes no sense. 🙂

What I meant to ask is will it allow for "and"s and "or"s etc?

Elaine

[keith73]

post an example of a search you want to perform. And examples of what the database table (or tables) look like so we can figure out what type of search would work best.

• keith

[greg252]

A lot of search pages use radios for AND and NOT.
Simply replace the blank space with the value of the group- either || or && as applies in the query.

[zbee]

If what you want is simple you can check this page:
http://www.swanilda.com/unix.html

it has a lot of useful stuff to connect a db with dreamweaver and makes the code for you.