Masroor_Shah Masroor_Shah - 3 months ago 8
Javascript Question

Advance search through ajax and php

I am trying to do advance search through php and AJAX but i stuck and i don't know where is my mistake. plz guide thanks.........

My PHP code



<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
<style>
table {
width: 100%;
border-collapse: collapse;
}

table, td, th {
border: 1px solid black;
padding: 5px;
}

th {text-align: left;}
</style>
</head>

<body>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$conn = mysql_connect($servername, $username, $password);
if (!$conn) {
die('Could not connect: ' . mysqli_error($conn));
}
$in = $_GET['str'];
if (!ctype_alnum($in)) {
echo "Data Error";
exit;
}
mysql_select_db('firstdb');
$sql = "select name, id , age, sex from name where name like '%$in%'";
$display = mysql_query($sql, $conn);
echo "<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Age</th>
<th>Gender</th>
</tr>";
while ($row = mysql_fetch_assoc($display)) {
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "<td>" . $row['sex'] . "</td>";
echo "</tr>";
}
echo "</table>";
?>
</body>
</html>





My Javascript code and AJAX function



<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
<script>
function user(str){
if(str.length==0){
document.getElementById("userhint").innerHTML = "";
return;
}
else {
var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
document.getElementById("userhint").innerHTML = xmlhttp.responseText;
}
}
xmlhttp.open("GET", "advanceSearch.php?q="+str, true);
xmlhttp.send();
}
}
</script>
</head>
<body>
<form>
<input type="text" onkeyup="user(this.value);" name="username" />
</form>
<br />
<div id="userhint"><b>User info will be listed here...</b></div>
</body>
</html>





Error occurred

enter image description here

I am new here plz help

Answer

Simple thing, parameter that you declare in your GET Url is not str but q.

so, change to $_GET['q']