Live Search in EE 2.0

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

/*
=====================================================
 Copyright (c) 2008 Pascal Kriete
-----------------------------------------------------
 http://pascalkriete.com/
=====================================================
 File: pi.live_search.php
-----------------------------------------------------
 Purpose: Generate live-search json results
=====================================================
Changelog:
- Version 2.0
    Updated to EE 2.0
- Version 1.1.0
    Removed trailing comma from js array
    Updated javascript to accept optional parameters
- Version 1.0.2
    Fixed PHP Notice bug
- Version 1.0.1
    Added 'No Results' text
- Version 1.0.0
    Plugin Created
*/

ini_set('display_errors', 1);

$plugin_info = array(
                        'pi_name'            => 'Live Search',
                        'pi_version'        => '2.0',
                        'pi_author'            => 'Pascal Kriete, ported to EE 2.0 by Giuliano Velli',
                        'pi_author_url'        => 'http://pascalkriete.com/',
                        'pi_description'    => 'Generate search results for the accompanying jQuery plugin.',
                        'pi_usage'            => Live_search::usage()
                    );


class Live_search {

    /**
     * Display Search Results
     *
     * @access    public
     * @return    string
     */
    function results()
    {
        $this->EE =& get_instance();

        if ( ! $this->EE->uri->query_string) 
        { 
            return '';
        }
                
        $search_phrase =& $this->EE->uri->query_string;
        $search_pharse = $this->EE->db->escape_str( urldecode($search_phrase) );
        
        /** ---------------------------------------
        /**  Build and run the query
        /** ---------------------------------------*/
        
        $get_results = "SELECT distinct(a.entry_id), a.url_title, a.title, b.channel_url, b.comment_url 
                FROM exp_channel_titles a, exp_channels b
                WHERE a.channel_id = b.channel_id
                AND a.status != 'closed'
                AND (a.expiration_date > '".$this->EE->localize->now."' OR a.expiration_date = '0')
                AND a.title LIKE '%{$search_phrase}%'
                ORDER BY a.title ASC LIMIT 0,10";
            
        $query = $this->EE->db->query($get_results);

        /** ---------------------------------------
        /**  Empty, no point in continuing
        /** ---------------------------------------*/
        
        if ($query->num_rows() == 0) 
        { 
           echo '[{ "title" : "No results", "path" : "#" }]';
            exit;
        }
        
        /** ---------------------------------------
        /**  Process parameters
        /** ---------------------------------------*/
                
        if( $this->EE->TMPL->fetch_param('link') == 'comment')
        {
            $link_to = 'comment_url';
        }
        else
        {
            $link_to = 'channel_url';
        }
        
        /** ---------------------------------------
        /**  Create javascript json array
        /** ---------------------------------------*/

        $data = '[';
        if ($query->num_rows() > 0)
        {
            foreach($query->result_array() as $row) 
            {
                $data .= '{ "title" : "'.$row['title'].'", "path" : "'.$row[$link_to].$row['url_title'].'" }, ';
            }
        }
        // Take off the last comma
        $data = substr($data, 0, -2);
        $data .= ']';
        
        echo $data;
        exit;
    }
    
// ----------------------------------------
//  Plugin Usage
// ----------------------------------------

// This function describes how the plugin is used.
// Make sure and use output buffering

function usage()
{
ob_start(); 
?>
EE Template:

{exp:live_search:results}

------------------------

EE Parameters:

link="comment"
- The channel path to link to.  Options are "channel" and "comment".  Default is "channel".

------------------------

[removed]

Make sure you have an up-to-date version of jQuery included before the plugin javascript.

Parameters:
width            : width of the displayed results
center_results    : boolean to center the result box

Examples:
$('#keywords').livesearch('/search/livesearch/');
$('#keywords').livesearch('/search/livesearch/', { width: '200' });
$('#keywords').livesearch('/search/livesearch/', { center_results: true });
$('#keywords').livesearch('/search/livesearch/', { width: '200', center_results: true });

<?php
$buffer = ob_get_contents();
    
ob_end_clean(); 

return $buffer;
}
// END


}
// END CLASS
?>