foreach ($query as $p) {
$our_trips_id = $p['id'];
$data[] = array_map('utf8_encode', array('our_trips_id' => $our_trips_id, 'our_trips_name' => $p['trip_name'], 'our_trips_img1' => $p['our_trips_img1'], 'our_trips_img2' => $p['our_trips_img2'], 'our_trips_placeId' => $place_id, 'our_trips_timeSpan' => $p['trip_timeSpan'], 'our_trips_cost' => $p['trip_cost']));
}
$app->response()->header('content-type', 'application/json');
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));
}
});
