WebsiteBaker Community Forum

WebsiteBaker Support (2.8.x) => Droplets & Snippets => Topic started by: Craig.Rodway on April 02, 2005, 12:33:35 AM

Title: Code Snippet: Search Bookmarks
Post by: Craig.Rodway on April 02, 2005, 12:33:35 AM
Here is a piece of code to allow searching of bookmarks. It's intended to be added to a code module before the bookmarks module, but could be easily adopted to fit into a template.

Code: [Select]
if( isset( $_GET['search'] ) ) {

  $query_links = $database->query("SELECT title,url,target FROM ".TABLE_PREFIX."mod_bookmarks_links WHERE title LIKE '%".$_GET[search]."%' ORDER BY position ASC");

if( $query_links->numRows() > 0 ) {
  print '<p>Search results for "'.$_GET['search'].'":';
  print '<ul>';
  while($link = $query_links->fetchRow()) {
    print '<li>';
    print '<a href="'.$link['url'].'" target="'.$link['target'].'">';
    print $link['title'];
    print '</a>';
    print '</li>';
  }
  print '</ul>';
} else {
 print '<p>Sorry, no results found for "'.$_GET['search'].'".</p>';
}

} else {

  print '<form method="GET" action="'.$_ENV[PHP_SELF].'" style="margin:0px;">';
  print '<p style="margin-bottom:0px;padding-bottom:0px;">Search bookmarks: ';
  print '<input type="text" name="search" size="30">';
  print '<input type="submit" value=" Search "></p>';
  print '</form>';

}

print '<hr>';  // remove this line to get rid of the visible horizontal rule.


Click here (http://barac.m0php.net/pages/web_links.php) to view the live example version :)
Title: Code Snippet: Search Bookmarks
Post by: fienieg on April 02, 2005, 01:28:34 AM
Thanks Craig, works good  :D
Title: Code Snippet: Search Bookmarks
Post by: Ryan on April 02, 2005, 03:07:27 AM
Hmm, one day when I get my act together, the bookmarks module will be searchable through the main search feature - so we won't have to write stuff like this anymore. As for now, your code is great! 8)
Title: Code Snippet: Search Bookmarks
Post by: Craig.Rodway on April 02, 2005, 03:15:39 PM
I didn't notice the bookmarks weren't searchable until after I'd made that code, I just wanted a way to only search the bookmarks, and have the search box on the same page  :wink:
Title: Code Snippet: Search Bookmarks
Post by: Ryan on April 07, 2005, 04:12:19 AM
Well, great work then! 8)
Title: Re: Code Snippet: Search Bookmarks
Post by: bupaje on August 21, 2010, 08:25:59 PM
Is there a simple mod to this code to allow it to also search by the text in the title attribute - not only the link text? (This info is currently pulled from the Display field in the Bookmarks module.)

<a href="http://www.example.com/" target="_blank" title="Nice collection of PS brushes with a nifty live preview.">Example</a>