Page 1 of 1
Building a site search engine
Posted: Mon Dec 19, 2005 8:15 pm
by kendall
Hey,
I am developing a website in which i have both static and dyanmic pages (mysql data). I want to build a general site search that encompasses search both the static and database for search terms.
I have heard about a site index process but I had no luck finding out EXACTLY how to put this to use for my situation.
Can some one clear the air here....
do you no of any good tuts out there pertaining to what i want to do?
Kendall
Posted: Mon Dec 19, 2005 10:46 pm
by josh
mysql has a built in searching feature for fulltext fields, you need to build an "index" table that you will search on, write a script to copy the content of all your pages into the table and let mysql do all the work. This is probably the easiest way, you can google for mysql fulltext search for helpfull tutorials, or read the official mysql documentation
Posted: Mon Dec 19, 2005 11:20 pm
by hawleyjr
jshpro2 wrote:mysql has a built in searching feature for fulltext fields, you need to build an "index" table that you will search on, write a script to copy the content of all your pages into the table and let mysql do all the work. This is probably the easiest way, you can google for mysql fulltext search for helpfull tutorials, or read the official mysql documentation
Thats a pretty smart idea. Anyone have script that does that?
Posted: Tue Dec 20, 2005 12:33 am
by matthijs
Just last week I found this article from Cal Henderson about
searching with php and mysql. Might be of interest.
Posted: Tue Dec 20, 2005 4:55 am
by kendall
jshpro2 wrote:mysql has a built in searching feature for fulltext fields, you need to build an "index" table that you will search on, write a script to copy the content of all your pages into the table and let mysql do all the work. This is probably the easiest way, you can google for mysql fulltext search for helpfull tutorials, or read the official mysql documentation
actually i know about full text searching. For the fields i want to search that containt descriptive content i have a fulltext search index on it. Searching the database like that is not a problem but these fields/ columns are product information and not really any keyword seeded content specfic for site searching. Its not like its and index of the site. Then the static pages are php but thier content is hardcoded. I didnt see the need to pt that in a table really. So i wanted a search site script that will search both the web pages as well as the database fields.
I was scouring through the web and found a ht//Dig software. Has anyone ever used it in relation to searching both files and databases?
KEndall