Rameshwar-ghodke/Search through database

## Search through database
In this example, when a user types a character in the input field, a function called "showHint()" is executed.
The function is triggered by the onkeyup event.
eg-----

<html>
<head>
<script>
function showHint(str) {
    if (str.length == 0) {
        document.getElementById("txtHint").innerHTML = "";
        return;
    } else {
        var xmlhttp = new XMLHttpRequest();
        xmlhttp.onreadystatechange = function() {
            if (this.readyState == 4 && this.status == 200) {
                document.getElementById("txtHint").innerHTML = this.responseText;
            }
        };
        xmlhttp.open("GET", "gethint.php?q=" + str, true);
        xmlhttp.send();
    }
}
</script>
</head>
<body>

<p><b>Start typing a name in the input field below:</b></p>
<form>
First name: <input type="text" onkeyup="showHint(this.value)">
</form>
<p>Suggestions: <span id="txtHint"></span></p>
</body>
</html>


// *********************************The PHP File - "gethint.php" ************************************************

<?php
// Array with names
$a[] = "Anna";
$a[] = "Brittany";
$a[] = "Cinderella";
$a[] = "Diana";
$a[] = "Eva";
$a[] = "Fiona";
$a[] = "Gunda";
$a[] = "Hege";
$a[] = "Inga";
$a[] = "Johanna";
$a[] = "Kitty";
$a[] = "Linda";
$a[] = "Nina";
$a[] = "Ophelia";
$a[] = "Petunia";
$a[] = "Amanda";
$a[] = "Raquel";
$a[] = "Cindy";
$a[] = "Doris";
$a[] = "Eve";
$a[] = "Evita";
$a[] = "Sunniva";
$a[] = "Tove";
$a[] = "Unni";
$a[] = "Violet";
$a[] = "Liza";
$a[] = "Elizabeth";
$a[] = "Ellen";
$a[] = "Wenche";
$a[] = "Vicky";

// get the q parameter from URL
$q = $_REQUEST["q"];

$hint = "";

// lookup all hints from array if $q is different from ""
if ($q !== "") {
    $q = strtolower($q);
    $len=strlen($q);
    foreach($a as $name) {
        if (stristr($q, substr($name, 0, $len))) {
            if ($hint === "") {
                $hint = $name;
            } else {
                $hint .= ", $name";
            }
        }
    }
}
	In this example, when a user types a character in the input field, a function called "showHint()" is executed.
	The function is triggered by the onkeyup event.
	eg-----

	<html>
	<head>
	<script>
	function showHint(str) {
	if (str.length == 0) {
	document.getElementById("txtHint").innerHTML = "";
	return;
	} else {
	var xmlhttp = new XMLHttpRequest();
	xmlhttp.onreadystatechange = function() {
	if (this.readyState == 4 && this.status == 200) {
	document.getElementById("txtHint").innerHTML = this.responseText;
	}
	};
	xmlhttp.open("GET", "gethint.php?q=" + str, true);
	xmlhttp.send();
	}
	}
	</script>
	</head>
	<body>

	<p><b>Start typing a name in the input field below:</b></p>
	<form>
	First name: <input type="text" onkeyup="showHint(this.value)">
	</form>
	<p>Suggestions: <span id="txtHint"></span></p>
	</body>
	</html>


	// *******************************The PHP File - "gethint.php" **********************************************

	<?php
	// Array with names
	$a[] = "Anna";
	$a[] = "Brittany";
	$a[] = "Cinderella";
	$a[] = "Diana";
	$a[] = "Eva";
	$a[] = "Fiona";
	$a[] = "Gunda";
	$a[] = "Hege";
	$a[] = "Inga";
	$a[] = "Johanna";
	$a[] = "Kitty";
	$a[] = "Linda";
	$a[] = "Nina";
	$a[] = "Ophelia";
	$a[] = "Petunia";
	$a[] = "Amanda";
	$a[] = "Raquel";
	$a[] = "Cindy";
	$a[] = "Doris";
	$a[] = "Eve";
	$a[] = "Evita";
	$a[] = "Sunniva";
	$a[] = "Tove";
	$a[] = "Unni";
	$a[] = "Violet";
	$a[] = "Liza";
	$a[] = "Elizabeth";
	$a[] = "Ellen";
	$a[] = "Wenche";
	$a[] = "Vicky";

	// get the q parameter from URL
	$q = $_REQUEST["q"];

	$hint = "";

	// lookup all hints from array if $q is different from ""
	if ($q !== "") {
	$q = strtolower($q);
	$len=strlen($q);
	foreach($a as $name) {
	if (stristr($q, substr($name, 0, $len))) {
	if ($hint === "") {
	$hint = $name;
	} else {
	$hint .= ", $name";
	}
	}
	}
	}