PHP Programming :: Search function


	Search function Hey! .....A little background: We have a site that has already been made.. a couple of hundred pages displayed via SMARTY templates, the site's in Swedish. The navigation and other parts except for the center is taken care of by the templates and other scripts... the center main text is taken from the database(mySql) based on $page_id...its in a MySql TEXT field and has all the html etc that will be displayed in the center of the page. ....End of background.. Now they want to add a "search function" to the site... a simpe textbox where a user enters a word or sentance and they get 20 results per page... with a "x.xx % closest to your query" can anybody give me basic pointers on where to start? Any links/software or articles too would be appreciated... (I can do the pagentation etc... just the search logic...) Thanks! R ------ - The faulty interface lies between the chair and the keyboard. - Creativity is great, but plagiarism is faster! - Smile, everyone loves a moron. :-) --------------------------------- Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos. - Hide quoted text - Ryan A wrote: > Hey! > .....A little background: > We have a site that has already been made.. a couple of hundred pages > displayed via SMARTY templates, the site's in Swedish. > The navigation and other parts except for the center is taken care of by > the templates and other scripts... the center main text is taken from the > database(mySql) based on $page_id...its in a MySql TEXT field and has all > the html etc that will be displayed in the center of the page. > ....End of background.. > Now they want to add a "search function" to the site... a simpe textbox > where a user enters a word or sentance and they get 20 results per page... > with a "x.xx % closest to your query" can anybody give me basic pointers > on where to start? Any links/software or articles too would be > appreciated... > (I can do the pagentation etc... just the search logic...) > Thanks! > R Don't reinvent the wheel - mnogosearch has php compatibility. http://www.mnogosearch.org/ Cheers -- David Robley Tried to play my shoehorn... all I got was footnotes! Today is Prickle-Prickle, the 56th day of Discord in the YOLD 3173. -----------------------------------------------Reply----------------------------------------------- On Wed, May 9, 2007 7:34 am, Ryan A wrote: > Now they want to add a "search function" to the site... a simpe > textbox where a user enters a word or sentance and they get 20 results > per page... with a "x.xx % closest to your query" can anybody give me > basic pointers on where to start? > Any links/software or articles too would be appreciated... You could google for "full text search" and "weighted search" and find more than enough reading to fill the rest of your life... :-) With only a couple hundred pages of content, it's kinda hard to really make a good search engine... You'd almost be better off just building a form that leads to Google and using theirs, really. -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some indie artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -----------------------------------------------Reply----------------------------------------------- Ryan A wrote: > Hey! > .....A little background: > We have a site that has already been made.. a couple of hundred pages displayed via SMARTY templates, the site's in Swedish. > The navigation and other parts except for the center is taken care of by the templates and other scripts... the center main text is taken from the database(mySql) based on $page_id...its in a MySql TEXT field and has all the html etc that will be displayed in the center of the page. > ....End of background.. > Now they want to add a "search function" to the site... a simpe textbox where a user enters a word or sentance and they get 20 results per page... with a "x.xx % closest to your query" can anybody give me basic pointers on where to start? > Any links/software or articles too would be appreciated... http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html Start off with that, if they need something more complicated down the line, revisit. -- Postgresql & php tutorials http://www.designmagick.com/ -----------------------------------------------Reply----------------------------------------------- Thanks for your input guys, will go through the links you gave me and get back to ya if I run into any problems. Have a nice weekend! Cheers! R ------ - The faulty interface lies between the chair and the keyboard. - Creativity is great, but plagiarism is faster! - Smile, everyone loves a moron. :-) --------------------------------- Get the free Yahoo! toolbar and rest assured with the added security of spyware protection.

MS Dynamics CRM 3.0

PHP Programming

Search function