Nuovi posts

Cerca

Iscriviti

Pagina php con tabella con dati da json

di

il 20 mag 2023, 19:05

2 risposte

Pochi posts

Iscritto da: mag, 2023

Messaggi:: 1

Pagina php con tabella con dati da json

20 mag 2023, 19:28

Buongiorno,

premetto che sono abbastanza ignorante in materia, mi servirebbe una pagina php che mi metta in tabella i dati forniti da questo json

{"latitude":45.82,"longitude":11.779999,"generationtime_ms":0.8679628372192383,"utc_offset_seconds":7200,"timezone":"Europe/Berlin","timezone_abbreviation":"CEST","elevation":191.0,"current_weather":{"temperature":17.9,"windspeed":7.9,"winddirection":43.0,"weathercode":61,"is_day":1,"time":"2023-05-20T18:00"},"hourly_units":{"time":"iso8601","temperature_2m":"°C","dewpoint_2m":"°C","precipitation":"mm","weathercode":"wmo code","windspeed_10m":"km/h","winddirection_10m":"°","windgusts_10m":"km/h","is_day":"","windspeed_950hPa":"km/h","windspeed_900hPa":"km/h","windspeed_850hPa":"km/h","winddirection_950hPa":"°","winddirection_900hPa":"°","winddirection_850hPa":"°"},"hourly":{"time":["2023-05-20T00:00","2023-05-20T01:00","2023-05-20T02:00","2023-05-20T03:00","2023-05-20T04:00","2023-05-20T05:00","2023-05-20T06:00","2023-05-20T07:00","2023-05-20T08:00","2023-05-20T09:00","2023-05-20T10:00","2023-05-20T11:00","2023-05-20T12:00","2023-05-20T13:00","2023-05-20T14:00","2023-05-20T15:00","2023-05-20T16:00","2023-05-20T17:00","2023-05-20T18:00","2023-05-20T19:00","2023-05-20T20:00","2023-05-20T21:00","2023-05-20T22:00","2023-05-20T23:00","2023-05-21T00:00","2023-05-21T01:00","2023-05-21T02:00","2023-05-21T03:00","2023-05-21T04:00","2023-05-21T05:00","2023-05-21T06:00","2023-05-21T07:00","2023-05-21T08:00","2023-05-21T09:00","2023-05-21T10:00","2023-05-21T11:00","2023-05-21T12:00","2023-05-21T13:00","2023-05-21T14:00","2023-05-21T15:00","2023-05-21T16:00","2023-05-21T17:00","2023-05-21T18:00","2023-05-21T19:00","2023-05-21T20:00","2023-05-21T21:00","2023-05-21T22:00","2023-05-21T23:00","2023-05-22T00:00","2023-05-22T01:00","2023-05-22T02:00","2023-05-22T03:00","2023-05-22T04:00","2023-05-22T05:00","2023-05-22T06:00","2023-05-22T07:00","2023-05-22T08:00","2023-05-22T09:00","2023-05-22T10:00","2023-05-22T11:00","2023-05-22T12:00","2023-05-22T13:00","2023-05-22T14:00","2023-05-22T15:00","2023-05-22T16:00","2023-05-22T17:00","2023-05-22T18:00","2023-05-22T19:00","2023-05-22T20:00","2023-05-22T21:00","2023-05-22T22:00","2023-05-22T23:00"],"temperature_2m":[15.7,15.6,16.7,17.1,16.4,16.7,17.0,17.3,18.1,18.5,18.6,18.4,19.5,20.5,19.1,19.5,19.9,18.9,17.9,18.2,18.3,18.1,17.7,18.7,19.0,19.3,19.5,19.6,19.4,19.8,20.0,20.0,20.1,20.5,22.1,23.4,24.1,24.9,25.2,25.1,25.4,25.0,24.3,23.2,21.9,21.2,21.2,21.2,21.0,20.6,20.4,19.7,19.6,19.5,19.6,19.8,21.1,22.3,23.2,23.7,24.3,25.0,25.4,25.9,25.8,25.6,null,null,null,null,null,null],"dewpoint_2m":[9.8,9.5,9.1,8.5,9.3,9.4,9.2,9.9,9.4,9.9,10.2,11.5,11.1,11.4,12.4,14.5,14.3,14.0,14.6,13.3,12.5,12.1,12.4,12.0,11.8,11.6,11.3,10.9,10.7,9.7,9.3,9.6,9.7,10.0,10.6,11.8,11.8,11.1,12.1,10.5,10.8,12.3,12.9,13.7,12.8,11.6,11.3,10.4,11.1,11.2,10.8,10.4,10.4,10.3,10.1,10.8,13.6,15.4,12.5,11.7,13.2,11.5,11.6,11.3,10.4,10.6,null,null,null,null,null,null],"precipitation":[0.10,0.00,0.00,0.00,0.30,0.20,0.20,0.10,0.00,0.00,0.00,0.30,0.20,0.00,0.00,0.60,0.10,0.00,2.00,1.10,0.20,0.00,0.10,0.20,0.00,0.00,0.00,0.00,0.10,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,null,null,null,null,null,null],"weathercode":[61,3,3,61,61,61,61,80,3,3,3,61,61,3,3,61,61,3,61,61,61,3,61,61,61,3,3,3,61,3,3,3,3,3,2,2,1,1,2,1,1,1,2,3,2,2,2,2,2,2,3,2,1,1,1,1,0,0,1,1,1,1,1,0,1,0,null,null,null,null,null,null],"windspeed_10m":[23.4,4.2,12.6,13.0,12.2,9.7,9.4,9.0,13.6,18.7,17.1,19.7,23.5,20.4,20.5,15.0,11.5,14.1,7.9,14.1,12.8,11.5,9.4,16.4,18.5,17.7,20.3,21.1,19.3,21.0,20.1,20.5,19.7,19.1,18.1,16.9,18.4,20.2,18.4,15.1,14.1,11.8,10.0,3.2,5.4,9.6,13.8,18.2,15.1,13.2,12.3,10.3,11.6,10.5,10.9,8.0,3.3,3.2,9.2,13.4,16.0,15.5,15.4,12.0,13.2,7.4,null,null,null,null,null,null],"winddirection_10m":[45,59,53,48,43,39,32,37,53,50,55,50,49,58,51,73,58,38,43,38,32,44,40,38,37,38,37,37,33,35,36,38,40,43,55,78,86,92,101,123,103,102,120,117,352,13,33,38,38,35,32,29,26,16,6,8,49,153,111,96,99,103,106,106,135,133,null,null,null,null,null,null],"windgusts_10m":[45.7,44.3,14.8,25.9,24.5,24.5,21.2,23.4,23.4,36.0,35.3,33.5,44.6,45.4,40.3,39.2,32.0,22.7,30.2,29.9,39.6,26.6,24.8,35.6,37.1,38.5,43.2,40.7,41.8,40.3,40.3,38.9,38.5,37.1,36.0,34.9,36.7,39.2,42.1,41.4,31.7,32.0,26.3,20.5,10.4,28.8,31.7,38.2,37.4,31.3,27.7,25.9,24.5,24.5,22.3,22.3,15.8,9.7,19.1,27.0,32.4,33.8,32.0,31.0,27.4,27.0,null,null,null,null,null,null],"is_day":[0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0],"windspeed_950hPa":[49.6,23.2,35.5,34.0,33.1,30.6,28.9,31.0,35.8,38.1,36.5,39.2,44.9,38.1,35.7,28.1,22.3,20.9,21.4,24.5,20.3,26.0,26.8,35.1,38.2,36.7,39.1,40.9,36.5,41.3,41.2,41.8,40.7,39.5,36.2,28.9,29.5,31.0,28.1,22.6,20.7,17.3,16.8,7.7,3.9,13.8,25.5,33.1,30.4,27.1,26.4,25.2,27.0,23.2,20.0,14.6,12.7,12.1,12.6,18.6,22.1,20.3,20.1,14.9,16.8,9.1,null,null,null,null,null,null],"windspeed_900hPa":[47.0,32.5,37.2,33.8,35.2,30.9,31.3,33.1,41.4,44.5,46.4,44.7,48.7,45.4,46.1,35.6,28.3,27.1,25.6,31.4,29.4,32.3,33.2,36.4,35.6,37.6,42.5,42.3,38.6,42.5,43.7,44.5,45.2,43.6,41.0,37.2,35.9,34.3,30.3,23.1,25.6,22.6,18.9,11.7,12.5,22.3,30.3,34.3,35.5,30.6,29.0,28.0,28.2,24.1,20.1,20.0,18.4,16.9,15.4,18.8,19.4,20.3,18.8,16.5,14.6,10.4,null,null,null,null,null,null],"windspeed_850hPa":[44.8,41.9,40.7,36.1,39.5,33.7,36.0,36.4,48.0,52.1,56.6,50.9,53.5,53.6,56.7,43.1,35.3,34.0,31.6,41.1,40.6,39.8,41.9,41.1,36.5,41.1,48.2,46.0,43.8,46.4,48.9,49.8,52.0,50.0,47.3,45.6,42.4,37.9,33.1,29.8,31.2,28.5,22.4,18.5,21.9,32.0,36.5,36.5,42.6,37.7,35.3,33.3,32.4,27.8,21.0,25.7,24.1,21.6,19.8,20.6,20.0,23.0,18.7,19.0,17.7,13.2,null,null,null,null,null,null],"winddirection_950hPa":[57,62,55,56,55,55,58,57,54,55,62,55,54,62,66,78,62,62,55,59,59,63,57,53,53,55,56,55,54,54,53,54,56,57,61,72,80,88,98,121,99,100,116,139,53,63,66,72,68,59,55,58,52,52,54,68,78,73,101,88,94,98,101,99,128,130,null,null,null,null,null,null],"winddirection_900hPa":[62,60,68,72,70,72,75,68,64,66,68,64,63,71,71,79,76,75,72,81,80,76,76,71,70,71,71,70,72,69,68,69,71,72,74,76,77,82,90,89,86,89,98,96,87,84,80,82,85,82,79,77,72,73,66,78,76,72,78,70,73,76,87,85,95,105,null,null,null,null,null,null],"winddirection_850hPa":[68,59,80,86,83,88,89,78,72,74,72,70,71,78,75,80,84,82,84,94,91,85,88,87,88,86,83,82,86,83,81,81,82,84,83,78,75,77,83,65,78,83,84,80,92,93,90,91,96,98,96,92,88,90,77,83,75,72,64,55,49,56,72,73,64,88,null,null,null,null,null,null]}}

