Tutorial: CMS Builder Search Engine (Outdated, See Docs for Searching)

Hi Dave!

I have just finished building our first CMS Builder site, and I don't need searching for that site, but I would love to have a tutorial on this, and try it out on a "localhost demo site". This why I can be certain of the possibilities/limitations of this before promising anything to the next CMS Builder customer.

-aev-

Sure. We're still figuring out the best way to "officially" add this functionality. Probably it will be some sort of "search engine code generator". But here's how to do it right now. There's a little bit of PHP and MySQL but I'll walk you through it.

Start with your standard "List Viewer" that you're using to display your content.

Add the search form at top. Here's a simple one:
<form method="get" action="<?php echo $_SERVER['PHP_SELF'] ?>">
Keyword: <input type="text" name="keyword" value="" size="15">
<input type="submit" name="" value="Search">
</form>

Next, in the record list loader code, replace the "$options['where'] = ''" line with this code (using your own fields if you don't have title, summary, and content):
$escapedKeyword = escapeMysqlString( @$FORM['keyword'] );
$options['where'] = "title LIKE '%$escapedKeyword%' OR
summary LIKE '%$escapedKeyword%' OR
content LIKE '%$escapedKeyword%'";
This adds on to the WHERE part of the MySQL statement which tells it what records to return. The "LIKE" means "looks like" and the "%" means anything. So it will return record where the title has the title has the keyword in it -OR- the summary -OR- etc. (Don't forget to use your own fieldnames or you'll get an error).

You can also do numeric (greater than, less than) searches and exact match search (show only articles from category X).


Then finally, add this code _below_ the line with getListRows();
$scriptUrl = $_SERVER['PHP_SELF'];
$encodedKeyword = urlencode(@$FORM['keyword']);
$listDetails['prevPageLink'] = "$scriptUrl?keyword=$encodedKeyword&page={$listDetails['prevPage']}";
$listDetails['nextPageLink'] = "$scriptUrl?keyword=$encodedKeyword&page={$listDetails['nextPage']}";
This updates your prev/next links to pass the keyword along when you switch from page to page so you're still only getting filtered results.

So, we haven't automated this part of yet, but it's still possible with a few lines of code. Let me know if it works or if you need more help with it. :)

Update, this is now all automatic in v1.07. All you need is to make a search form. Use "myfieldname_match" for exact matches and "myfieldname_keyword" for keyword matches.

<form method="get" action="<?php echo $_SERVER['PHP_SELF'] ?>">
Keyword: <input type="text" name="myfield_keyword" value="" size="15">
<input type="submit" name="" value="Search">
</form>

Here's a link to CMS Builder's search engine docs:

http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html

Hi, Dave.

Do you have any sample code for getting the matching results to appear on the listViewer.php (results) page?

Thanks.

Hi, Dave.

I actually needed the tags that displays the results on a search results page. I have a search form on this page that goes to the results page when you click on the submit button: http://www.satoa.com/membersList.php. However, I don't know what to put in the results page code - http://www.satoa.com/listViewer.php - so that the matching results are shown.

Regards,

Hi Nigel,

Start by making this page list "all results":
http://www.satoa.com/listViewer.php

Then it should work. Let me know if you're still having trouble once you get that page displaying all results.

Thanks, Dave. I've got it working perfectly! :-)