what is wrong with the code?

[kiril86]

<?php
$servername = "localhost";
$username = "xxx";
$password = "xxx";
$dbname = "energy";


date_default_timezone_set("Europe/Sofia");
$h = date('H');
$m = date('i');
$month = date('n');
//$year = date('Y');


// Create connection
// $conn = mysqli_connect($servername, $username, $password, $dbname);

$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
switch ($month) {

case 12: {
if ($h >= 06 && $m >= 00) {

$sql = "INSERT INTO test2 (resultat, current )
VALUES (100 , 50)";
}
}
break;
}

$result = $conn->query($sql);
if ($result == true) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>

 

[MilesWeb]

You can update switch case code :

switch ($month) {
case 12:
if ($h >= 6) {
$sql = "INSERT INTO test2 (resultat, current) VALUES (100, 50)";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
break;
}