Login   Register  
PHP Classes
elePHPant
Icontem

File: appz/type_ahead_db/type_ahead_db.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Guilherme Blanco  >  pAjax  >  appz/type_ahead_db/type_ahead_db.php  >  Download  
File: appz/type_ahead_db/type_ahead_db.php
Role: Application script
Content type: text/plain
Description: Type Ahead Script
Class: pAjax
Do RPC calls from the browser without page reloads
Author: By
Last change: Corrected MySQL Connection
Date: 8 years ago
Size: 1,829 bytes
 

Contents

Class file image Download
<?php

require_once "../../class.pAjax.php";

function 
suggest($text) {
    
// It could be an SQL statement execution with a like condition, example:
    // SELECT stateName FROM USAStates WHERE stateName LIKE '{$text}%';
    
mysql_connect("localhost""username""password");
    
mysql_select_db("test");
    
    
$query "SELECT nome FROM usuarios WHERE nome LIKE '{$text}%'";
    
$result mysql_query($query);
    
$return = array();

    if (
mysql_num_rows($result) > 0) {
        while (
$row mysql_fetch_array($result)) {
            if (
strtolower($text) == strtolower(substr($row[0], 0strlen($text))))
                
$return[] = $row[0];
        }
    }

    
mysql_close();

    return 
$return;
}


$AJAX = new pAjax;
$AJAX->handleRequest();

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
  <head>
    <title>Auto Suggestion Type Ahead Example</title>
    <?php $AJAX->showJavaScript("../.."); ?>
    <script type="text/javascript" src="autosuggestcontroller.js"></script>
    <script type="text/javascript" src="suggestionprovider.js"></script>
    <script type="text/javascript">
        window.onload = function () {
            var oTextBox = new AutoSuggestController(document.getElementById("TextBox1"), new SuggestionProvider());
        }
    </script>
  </head>

  <body>
    <h1>Type Ahead Suggestion</h1>
    <p>
      While you type anything on the input, it processes and autosuggest you by completing and selecting the word<br />
      The database of this example are the USA states. Try typing something like "New Mexico" and see what it appears while you type a char.
    </p>
    <input type="text" id="TextBox1" />
  </body>
</html>