Welcome Guest, Not a member yet? Register   Sign In
Creating a cross-platform forum search function
#1

[eluser]TheFuzzy0ne[/eluser]
Hi, guys! I'm looking for some ideas on a forum search function. I believe I've touched on the subject before, but didn't really get the results I was looking for.

I'd like to create a forum search function that uses Active Record, so it's compatible with all databases that the Active Record class supports. I've looked into MySQL fulltext searching, and whilst it's nice, it's not compatible with all databases.

I'm looking for some ideas. I was thinking of using LIKE, but I'd imagine that might be resource intensive, and also it doesn't help when looking for words that may or may not have a preceding space.

I've noticed that some other mainstream forums out there seem to index words in a word list, and then search them. I've yet to understand how this works so if anyone can point me in the right direction, that would be great. More specifically, if you could give an example of how I might query the word list with Active Record and return a list of relevant posts, that would be great.

Basically, any suggestions that don't require the user to be running a specific database platform would be fantastic. Obviously I need to figure this out before I design my database layout, which is why I've been holding off for now. This is a project which I'd like to eventually release as a module for CodeIgniter users, hence why I'd like to make it work on the most common databases.

Thanks in advance for you suggestions.


Messages In This Thread
Creating a cross-platform forum search function - by El Forum - 03-19-2009, 06:19 AM
Creating a cross-platform forum search function - by El Forum - 03-19-2009, 09:14 AM
Creating a cross-platform forum search function - by El Forum - 03-19-2009, 10:15 AM
Creating a cross-platform forum search function - by El Forum - 03-19-2009, 12:28 PM
Creating a cross-platform forum search function - by El Forum - 03-19-2009, 01:10 PM
Creating a cross-platform forum search function - by El Forum - 03-19-2009, 01:22 PM
Creating a cross-platform forum search function - by El Forum - 03-19-2009, 01:37 PM
Creating a cross-platform forum search function - by El Forum - 03-19-2009, 03:02 PM
Creating a cross-platform forum search function - by El Forum - 03-20-2009, 08:47 AM
Creating a cross-platform forum search function - by El Forum - 03-20-2009, 09:36 AM
Creating a cross-platform forum search function - by El Forum - 03-20-2009, 09:45 AM
Creating a cross-platform forum search function - by El Forum - 03-20-2009, 10:19 AM
Creating a cross-platform forum search function - by El Forum - 03-20-2009, 10:38 AM
Creating a cross-platform forum search function - by El Forum - 03-20-2009, 10:51 AM
Creating a cross-platform forum search function - by El Forum - 03-20-2009, 11:02 AM
Creating a cross-platform forum search function - by El Forum - 03-21-2009, 09:43 AM
Creating a cross-platform forum search function - by El Forum - 03-23-2009, 05:57 AM
Creating a cross-platform forum search function - by El Forum - 03-23-2009, 01:11 PM
Creating a cross-platform forum search function - by El Forum - 05-28-2009, 07:14 AM
Creating a cross-platform forum search function - by El Forum - 05-29-2009, 09:09 AM



Theme © iAndrew 2016 - Forum software by © MyBB