<html>
<head>
<script type="text/javascript">
function findmatch() {
if (window.XMLHttpRequest){
xmlhttp = new XMLHttpRequest();
} else {
xmlhttp = new ActiveXObject('Microsoft.XMLHTTP');
}
xmlhttp.onreadystatechange = function() {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
document.getElementById('results').innerHTML = xmlhttp.responseText;
}
}
xmlhttp.open('GET', 'search.inc.php?search_text='+document.search.search_text.value, true);
xmlhttp.send();
}
</head>
<body>
<form id="search" name="search">
Type a name:<br>
<input type="text" name="search_text" onkeyup="findmatch();">
</form>
<div id="results"></div>
</body>
</html>
****************search-inc.php**************
<?php
if (isset($_GET['search_text'])) {
echo $search_text = $_GET['search_text'];
}
if (!empty($search_text)) {
if (mysql_connect('localhost','root','')) {
id (mysql_connect_db('a_database')) {
$query = "SELECT `firstname` FROM `names` WHERE `name` LIKE '".mysql_real_escape_string($search_test)."%'";
$query_run = mysql_query($query);
while ($query_row = mysql_fetch_assoc($query_run))
echo $name = $query_row['name'].'<br>';
}
}
}
?>
