<tr><td>Part Name: </td><td><input type="text" name="PartNum" class="auto" id="pn" style="width:250px" required></td></tr>

                        <script type="text/javascript">
                            $(function() {
                                $(".auto").autocomplete({
                                    source: "autocomplete.php",
                                    minLength: 1
                                });
                            });
                        </script>

<?php

$host = "localhost";
$username = "cws";
$password = "cws2019!";
$db = "cws_inventory";

$conn = mysqli_connect($host, $username, $password, $db);

$searchTerm = $_GET['term'];

$select = mysqli_query($conn, "SELECT * FROM modelnumindex WHERE ModelNum LIKE '%".$searchTerm."%'");
while ($row = mysqli_fetch_array($select))
{
 $data[] = $row['ModelNum'];
}
//return json data
echo json_encode($data);
?>
```