// echo $trip_id ;
$insert_trip_plan = array("trips_id" => $trip_id, "no_of_persons" => $numOfPeople, "no_of_days" => $tripDuration, "price_to_pay" => $priceToPay);
$trip_plan = $db->trips_plan()->insert($insert_trip_plan);
for ($i = 0; $i < sizeOf($attractionsList); $i++) {
$p = (array) $attractionsList[$i];
$attraction = array("trips_id" => $trip_id, "attractions_id" => $p['id'], "attraction_preference" => 0);
$db->trip_attractions()->insert($attraction);
}
}
$app->response()->header('content-type', 'application/json');
echo json_encode(array('order_id' => $data));
});
$app->get('/region/places(/:region_id)', function ($region_id = null) use($app, $db) {
if ($region_id != null) {
$data = array();
foreach ($db->places()->where('place_region_id', $region_id) as $p) {
$data[] = array('id' => $p["id"], 'place_name' => $p["place_name"], 'place_region_name' => $p["place_region_name"], 'place_region_id' => $p["place_region_id"]);
}
} else {
foreach ($db->places() as $p) {
$data[] = array('id' => $p["id"], 'place_name' => $p["place_name"], 'place_region_name' => $p["place_region_name"], 'place_region_id' => $p["place_region_id"]);
}
}
$app->response()->header('content-type', 'application/json');
echo json_encode(array('places_data' => $data));
});
$app->get('/places(/:place_id)', function ($place_id = null) use($app, $db) {
if ($place_id != null) {
$data = null;
$query = $db->places()->where('id', intval($place_id));
// echo $query;
