<?

 
//get  material list starting with the first 2 letters

 
$sql ="SELECT item_name as item FROM materials_inventory where item_name like '$term%'";

$results=$database->getAll($sql);

$json = json_encode($results);

echo $json;