[MySQL][PHP]Dane z json do bazy danych Opcje

[brzanek]

Witam chciał bym zapisać dane z pliku json do mojej bazy danych. Problem jest w tym, że dane pod jednym id ok 270 wierszy. Wiem że mogę zrobić to na zasadzie

[PHP] pobierz, plaintext 
$add = mysql_query("INSERT INTO nazwa_tabeli
(
miasto, data, tempobecna, text, ikona, code, wiatr, kierunek, cisnienie, opady, zachmurzenie, 
dzien, dzientempmax, dzientempmin, dzienodczuwalna, dzienmaxwind, dzienopady, dzienpogoda, dzienikona, dziencode, dzienwschod, dzienzachod, 
dzien1, dzien1tempmax, dzien1tempmin, dzien1odczuwalna, dzien1maxwind, dzien1opady, dzien1pogoda, dzien1ikona, dzien1wschod, dzien1zachod
) 
VALUES(
'$miasto', '$data', '$tempobecna', '$text', '$ikona', '$code', '$wiatr', '$kierunek', '$cisnienie', '$opady', '$zachmurzenie', 
'$dzien', '$dzientempmax', '$dzientempmin', '$dzienodczuwalna', '$dzienmaxwind', '$dzienopady', '$dzienpogoda', '$dzienikona', '$dziencode', '$dzienwschod', '$dzienzachod', 
'$dzien1', '$dzien1tempmax', '$dzien1tempmin', '$dzien1odczuwalna', '$dzien1maxwind', '$dzien1opady', '$dzien1pogoda', '$dzien1ikona', '$dzien1wschod', '$dzien1zachod'
)");
[PHP] pobierz, plaintext 

Ale boję się, że serwer może nie wytrzymać.
Mam już zrobioną bazę danych i chcę zabrać się za kod który doda mi te dane.
Czy macie jakieś inne wyjście jak to w prosty sposób zapisać.
Tak wygląda plik json.
http://brzanek.webd.pl/prognoza/new/choszcznonew.json
Dane zmieniają się co 30 minut a więc wywołanie pliku który będzie zapisywał te dane do bazy danych MySQL będę chciał wykorzystać CRONA na serwerze.

[brzanek]

Zacząłem coś pisać ale zatrzymałem się na pobieraniu i zapisaniu danych do bazy z prognozami godzinowymi.
Obecne warunki jakie są na początku pliku json działają tak jak powinny ale co dalej.
Tak wygląda kod.

[PHP] pobierz, plaintext 
<?php
$json = 'http://brzanek.webd.pl/prognoza/new/choszcznonew.json'; 
$json = file_get_contents($json); 
$response = json_decode($json, true); 
 
if ($response != null) {
  $latitude = $response['latitude'];
  $longitude = $response['longitude'];
//Current Conditions
  $time = $response['currently']['time'];
  $summary = $response['currently']['summary'];
  $icon = $response['currently']['icon'];
  $precipIntensity = $response['currently']['precipIntensity'];
  $precipProbability = ($response['currently']['precipProbability'])*100;
  $precipType = $response['currently']['precipType'];
  $temperature = $response['currently']['temperature'];
  $apparentTemperature = $response['currently']['apparentTemperature'];
  $dewPoint = $response['currently']['dewPoint'];
  $humidity = ($response['currently']['humidity'])*100;
  $windSpeed = $response['currently']['windSpeed'];
  $windBearing = $response['currently']['windBearing'];
  $cloudCover = ($response['currently']['cloudCover'])*100;
  $pressure = $response['currently']['pressure'];
//Hourly Forecast
  $hourlySumamry = $response['hourly']['summary'];
  $hourlyIcon = $response['hourly']['icon'];
  $hourlyCond= array();
    foreach ($response['hourly']['data'] as $td) {
      $hourlyCond[] = $td;
  }	
 
include ("db.php");
$add = mysql_query("INSERT INTO choszczno
(latitude, longitude, time, summary, icon, precipIntensity, precipProbability, temperature, apparentTemperature, 
dewPoint, humidity, windSpeed, windBearing, cloudCover, pressure, time1, summary1, icon1, precipIntensity1, 
precipProbability1, temperature1, apparentTemperature1, dewPoint1, humidity1, windSpeed1, windBearing1, 
cloudCover1, pressure1, time2, summary2, icon2, precipIntensity2, precipProbability2, temperature2, 
apparentTemperature2, dewPoint2, humidity2, windSpeed2, windBearing2, cloudCover2, pressure2, time3, 
summary3, icon3, precipIntensity3, precipProbability3, temperature3, apparentTemperature3, dewPoint3, 
humidity3, windSpeed3, windBearing3, cloudCover3, pressure3, time4, summary4, icon4, precipIntensity4, 
precipProbability4, temperature4, apparentTemperature4, dewPoint4, humidity4, windSpeed4, windBearing4, 
cloudCover4, pressure4, time5, summary5, icon5, precipIntensity5, precipProbability5, temperature5, 
apparentTemperature5, dewPoint5, humidity5, windSpeed5, windBearing5, cloudCover5, pressure5, time6, 
summary6, icon6, precipIntensity6, precipProbability6, temperature6, apparentTemperature6, dewPoint6, 
humidity6, windSpeed6, windBearing6, cloudCover6, pressure6, time7, summary7, icon7, precipIntensity7, 
precipProbability7, temperature7, apparentTemperature7, dewPoint7, humidity7, windSpeed7, windBearing7, 
cloudCover7, pressure7, time8, summary8, icon8, precipIntensity8, precipProbability8, temperature8, 
apparentTemperature8, dewPoint8, humidity8, windSpeed8, windBearing8, cloudCover8, pressure8, time9, 
summary9, icon9, precipIntensity9, precipProbability9, temperature9, apparentTemperature9, dewPoint9, 
humidity9, windSpeed9, windBearing9, cloudCover9, pressure9, time10, summary10, icon10, sunriseTime10, 
sunsetTime10, moonPhase10, precipIntensity10, precipIntensityMax10, precipProbability10, temperatureMin10, 
temperatureMax10, apparentTemperatureMin10, apparentTemperatureMax10, dewPoint10, humidity10, windSpeed10, 
windBearing10, cloudCover10, pressure10, time11, summary11, icon11, sunriseTime11, sunsetTime11, moonPhase11, 
precipIntensity11, precipIntensityMax11, precipProbability11, temperatureMin11, temperatureMax11, 
apparentTemperatureMin11, apparentTemperatureMax11, dewPoint11, humidity11, windSpeed11, windBearing11, 
cloudCover11, pressure11, time12, summary12, icon12, sunriseTime12, sunsetTime12, moonPhase12, 
precipIntensity12, precipIntensityMax12, precipProbability12, temperatureMin12, temperatureMax12, 
apparentTemperatureMin12, apparentTemperatureMax12, dewPoint12, humidity12, windSpeed12, windBearing12, 
cloudCover12, pressure12, time13, summary13, icon13, sunriseTime13, sunsetTime13, moonPhase13, 
precipIntensity13, precipIntensityMax13, precipProbability13, temperatureMin13, temperatureMax13, 
apparentTemperatureMin13, apparentTemperatureMax13, dewPoint13, humidity13, windSpeed13, windBearing13, 
cloudCover13, pressure13, time14, summary14, icon14, sunriseTime14, sunsetTime14, moonPhase14, 
precipIntensity14, precipIntensityMax14, precipProbability14, temperatureMin14, temperatureMax14, 
apparentTemperatureMin14, apparentTemperatureMax14, dewPoint14, humidity14, windSpeed14, windBearing14, 
cloudCover14, pressure14)
VALUES(
'$latitude', '$longitude', '$time', '$summary', '$icon', '$precipIntensity', '$precipProbability', '$temperature', 
'$apparentTemperature', '$dewPoint', '$humidity', '$windSpeed', '$windBearing', '$cloudCover', '$pressure', 
'$time1', '$summary1', '$icon1', '$precipIntensity1', '$precipProbability1', '$temperature1', '$apparentTemperature1', 
'$dewPoint1', '$humidity1', '$windSpeed1', '$windBearing1', '$cloudCover1', '$pressure1', '$time2', '$summary2', 
'$icon2', '$precipIntensity2', '$precipProbability2', '$temperature2', '$apparentTemperature2', '$dewPoint2', 
'$humidity2', '$windSpeed2', '$windBearing2', '$cloudCover2', '$pressure2', '$time3', '$summary3', '$icon3', 
'$precipIntensity3', '$precipProbability3', '$temperature3', '$apparentTemperature3', '$dewPoint3', '$humidity3', 
'$windSpeed3', '$windBearing3', '$cloudCover3', '$pressure3', '$time4', '$summary4', '$icon4', '$precipIntensity4', 
'$precipProbability4', '$temperature4', '$apparentTemperature4', '$dewPoint4', '$humidity4', '$windSpeed4', 
'$windBearing4', '$cloudCover4', '$pressure4', '$time5', '$summary5', '$icon5', '$precipIntensity5', '$precipProbability5', 
'$temperature5', '$apparentTemperature5', '$dewPoint5', '$humidity5', '$windSpeed5', '$windBearing5', '$cloudCover5', 
'$pressure5', '$time6', '$summary6', '$icon6', '$precipIntensity6', '$precipProbability6', '$temperature6', 
'$apparentTemperature6', '$dewPoint6', '$humidity6', '$windSpeed6', '$windBearing6', '$cloudCover6', '$pressure6', 
'$time7', '$summary7', '$icon7', '$precipIntensity7', '$precipProbability7', '$temperature7', '$apparentTemperature7', 
'$dewPoint7', '$humidity7', '$windSpeed7', '$windBearing7', '$cloudCover7', '$pressure7', '$time8', '$summary8', '$icon8', 
'$precipIntensity8', '$precipProbability8', '$temperature8', '$apparentTemperature8', '$dewPoint8', '$humidity8', 
'$windSpeed8', '$windBearing8', '$cloudCover8', '$pressure8', '$time9', '$summary9', '$icon9', '$precipIntensity9', 
'$precipProbability9', '$temperature9', '$apparentTemperature9', '$dewPoint9', '$humidity9', '$windSpeed9', '$windBearing9', 
'$cloudCover9', '$pressure9', '$summarya', '$time10', '$summary10', '$icon10', '$sunriseTime10', '$sunsetTime10', 
'$moonPhase10', '$precipIntensity10', '$precipIntensityMax10', '$precipProbability10', '$temperatureMin10', 
'$temperatureMax10', '$apparentTemperatureMin10', '$apparentTemperatureMax10', '$dewPoint10', '$humidity10', 
'$windSpeed10', '$windBearing10', '$cloudCover10', '$pressure10', '$time11', '$summary11', '$icon11', '$sunriseTime11', 
'$sunsetTime11', '$moonPhase11', '$precipIntensity11', '$precipIntensityMax11', '$precipProbability11', '$temperatureMin11', 
'$temperatureMax11', '$apparentTemperatureMin11', '$apparentTemperatureMax11', '$dewPoint11', '$humidity11', '$windSpeed11', 
'$windBearing11', '$cloudCover11', '$pressure11', '$time12', '$summary12', '$icon12', '$sunriseTime12', '$sunsetTime12', 
'$moonPhase12', '$precipIntensity12', '$precipIntensityMax12', '$precipProbability12', '$temperatureMin12', 
'$temperatureMax12', '$apparentTemperatureMin12', '$apparentTemperatureMax12', '$dewPoint12', '$humidity12', 
'$windSpeed12', '$windBearing12', '$cloudCover12', '$pressure12', '$time13', '$summary13', '$icon13', '$sunriseTime13', 
'$sunsetTime13', '$moonPhase13', '$precipIntensity13', '$precipIntensityMax13', '$precipProbability13', '$temperatureMin13', 
'$temperatureMax13', '$apparentTemperatureMin13', '$apparentTemperatureMax13', '$dewPoint13', '$humidity13', '$windSpeed13', 
'$windBearing13', '$cloudCover13', '$pressure13', '$time14', '$summary14', '$icon14', '$sunriseTime14', '$sunsetTime14', 
'$moonPhase14', '$precipIntensity14', '$precipIntensityMax14', '$precipProbability14', '$temperatureMin14', 
'$temperatureMax14', '$apparentTemperatureMin14', '$apparentTemperatureMax14', '$dewPoint14', '$humidity14', 
'$windSpeed14', '$windBearing14', '$cloudCover14', '$pressure14')");
}
?>
[PHP] pobierz, plaintext 

Ten kod pobiera dane godzinowe ale teraz jak to zapisać do bazy do odpowiednich tabel w jednym rekordzie.

[PHP] pobierz, plaintext 
//Hourly Forecast
  $hourlySumamry = $response['hourly']['summary'];
  $hourlyIcon = $response['hourly']['icon'];
  $hourlyCond= array();
    foreach ($response['hourly']['data'] as $td) {
      $hourlyCond[] = $td;
  }	
[PHP] pobierz, plaintext