Contact

Help

Quick start

Help videos

Tutorials

Wiki

Issue Tracker

Eclipse PHP

Languages

Support

Compatibilities

Components

Tutorials

Tutorial Textbox

Tutorial : TextBox search with autocomplete

Textbox-08: Tutorial of the composant Textbox of the PHP FrameWork WebSite-PHP.

Tutorial : TextBox search with autocomplete:

Go back to tutorial of the componant Textbox

Source code

File: /pages/tutorials/textbox/textbox-08.php


<?php
class Textbox08 extends Page {
    public function InitializeComponent() {
        parent::$PAGE_TITLE = "Tutorial : TextBox search 
                                with autocomplete";
        
        // List of values used is available on:
        // http://www.website-php.com/en/tutorials/database/database-05.html
                
        $form = new Form($this);
                
        // Create TextBox object
        $search_text = new TextBox($form);
        
        // Create AutoCompleteEvent object
        $autocompete_event = new AutoCompleteEvent($form);
        $autocompete_event->onSelect("onSelectAutoComplete");
        $autocompete_event->setAjaxEvent();
        $autocompete_event->disableAjaxWaitMessage();
        
        // You can catch the event with JavaScript
        /*$autocompete_event->onSelectJs(
            "if (ui.item.id != '') { alert(ui.item.id); }");*/
        
        // Create AutoComplete object
        $autocomplete = new AutoComplete(
                        new Url("xml/textbox-search.json"), 
                        1, $autocompete_event);

        // Set autocomplete on the TextBox
        $search_text->setAutoComplete($autocomplete);
        $form->setContent($search_text);
        
        $this->render = $form;
    }
    
    public function onSelectAutoComplete($sender, $id) {
        $this->addObject(
            new DialogBox("onSelectAutoComplete", 
                                "URL: ".$id)
            );
    }
}
?>

Go back to tutorial of the componant Textbox

Source code

TextboxSearch:
File: /pages/xml/textbox-search.php


<?php
class TextboxSearch extends Page {
    public function InitializeComponent() {
        $this->render = new AutoCompleteResult();
        
        $_GET['term'] = trim(utf8decode(strip_tags($_GET['term'])));
        $_GET['term'] = addslashes($_GET['term']);
        
        $sql = new SqlDataView(new FavoritePageDbTable());
        if (isset($_GET['filter']) && 
            ($_GET['filter']==1 || $_GET['filter']==0)) {
            // When there is a filter param used
            $_GET['filter'] = trim(utf8decode(strip_tags($_GET['filter'])));
            $_GET['filter'] = addslashes($_GET['filter']);
            if ($_GET['filter'] == 0) { $_GET['filter'] = " IS NULL"; }
            else { $_GET['filter'] = " = 1"; }
            $sql->setClause(FavoritePageDbTable::FIELD_NAME.
                            " LIKE '%".$_GET['term']."%' AND ".
                            FavoritePageDbTable::FIELD_ACTIF.
                            $_GET['filter']);
        } else { // Without filter
            $sql->setClause(FavoritePageDbTable::FIELD_NAME.
                            " LIKE '%".$_GET['term']."%'");
        }
        
        $ind = 0;
        $it = $sql->retrieve();
        while ($it->hasNext()) {
            $row = $it->next();
            $this->render->add(
                $row->getValue(FavoritePageDbTable::FIELD_URL), 
                $row->getValue(FavoritePageDbTable::FIELD_NAME), 
                $row->getValue(FavoritePageDbTable::FIELD_NAME));
            $ind++;
        }
        if ($ind == 0) {
            $this->render->add("", utf8_encode("No result"), "");
        }
    }
}
?>

PHP Framework

Home

Documentation

Download

Quick start

Help videos

Tutorials

Tutorials

Tutorial Textbox

Tutorial : TextBox search with autocomplete

Source code

Source code