echo json_encode(array('our_trips' => $data)); } }); $app->get('/our_trips_data(/:our_trip_id)', function ($our_place_id) use($app, $db) { if ($our_place_id != null) { $query = $db->our_trips()->where('id', $our_place_id); foreach ($query as $p) { $our_trips_id = $p['id']; $sights = array(); $travel = array(); $query2 = $db->our_trips_sights()->where('our_trips_id', $our_trips_id); foreach ($query2 as $q) { // echo $q['id'] .$q['sight_title'] ."\n"; $sights[] = array('sight_id' => $q['id'], 'sight_name' => $q['sight_title'], 'sight_about' => $q['sight_names']); } $query2 = $db->our_trips_travel()->where('our_trips_id', $our_trips_id); foreach ($query2 as $q) { // echo $q['id'] .$q['sight_title'] ."\n"; $travel[] = array('travel_id' => $q['id'], 'travel_method' => $q['travel_method'], 'travel_about' => $q['travel_details']); } $data[] = array('our_trips_id' => $our_trips_id, 'our_trips_img1' => $p['our_trips_img1'], 'our_trips_img2' => $p['our_trips_img2'], 'our_trips_placeId' => $p['places_id'], 'our_trips_about' => array_map('utf8_encode', array(stripslashes($p['trip_place_about']))), 'our_trips_timeSpan' => $p['trip_timeSpan'], 'our_trips_cost' => $p['trip_cost'], 'our_trips_travel' => $travel, 'our_trips_sights' => $sights); } $app->response()->header('content-type', 'application/json'); echo json_encode(array('our_trips_data' => $data)); } }); $app->post('/tourepedia/submitPlan', function () use($app, $db) { $data = array(); $array = (array) json_decode($app->request()->getBody()); $attractionsList = (array) $array['attractionsList']; $plan = (array) $array['plan'];