/* Script per inserire i valore nel DB */
$xml = simplexml_load_file( 'percorso/file.xml' );
$city = $xml->location->attributes()->city;
$var = $xml->location->var;
mysql_connect();
mysql_select_db();
$query = 'INSERT INTO location ( location ) VALUES ( "'.$city.'" )';
$result = mysql_query($query);
$query = 'SELECT ID FROM location WHERE location="'.$city.'"';
$result = mysql_query($query);
$obj = mysql_fetch_object($result);
$id = $obj -> ID;
mysql_close();
mysql_free_result($result);
foreach ( $var as $value ) {
$name = $value->name;
$icon = $value->icon;
$data = $value->data;
$data_sequence = '';
$gradi = '';
$desc = '';
foreach ( $data as $value ) {
$data_sequence .= $value->forecast[0]->attributes()->data_sequence.'::';
$data_sequence .= $value->forecast[1]->attributes()->data_sequence.'::';
$data_sequence .= $value->forecast[2]->attributes()->data_sequence.'::';
$data_sequence .= $value->forecast[3]->attributes()->data_sequence.'::';
$data_sequence .= $value->forecast[4]->attributes()->data_sequence.'::';
$data_sequence .= $value->forecast[5]->attributes()->data_sequence.'::';
$data_sequence .= $value->forecast[6]->attributes()->data_sequence;
$gradi .= $value->forecast[0]->attributes()->id.'::';
$gradi .= $value->forecast[1]->attributes()->id.'::';
$gradi .= $value->forecast[2]->attributes()->id.'::';
$gradi .= $value->forecast[3]->attributes()->id.'::';
$gradi .= $value->forecast[4]->attributes()->id.'::';
$gradi .= $value->forecast[5]->attributes()->id.'::';
$gradi .= $value->forecast[6]->attributes()->id;
$desc .= $value->forecast[0]->attributes()->value.'::';
$desc .= $value->forecast[1]->attributes()->value.'::';
$desc .= $value->forecast[2]->attributes()->value.'::';
$desc .= $value->forecast[3]->attributes()->value.'::';
$desc .= $value->forecast[4]->attributes()->value.'::';
$desc .= $value->forecast[5]->attributes()->value.'::';
$desc .= $value->forecast[6]->attributes()->value;
}
mysql_connect();
mysql_select_db();
$query = 'INSERT INTO metalocation ( location, nome, icon, data, gradi, description ) VALUES ( "'.$id.'", "'.$name.'", "'.$icon.'", "'.$data_sequence.'", "'.$gradi.'", "'.$desc.'" )';
$result = mysql_query($query);
mysql_close();
mysql_free_result($result);
}