As you can see you can now search with our side panel search. In order to achieve good results, we used mysql full-text searching feature which is available in MySQL 4.0+. Very handy though I had to convert the phpBB post table into full search text so it went something like this:

Ran this mySQL query first

Code: Select all

ALTER TABLE phpbb_posts ADD FULLTEXT(post_text);


Then simply write the php search engine script for it. Simply create a new form with submission form code. The important part is to run this query to catch all the posts with matching keywords:

Code: Select all

$query = "select * from phpbb_posts where match(post_text) against ( '$keywords' )
  order by post_time";


I will provide the source code later on.

Reserved for search engine code