PDA

View Full Version : website search: MySQL



Jenny
01-27-2006, 05:16 PM
Is it possible for people who visit my website to be able to search my MySQL database?

VodaHost
01-27-2006, 05:41 PM
Yes..but you must have some sort of user interface for them to search with.

Jenny
01-27-2006, 07:41 PM
And could a BlueVoda Form act as such an interface?
e.g. people would enter keywords in the form and relevant results would appear.

VodaHost
01-27-2006, 07:46 PM
No, the interface would have to be built in PHP by somebody who knows
what they are doing? What EXACTLY are u trying to accomplish......Maybe I
can point you in the right direction...what type of site is it?

Jenny
01-27-2006, 11:46 PM
I have a database full of information that I would like people who visit my site to be able to search using a keyword search, (kind of like Google but only for this database).

I don't want people to have access to the database though (they shouldn't be able to browse it or alter records). I am considering buying in the Zoom search facility from Wrensoft (wrensoft.com) but wanted explore all other options first. What do you think?

VodaHost
01-28-2006, 04:16 PM
Check out www.hotscripts.com , you should be able to find a premade script for this. Also look in your fantastico...lots of stuff in there.

Jenny
01-29-2006, 11:10 PM
OK. I've now set up a MySQL database and looked at hotscripts.com. Wrensoft say that the Zoom search engine can connect to it if:

1) I link to the database with php script. (not had much luck finding this).

2) I provide a link from my site to every entry in the database (not sure how to link when there's no web address for the database entries)

These are my two problems. Any ideas?

Many Thanks.