$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']; } } $app->response()->header('content-type', 'application/json'); echo json_encode(array('usages' => $product_usages)); }); $app->get('/shiningfloor/sizes', function () use($app, $db) { $product_sizes = array(); $query = $db->products()->group('product_size'); foreach ($query as $product) { if ($product['product_size'] != "") { $product_sizes[] = $product['product_size']; }