$app->response()->header('content-type', 'application/json'); echo json_encode(array('brands' => $brands)); }); /* Get all colors */ $app->get('/shiningfloor/colors', function () use($app, $db) { $colors = array(); foreach ($db->colors() as $color) { $colors[] = $color['color_name']; } $app->response()->header('content-type', 'application/json'); echo json_encode(array('colors' => $colors)); }); $app->get('/shiningfloor/finish_types', function () use($app, $db) { $finish_types = array(); // $query = $db->products()->group('product_finish_type'); $query = $db->finishes()->order('finish_name ASC'); foreach ($query as $finish) { if ($finish['finish_name'] != "") { $finish_types[] = $finish['finish_name']; } } $app->response()->header('content-type', 'application/json'); echo json_encode(array('finish_types' => $finish_types)); }); $app->get('/shiningfloor/applications', function () use($app, $db) { $applications = array(); // $query = $db->products()->group('product_application'); $query = $db->applications()->order('application_name ASC'); foreach ($query as $application) { if ($application['application_name'] != "") { $applications[] = $application['application_name'];