homepage Welcome to WebmasterWorld Guest from 54.242.126.9
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Product Search Algorithm
What's the best approach for searching products?
nick279

5+ Year Member



 
Msg#: 3775689 posted 12:21 pm on Oct 29, 2008 (gmt 0)

Just adding on a PHP search facility to my e-commerce site and struggled to find an answer for this.

I haven't utilised a plaintext search (mysql) for my products search, but have several fields I'd like to search. Was going to do a keyword density approach for each of the below fields, and weight it using the following:-

40% weight = Product Title
20% weight = Product Description
20% weight = Meta Tags (title/description/kw)
20% weight = Other fields

$weighting = array("title"=>0.4, "description"=>0.2, "meta"=>0.2, "other"=>0.2);

Are there quicker or better ways to do this / am I missing a trick?

 

dreamcatcher

WebmasterWorld Senior Member dreamcatcher us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 3775689 posted 2:00 pm on Nov 12, 2008 (gmt 0)

How about MySQL`s FULLTEXT search functions?

[dev.mysql.com...]

dc

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved