I would like to create a very simple ajax auto-suggest which it can retrieve some data from database.
You can see here :
index.php
<html>
<head>
<script type="text/javascript">
function suggest() {
var txtSearch = document.getElementById('txtSearch').value;
if (window.XMLHttpRequest) {
xmlhttp = new XMLHttpRequest();
} else {
xmlhttp = new ActiveXObject('MicrosoftXMLHTTP');
}
xmlhttp.onreadystatechange = function() {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
document.getElementById('myDiv').innerHTML = xmlhttp.responseText;
}
}
var target = 'include.inc.php?txtSearch=' + txtSearch;
xmlhttp.open('GET', target, true);
xmlhttp.send();
}
</script>
</head>
<body>
<input type="text" id="txtSearch" onkeyup="suggest();"/>
<div id="myDiv"></div>
</body>
</html>
incldue.inc.php
<?php
require_once 'connect.inc.php';
if (isset($_GET['txtSearch'])) {
$txtSearch = $_GET['txtSearch'];
getSuggest($txtSearch);
}
function getSuggest($text) {
$sqlCommand = "SELECT `SurName` FROM `person` WHERE `SurName` LIKE '%$text%'";
$query = mysql_query($sqlCommand);
$result_count = mysql_num_rows($query);
while ($row = mysql_fetch_assoc($query)) {
echo $row['SurName'].'<br />';
}
?>
The problem :
Get following error on line 22, But i have no idea why :
Parse error: syntax error, unexpected end of file in C:\wamp\www\PHP_Ajax_Autosuggest\include.inc.php on line 22
P.S :
And i didn't mentioned connect.inc.php content, because it works fine.
Any help would be great appreciated.
