1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| <?php
function debug($location, $var) // cette fonction aide au debug (tu peux l'enlever)
{
echo "<br/>".(is_string($location))?$location:''."<br/><pre>";
var_dump($var);
echo "</pre><br/>";
}
$mysqli = new mysqli('localhost', 'root', '', 'projet_meteo');
$mysqli->set_charset("utf8");
if ($mysqli->connect_errno) {
echo 'Echec de la connection' . $mysqli->connect_error;
exit();
}
if (($handle = fopen("meteo.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
//debug("ligne csv 18",$data);
$data_utf8=[];
foreach($data as $item_data){
$var=str_replace('é','e',$item_data);
$data_utf8[]=str_replace('è','e',$var);
}
$date = $data_utf8[0];
$ville = $data_utf8[1];
$periode = $data_utf8[2];
$resume = $data_utf8[3];
$id_resume = $data_utf8[4];
$temp_min = $data_utf8[5];
$temp_max = $data_utf8[6];
$commentaire = $data_utf8[7];
$mysqli->query('INSERT INTO meteo (day, ville, periode, resume, id_resume, temp_min, temp_max, commentaire) VALUES ("'. $date .'" , "'. $ville .'" ,"'. $periode .'" , "'. $resume .'" , "'. $id_resume .'" , "'. $temp_min .'" , "'. $temp_max .'" , "'. $commentaire .'")');
//var_dump($mysqli);
}
}
?> |
Partager