Ringrazio fin d'ora chi mi aiuterà

Buona serata

2 Risposte

Alka
Utente Famoso
Iscritto da
nov, 2014
Messaggi:
3312
Re: Pagina php con tabella con dati da json
22 mag 2023, 01:39
mi servirebbe una pagina php che mi metta in tabella i dati forniti da questo json
[…]
Ringrazio fin d'ora chi mi aiuterà
Qui non si sviluppano software su commissione, pertanto se è vero che hai bisogno di aiuto, posta il codice che hai scritto e spiega gli errori che ottieni con la tua prova.
A
alfredo.centinaro
Pochi posts
Iscritto da
apr, 2022
Messaggi:
21
Re: Pagina php con tabella con dati da json
24 mag 2023, 18:27
Premesso che Alka ha perfettamente ragione e probabilmente l'utente ha già trovato “aiuto” altrove, per non lasciare il thread senza risposta visto che l'argomento è interessante per gli alunni che si apprestano ad affrontare l'esame di stato di informatica, propongo un frammento di codice che non è risolutivo ma da un possibile indirizzo, se i moderatori non mi bacchettano anche questa volta.
La soluzione è semplice:
- si apre/legge il file json da opportuno path dove vengono generati/depositati
- si decodifica con le funzioni php o in un array associativo o in un oggetto
- si procede alla visualizzazione nel modo preferito
```
<?php

$percorso_file = 'test.json';
$json2string = file_get_contents($percorso_file);
//$dati = json_decode($json2string, true); //restituisce un vettore
$dati = json_decode($json2string, false);  //restituisce un oggetto

echo "Latitudine: ".$dati->latitude;
echo "<br>";
echo "Longitudine: ".$dati->longitude;
//...
```
Diciamo che JSON in genere è più facile vederlo interagire con JS, e la stessa visualizzazione proposta non tiene conto di un modello MVC dignitoso.
un pezzo del JSON proposto
```
{
    "latitude":45.82,
    "longitude":11.779999,
    "generationtime_ms":0.8679628372192383,
    "utc_offset_seconds":7200,
    "timezone":"Europe/Berlin",
    "timezone_abbreviation":"CEST",
    "elevation":191.0,
    "current_weather":
    ...
```

Devi accedere o registrarti per scrivere nel forum

2 risposte