<?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>
|
Stumble It!
Bookmark in del.icio.us
Download
