<?php //connect to database $conn = mysqli_connect("localhost", "root", "", "inventory"); if(mysqli_connect_errno($conn)) { echo "Unable to connect to database server"; } //query database for items to populate $sql = "SELECT ITEM_NAME FROM item"; $query = mysqli_query($conn, $sql); echo '<datalist name="list1" id="list1" onchange="showUser(this.value)">'; //change select to datalist echo '<option value="">Select item</option>'; while($selectedItem = mysqli_fetch_assoc($query)) { echo "<option>{$selectedItem['ITEM_NAME']}</option>"; } echo '</datalist>'; //change select to datalist if (isset ($_POST['submit'])) { $selectedItem = $_POST['list1']; } ?>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)