$app->get('/shiningfloor/materials', function () use($app, $db) { $product_materials = array(); // $query = $db->products()->group('product_material'); $query = $db->materials()->order('material_name ASC'); foreach ($query as $material) { if ($material['material_name'] != "") { $product_materials[] = $material['material_name']; } } $app->response()->header('content-type', 'application/json'); echo json_encode(array('materials' => $product_materials)); }); $app->get('/shiningfloor/shapes', function () use($app, $db) { $product_shapes = array(); // $query = $db->products()->group('product_material'); $query = $db->shapes()->order('shape_name ASC'); foreach ($query as $shape) { if ($shape['shape_name'] != "") { $product_shapes[] = $shape['shape_name']; } } $app->response()->header('content-type', 'application/json'); echo json_encode(array('shapes' => $product_shapes)); }); $app->get('/shiningfloor/usages', function () use($app, $db) { $product_usages = array(); // $query = $db->products()->group('product_material'); $query = $db->usages()->order('usage_name ASC'); foreach ($query as $usage) { if ($usage['usage_name'] != "") { $product_usages[] = $usage['usage_name'];