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();

?>

 

Edited December 19, 2023 by Psycho
Formatted code content

[Moorcam]

What errors are you getting, if any?

Also, use the code tags when posting to make it easier to read.

[kiril86]

I don't get any mistakes- the code is not acting automatically, but only when i access it through "Localhost".

[requinix]

43 minutes ago, kiril86 said:

but only when i access it through "Localhost".

...how else are you accessing it?

[Barand]

47 minutes ago, kiril86 said:

I don't get any mistakes

Then try running it when it isn't December or before 6am.

[kiril86]

I dont't want to access it at all- wihtout accessing it through localhost i want automatically to post the data at the database. 

[kiril86]

It's working like that:

 

$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');

$conn = mysqli_connect($dbservername, $dbusername, $dbpassword, $dbname);
$api_key_value = "tPmAT5Ab3j7F9";
$api_key =  $voltage = $current =  $frequency = $power = $energy  =  "";

if ($_SERVER["REQUEST_METHOD"] == "POST") {

    $api_key = ($_POST["api_key"]);
    if($api_key == $api_key_value) {

        $voltage = ($_POST["voltage"]);
        $current = ($_POST["current"]);
        $frequency = ($_POST["frequency"]);
        $power = ($_POST["power"]);
        $energy = ($_POST["energy"]);

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

        // Check connection
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }

        switch($month) {

            case 12:{

                if   (($h >= 06 && $m >=00 )  && ($h <= 21 && $m <=59))   {                  
                    $sql = "INSERT INTO energy_home_January (voltage,current,frequency,power,energy)
                           VALUES ('" . $voltage . "', '" . $current . "', '" . $frequency . "', '" . $power . "', '" . $energy . "')";
               }
               else{
                    $sql = "INSERT INTO energy_home_January_night (voltage,current,frequency,power,energy)
                            VALUES ('" . $voltage . "', '" . $current . "', '" . $frequency . "', '" . $power . "', '" . $energy . "')";
                   }  
           }
           break;

 

[kiril86]

 

But I want to use this.  

INSERT INTO test3(
    id,
    voltage,
    current,
    frequency,
    power,
    energy,
    reading_time,
    resultat
)

SELECT
    id,
    voltage,
    current,
    frequency,
    power,
    energy,
    reading_time,
    energy - LAG(energy) OVER(ORDER BY id) AS temp

FROM
    energy_home_november

 

[Moorcam]

Insert Automatically?

I think you need to learn about php and MySQL etc. Here's a good place to start - https://www.phptutorial.net/php-pdo/php-pdo-insert/

[Barand]

24 minutes ago, kiril86 said:

I dont't want to access it at all- wihtout accessing it through localhost i want automatically to post the data at the database. 

Write it as a CLI script and use a CRON job to run it as frequently as required