Untitled

<?php
session_start();
?>

<!DOCTYPE html>
<head>
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript">
function search(partialSearch){
$.ajax({url:"PHP.php",type:"POST",data {partialSearch:partialSearch},success:function(result){
$("#results").html(result);
}});
};
</script>
</head>

<body>

<div class="container">

<h3>Find Other users</h3>

<input type="text" name="partialSearch"onkeyup="search(this.value)"/>
<div id="results"></div>
</div>


</body>
</html>

<?php

$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "coursework_db";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$partialSearch = $_POST['partialSearch'];

$stmt = $conn->prepare("SELECT username FROM members WHERE username LIKE ? ");
$stmt->bind_param('s',$partialSearch);
$stmt->execute();
$stmt->bind_result($username);
while ($row = $stmt->fetch()) {
$searchResults[] = $username;
echo "<div>".$searchResults."</div>";
}
?>

CREATE TABLE members (
memberID int(5) NOT NULL AUTO_INCREMENT,
username VARCHAR(65) NOT NULL UNIQUE,
password VARCHAR(65) NOT NULL,
PRIMARY KEY (memberID)
);