Hej,
Mam zapytanie do bazy, ktore wyglada tak:
$query = "SELECT s.departure_time
FROM stop_times s
JOIN trips t ON s.trip_id = t.trip_id
JOIN calendar c ON t.service_id = c.service_id
WHERE monday =1
AND start_date = '$start_date'
AND s.stop_id ='$stop_id'
AND t.route_id ='$route_id'
Wyrzucam sobie to w JSON i otrzymuje:
[{"departure_time":"04:04:00"},{"departure_time":"04:50:00"},{"departure_time":"05:28:00"},{"departure_time":"05:54:00"},{"departure_time":"06:29:00"},{"departure_time":"06:49:00"},{"departure_time":"07:05:00"},{"departure_time":"07:26:00"},{"departure_time":"07:58:00"},{"departure_time":"08:25:00"},{"departure_time":"08:56:00"},{"departure_time":"09:44:00"},{"departure_time":"10:18:00"},{"departure_time":"10:44:00"},{"departure_time":"11:45:00"},{"departure_time":"12:19:00"},{"departure_time":"12:41:00"},{"departure_time":"13:08:00"},{"departure_time":"13:54:00"},{"departure_time":"14:21:00"},{"departure_time":"14:46:00"},{"departure_time":"15:12:00"},{"departure_time":"15:38:00"},{"departure_time":"16:05:00"},{"departure_time":"16:34:00"},{"departure_time":"16:57:00"},{"departure_time":"17:26:00"},{"departure_time":"17:48:00"},{"departure_time":"18:13:00"},{"departure_time":"18:39:00"},{"departure_time":"18:59:00"},{"departure_time":"19:25:00"},{"departure_time":"19:58:00"},{"departure_time":"20:24:00"},{"departure_time":"20:42:00"},{"departure_time":"21:41:00"},{"departure_time":"22:35:00"}]
Taka postac nie bardzo mnie satysfakcjonuje. Chcialbym aby rezultat byl pogrupowany tzn. uzyskac coos takiego "4 - 04, 50", "5 - 28, 54" itd. Nie wiem tylko na ktorym etapie powienienm probowac to uzyskac (zapytanie do bazy czy php pozniej), no i szczerze mowiac nie bardzo wiem jaka powinna byc finalna postac. Czy powinienem miec obiekt JSON symbolizujacy godzine 4 i w nim tablice z elementami (minuty) czy moze jakis inny sposob?
Bylbym wdzieczny za pomoc.
Pzdr.