populate datalist from database
<?php
//connect to mysql database
$connection = mysqli_connect("localhost","username","password","store") or die("Error " . mysqli_error($connection));
//fetch data from database
$sql = "select cname from category";
$result = mysqli_query($connection, $sql) or die("Error " . mysqli_error($connection));
?>
<!DOCTYPE html>
<html>
<head>
<title>Autocomplete Textbox in HTML5 PHP and MySQL</title>
</head>
<body>
<label for="pcategory">Product Category</label>
<input type="text" list="categoryname" autocomplete="off" id="pcategory">
<datalist id="categoryname">
<?php while($row = mysqli_fetch_array($result)) { ?>
<option value="<?php echo $row['cname']; ?>"><?php echo $row['cname']; ?></option>
<?php } ?>
</datalist>
<?php mysqli_close($connection); ?>
</body>
</html>
