[MySQL][PHP] Wyciąganie dowolnego fragmentu danych z pola "data" Opcje

[tromarek1]

Nie wiem jak dokładnie opisać swój problem. Dodaję nową funkcjonalność do kalendarza, ale nigdy się nie spotkałem z takim sposobem zapisu danych. Otóż mam Tabelę o nazwie dopbsp_days.
Wewnątrz niej unique_id, calendar_id, day, year, data, price_min, price_max.

Rekordy wewnątrz data prezentują się mniej-więcej w następujący sposób:

[SQL] pobierz, plaintext 
{"available":20,
"bind":0,
"hours":{
"00:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"01:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"02:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"03:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"04:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"05:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"06:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"07:00":{"available":0,"bind":0,"info":"","notes":"","price":"","promo":"","status":"booked"},
"08:00":{"available":0,"bind":0,"info":"","notes":"","price":"","promo":"","status":"booked"},
"09:00":{"available":0,"bind":0,"info":"","notes":"","price":"","promo":"","status":"booked"},
"10:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":"","status":"available"},
"11:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"12:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"13:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"14:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"15:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"16:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"17:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"18:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"19:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"20:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"21:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"22:00":{"available":1,"bind":0,"info":"","notes":"","price":5,"promo":0,"status":"available"},
"23:00":{"available":0,"bind":0,"info":"","notes":"","price":0,"promo":0,"status":"none"}},
"hours_definitions":[{"value":"00:00"},
{"value":"01:00"},
{"value":"02:00"},
{"value":"03:00"},
{"value":"04:00"},
{"value":"05:00"},
{"value":"06:00"},
{"value":"07:00"},
{"value":"08:00"},
{"value":"09:00"},
{"value":"10:00"},
{"value":"11:00"},
{"value":"12:00"},
{"value":"13:00"},
{"value":"14:00"},
{"value":"15:00"},
{"value":"16:00"},
{"value":"17:00"},
{"value":"18:00"},
{"value":"19:00"},
{"value":"20:00"},
{"value":"21:00"},
{"value":"22:00"},
{"value":"23:00"}],
"info":"info"
,"notes":"",
"price":5,
"promo":0,
"status":"available"}
[SQL] pobierz, plaintext 

Dla mnie szok, że te dane nie są w oddzielnych kolumnach. Nigdy się z czymś takim nie spotkałem. Żaden z poradników, który czytałem nie wspominał nawet, że tak można. Ale do sedna.
Chciałbym móc edytować te dane za pomocą kodu PHP(powiedzmy, że chciałbym np. zmienić o godzinie 15:00 dostępność[available] na wartość "0", status na "booked" i zmienić ["available":20] na ["available":19]).


Poprosił bym również ewentualnie( lub "i") link do poradnika szczegółowo tłumaczącego jak operować na takich danych.

Byłbym naprawdę wdzieczny. Uczę się, więc proszę o wyrozumiałość (IMG:style_emoticons/default/smile.gif)

Ten post edytował tromarek1 3.08.2017, 20:24:25

[viking]

Po zmianach w obiekcie: var_dump(json_encode($json_decode));

Ten post edytował viking 8.08.2017, 13:13:49