PHP Classes

File: appz/type_ahead_db/type_ahead_db.php

Recommend this page to a friend!
  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: 18 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], 0, strlen($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>