Jos joku muu painii oheisen yhdistelmän kanssa, ja on onkelmaa kaman työntämisessä kantaan.
Kokeile jos tästä olisi apuja:
mysql:n kannan taulun luontilauseet löytää täältä:
http://www.weather-watch.com/smf/index.php/topic,41140.msg340955.html#msg340955Ja sitten itse asiaan.. Seuraavassa pläjäyksessä on varmasti löydettävissä huonoa ohjelmointitapaa, kuraa koodia, turhia rivejä, väärää syntaksia, bugeja jne.. Mutta se toimii
edit, päivitin tuota crontabin komentoa jotta se tekee logia tapahtumista
<?php
//weathertodb.php
//connect to db
include 'db_conn.php';
$paiva = date('d/m/y');
$kamaa = array();
$kamaa = file("clientraw.txt");
foreach ($kamaa as $line_num => $kamaa)
#$seperators = array('" "','" ',' "',' ');
#$kamaa = str_replace($seperators,'_',$kamaa);
$ary = explode(' ',$kamaa);
for($i=0;$i<count($ary);$i++)
$ary[$i] = str_replace('"','',$ary[$i]);
$kello = "$ary[29]:$ary[30]";
# $paiva = "$ary[35].$ary[36] 2010";
$saa = "$ary[32] $ary[74] $kello $ary[1] $ary[3] $ary[2] $ary[4]
$ary[5] $ary[6] $ary[7] $ary[8] $ary[9] $ary[10] $ary[11]
$ary[12] $ary[13] $ary[14] $ary[15] $ary[16] $ary[17]
$ary[18] $ary[19] $ary[20] $ary[21] $ary[22] $ary[23]
$ary[24] $ary[25] $ary[26] $ary[27] $ary[28] $ary[29]
$ary[30] $ary[31] $ary[32] $ary[33] $ary[34] $ary[35]
$ary[36] $ary[37] $ary[38] $ary[39] $ary[40] $ary[41]
$ary[42] $ary[43] $ary[44] $ary[45] $ary[46] $ary[47]
$ary[48] $ary[49] $ary[50] $ary[71] $ary[72] $ary[73]
$ary[75] $ary[76] $ary[77] $ary[78] $ary[79] $ary[110]
$ary[111] $ary[112] $ary[113] ";
// Lisää tieto kantaan
$sql = mysql_query("INSERT INTO wx_data (station_id, date, time, average_windspeed,
wind_direction, gust_windspeed, temperature, outdoor_humidity, barometer,
daily_rainfall, monthly_rainfall, yearly_rainfall, rain_rate, max_rain_rate_curent_day,
indoor_temperature, indoor_humidity, soil_temperature, forecast_icon, wmr968_extra_temperature,
wmr968_extra_humidity, wmr968_extra_sensor_number, yesterday_rainfall,
extra_temperature_sensor_2, extra_temperature_sensor_3, extra_temperature_sensor_4,
extra_temperature_sensor_5, extra_temperature_sensor_6, extra_temperature_sensor_7,
extra_humidity_2, extra_humidity_3, extra_humidity_4, hour, minute, second, station_name,
dallas_1_wire_lightning_count, actual_solar_reading, day, month, wmr968_battery_level_1,
wmr968_battery_level_2, wmr968_battery_level_3, wmr968_battery_level_4, wmr968_battery_level_5,
wmr968_battery_level_6, wmr968_battery_level_7, current_windchill, current_humidex,
max_daily_temperature, min_daily_temperature, icon_type, current_weather_desc,
barometer_trend_last_hour, max_gust_current_day, dew_point_temperature, cloud_height,
max_humidex, min_humidex, max_windchill, min_windchill, davis_vp_uv, max_heat_index,
min_heat_index, heat_index, max_average_windspeed_day )
VALUES('$ary[32]', '$paiva', '$kello', '$ary[1]', '$ary[3]', '$ary[2]',
'$ary[4]', '$ary[5]', '$ary[6]', '$ary[7]', '$ary[8]', '$ary[9]',
'$ary[10]', '$ary[11]', '$ary[12]', '$ary[13]', '$ary[14]',
'$ary[15]', '$ary[16]', '$ary[17]', '$ary[18]', '$ary[19]',
'$ary[20]', '$ary[21]', '$ary[22]', '$ary[23]', '$ary[24]',
'$ary[25]', '$ary[26]', '$ary[27]', '$ary[28]', '$ary[29]', '$ary[30]',
'$ary[31]', '$ary[32]', '$ary[33]', '$ary[34]', '$ary[35]', '$ary[36]',
'$ary[37]', '$ary[38]', '$ary[39]', '$ary[40]', '$ary[41]', '$ary[42]',
'$ary[43]', '$ary[44]', '$ary[45]', '$ary[46]', '$ary[47]', '$ary[48]',
'$ary[49]', '$ary[50]', '$ary[71]', '$ary[72]', '$ary[73]', '$ary[75]',
'$ary[76]', '$ary[77]', '$ary[78]', '$ary[79]', '$ary[110]', '$ary[111]',
'$ary[112]', '$ary[113]' ) ")
or die(mysql_error());
echo "sää lisätty, tulostetaan lista..";
echo $saa;
mysql_close($mysql_id);
***********************************
<?php
//db_conn.php
//connect to db
$mysql_id = mysql_connect('db_server', 'username', 'password') or die(mysql_error());
mysql_select_db("database", $mysql_id) or die(mysql_error());
?>
************************************
crontab:
*/5 * * * * /usr/bin/php -q /tähänpolkutiedostoon/weathertodb.php >> /tähänpolkucroninluomaanlogitiedostoon/logfile.log
************************************
