setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); if (isset($_GET['term'])) { $search_for = $_GET['term']; $select = $db->prepare("SELECT `item` FROM `products` WHERE `item` LIKE ? LIMIT 50;"); $select->execute(array("%$search_for%")); $data = $select->fetchAll(); $items = array(); foreach ($data as $an_item) { $items[] = $an_item['item']; } echo json_encode($items); }