";}
$period=$today->modify('-1 days')->format('Y-m-d H:i:s');// hier format datetime sql
if ($periode==48){$period=$today->modify('-2 days')->format('Y-m-d H:i:s');}
elseif ($periode==7) {$period=$today->modify('-7 days')->format('Y-m-d H:i:s');}//semaine derniere
elseif ($periode==31) {$period=$today->modify('-1 month')->format('Y-m-d H:i:s');}//mois précédent
elseif ($periode==365) {$period=$today->modify('-1 year')->format('Y-m-d H:i:s');}//année derniere
elseif ($periode=="infos_bd") {$period=$today->modify('-14 days')->format('Y-m-d H:i:s');}
echo $periode."---".$period;
// SERVEUR SQL
// connexion
$conn = new mysqli(SERVEUR,UTILISATEUR,MOTDEPASSE,DBASE);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error . "
");
}
if ($periode=="text_svg") {echo 'Connected';}
else {echo "Connected successfully
";}//modif 2022
if ($periode=="infos_bd") {$sql="SELECT * FROM `".$device."` WHERE `date` >= '".$period."' ORDER BY `date` ASC" ;}
else {$sql="SELECT * FROM `".$device."` WHERE `date` >= '".$period."'" ;}
$result = $conn->query($sql);
$number = $result->num_rows;
$xdate=array();
$yvaleur=array();
$hj=$periode;
if ($hj=="infos_bd" || $hj=="text_svg") {$hj="";}// modif nov 2022
elseif (($hj=="24") || ($hj=="48")) {$hj=$hj." H";}
else {$hj=$hj." J";}
if ($result->num_rows > 0) {if ($periode!="text_svg") {echo "table : ".$device." champ :".$champ." ".$hj."
";}
// output data of each row
while($row = $result->fetch_assoc()) {
if($periode=="infos_bd" || $periode=="text_svg"){$xdate[]= $row["date"];}//modif 2022
else {$xdate[]= strtotime($row["date"]);}
$yvaleur[]=$row[$champ];
}
}
else {echo "0 results";}
$conn->close();
?>