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 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
| class Meteo {
public function __construct() {
}
public function insertMeteo($file) {
$mysqli = new mysqli('localhost', 'root', '', 'meteo');
$mysqli->set_charset("utf8");
if($mysqli->connect_errno) {
echo 'Erreur de connexion. Message d\'erreur : ' . $mysqli->connect_error;
exit;
}
$filename = $_FILES["upload"]["tmp_name"];
if($_FILES["upload"]["size"] > 0) {
$file = fopen($filename, "r");
while(($columm = fgetcsv($file, 10000, ",")) !== FALSE) {
$query = 'INSERT INTO meteo_city(ville_id, dates, ville_name, period, to_summarize, id_to_summarize,
minimum_temperature, maximum_temperature, commentaire)
VALUES ("' . $column[0] . '","' . $column[1] . '","' . $column[2] . '","' . $column[3] . '",
"' . $column[4] . '","' . $column[5] . '","' . $column[6] . '","' . $column[7] . '","' . $column[8] . '")';
$result = $mysqli->query($query);
if(!empty($result)) {
$message = '<p class="message">Les données ont bien été importées dans la bdd</p>';
return true;
}
else {
$message = '<p class="error">Les données n\'ont pas pu être importées dans la bdd</p>';
return false;
$mysqli->close();
}
}
}
header('Location: index.php');
exit;
}
public function getMeteo() {
$mysqli = new mysqli('localhost', 'root', '', 'meteo');
$mysqli->set_charset("utf8");
if($mysqli->connect_errno) {
echo 'Erreur de connexion. Message d\'erreur : ' . $mysqli->connect_error;
exit;
}
$query = 'SELECT ville_id, dates, ville_name, period, to_summarize, id_to_summarize,
minimum_temperature, maximum_temperature, commentaire FROM meteo_city WHERE ville_id BETWEEN 3 AND 9';
$result = $mysqli->query($query);
if(!$result) {
echo 'Erreur au niveau de la requête. Message d\'erreur ' . $mysqli->error;
return false;
}
else {
while($row = $result->fetch_array()) {
$ville_id = $row['ville_id'];
$dates = $row['dates'];
$ville_name = $row['ville_name'];
$period = $row['period'];
$to_summarize = $row['to_summarize'];
$id_to_summarize = $row['id_to_summarize'];
$minimum_temperature = $row['minimum_temperature'];
$maximum_temperature = $row['maximum_temperature'];
$commentaire = $row['commentaire'];
$meteo_city[$ville_id]['dates'] = $dates;
$meteo_city[$ville_id]['Nom de la ville'] = $ville_name;
$meteo_city[$ville_id]['La période de la journée'] = $period;
$meteo_city[$ville_id]['Le résumer'] = $to_summarize;
$meteo_city[$ville_id]['L\'id du résumer'] = $id_to_summarize;
$meteo_city[$ville_id]['La température minimum'] = $minimum_temperature;
$meteo_city[$ville_id]['La température maximum'] = $maximum_temperature;
$meteo_city[$ville_id]['Le commentaire'] = $commentaire;
}
return $meteo_city;
$mysqli->close();
}
}
} |
Partager