keyword searches of mysql db from browser

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
rlgriffo
Forum Newbie
Posts: 4
Joined: Sun Aug 03, 2008 1:44 am

keyword searches of mysql db from browser

Post by rlgriffo »

Hi,

I am slowly learning a little about mysql and PHP and am finding it challenging but exciting.

I figured out how to create a database and table and then allow new data to be entered into the table from a HTML/Browser form.

The next thing I am trying to figure out it how to allow visitors to my site to do keyword searches which will return results from the mysql database. For example if they are looking for a hairdresser - they could do a keyword search for "hairdresser" and it will return every entry in the database where the word hairdresser is mentioned.

I have been reading book called "PHP and MYSQL for Dynamic Web Sites" and while it is very helpful, it doesnt seem to address this particular question.

I was wondering if someone could either help me out or point me in the direction of a website or even book that could help me out.

I really appreciate your time & help!!
Thank you!!
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: keyword searches of mysql db from browser

Post by jaoudestudios »

This class does a search for you and can search multiple columns - so a title as well as the text and rate the results in order.
http://www.forum.jaoudestudios.com/view ... ?f=13&t=12
rlgriffo
Forum Newbie
Posts: 4
Joined: Sun Aug 03, 2008 1:44 am

Re: keyword searches of mysql db from browser

Post by rlgriffo »

thanks a lot for that, I really appreciate it, I will have a go at it over the next few days and let you know how i get on!!

Again thank you very much!!!
Post Reply