Page 1 of 1

keyword searches of mysql db from browser

Posted: Sun Aug 03, 2008 1:50 am
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!!

Re: keyword searches of mysql db from browser

Posted: Sun Aug 03, 2008 2:06 am
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

Re: keyword searches of mysql db from browser

Posted: Sun Aug 03, 2008 9:07 am
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!!!