import af fil til database
HejJeg har et program som lave en log fil i ren txt eller som en XML fil.
Jeg forstiller mig at et cron job først køre og laver log filen, hvor efter et andet cron job køre php filen som læser og indsætter i mysql.
Hvad vil være nemmest at få php til at læse:
En txt fil men det her:
20051014081004 2005-Oct-14 08:10:04 27.6 10.2 7.2 35 82 0.0 90.0 E 10.2 0.00 0.00 125.35 1024.600 Falling Cloudy
eller en XML:
<?xml version="1.0" encoding="utf-8"?>
<ws2300 version="1.0">
<Date>2006-11-12</Date>
<Time>12:08:59</Time>
<Temperature>
<Indoor>
<Value>22.5</Value>
<Min>15.0</Min>
<Max>22.5</Max>
<MinTime>00:00</MinTime>
<MinDate>2001-01-01</MinDate>
<MaxTime>00:51</MaxTime>
<MaxDate>2001-01-01</MaxDate>
</Indoor>
<Outdoor>
<Value>81.1</Value>
<Min>81.1</Min>
<Max>81.1</Max>
<MinTime>00:10</MinTime>
<MinDate>2000-00-00</MinDate>
<MaxTime>00:10</MaxTime>
<MaxDate>2000-00-00</MaxDate>
</Outdoor>
</Temperature>
<Humidity>
<Indoor>
<Value>53</Value>
<Min>53</Min>
<Max>70</Max>
<MinTime>00:51</MinTime>
<MinDate>2001-01-01</MinDate>
<MaxTime>00:00</MaxTime>
<MaxDate>2001-01-01</MaxDate>
</Indoor>
<Outdoor>
<Value>110</Value>
<Min>110</Min>
<Max>110</Max>
<MinTime>00:10</MinTime>
<MinDate>2000-00-00</MinDate>
<MaxTime>00:10</MaxTime>
<MaxDate>2000-00-00</MaxDate>
</Outdoor>
</Humidity>
<Dewpoint>
<Value>81.1</Value>
<Min>81.1</Min>
<Max>81.1</Max>
<MinTime>00:10</MinTime>
<MinDate>2000-00-00</MinDate>
<MaxTime>00:10</MaxTime>
<MaxDate>2000-00-00</MaxDate>
</Dewpoint>
<Wind>
<Value>51.0</Value>
<Direction>
<Text>N</Text>
<Dir0>0.0</Dir0>
<Dir1>0.0</Dir1>
<Dir2>0.0</Dir2>
<Dir3>0.0</Dir3>
<Dir4>0.0</Dir4>
<Dir5>0.0</Dir5>
</Direction>
<Min>0.0</Min>
<Max>0.0</Max>
<MinTime>00:00</MinTime>
<MinDate>2001-01-01</MinDate>
<MaxTime>00:00</MaxTime>
<MaxDate>2001-01-01</MaxDate>
</Wind>
<Windchill>
<Value>81.1</Value>
<Min>81.1</Min>
<Max>81.1</Max>
<MinTime>00:10</MinTime>
<MinDate>2000-00-00</MinDate>
<MaxTime>00:10</MaxTime>
<MaxDate>2000-00-00</MaxDate>
</Windchill>
<Rain>
<OneHour>
<Value>0.00</Value>
<Max>0.00</Max>
<MaxTime>00:52</MaxTime>
<MaxDate>2001-01-01</MaxDate>
</OneHour>
<TwentyFourHour>
<Value>0.00</Value>
<Max>0.00</Max>
<MaxTime>00:00</MaxTime>
<MaxDate>2001-01-01</MaxDate>
</TwentyFourHour>
<Total>
<Value>101.00</Value>
<Time>00:10</Time>
<Date>2000-00-00</Date>
</Total>
</Rain>
<Pressure>
<Value>1014.000</Value>
<Min>1013.500</Min>
<Max>1014.000</Max>
<MinTime>00:30</MinTime>
<MinDate>2001-01-01</MinDate>
<MaxTime>00:54</MaxTime>
<MaxDate>2001-01-01</MaxDate>
<Tendency>Steady</Tendency>
</Pressure>
<Forecast>Cloudy</Forecast>
</ws2300>
