October 19, 201213 yr Our current network of sites has a pretty limited search engine based on searching for the word within the title or content of the search term. I'm keen to make this a bit more advanced, I'm a PHP coder myself so would be doing the work however I am happy to hear peoples opinions on how you would approach it and what features you would incorperate. What would you approach to development be? How would you search the database? Any help appreicated as always keen to add to my own ideas! Current Database Structure - Articles -> Article Title -> Article Content - Sub Levels -> Sub Level Title -> Sub Level Content - Top Levels -> Top Level Title -> Top Level Content We currently search all three tables within there title/content for the search term entered % search term% or %search term%. Edited October 19, 201213 yr by Aaron Clifford
October 19, 201213 yr Our current network of sites has a pretty limited search engine based on searching for the word within the title or content of the search term. I'm keen to make this a bit more advanced, I'm a PHP coder myself so would be doing the work however I am happy to hear peoples opinions on how you would approach it and what features you would incorperate. What would you approach to development be? How would you search the database? Any help appreicated as always keen to add to my own ideas! Current Database Structure - Articles -> Article Title -> Article Content - Sub Levels -> Sub Level Title -> Sub Level Content - Top Levels -> Top Level Title -> Top Level Content We currently search all three tables within there title/content for the search term entered % search term% or %search term%. have you considered implementing full text searching instead of using wild cards?
October 19, 201213 yr Are you using things like categorisation structure, statuses ? you could also search by those as well. You could also to time based searching such as "entries added in the last month".
Create an account or sign in to comment