<?php
define ('DB_HOST', '');
define ('DB_USER', '');
define ('DB_PASS', '');
define ('DB_NAME', '');

$host = DB_HOST;
$user = DB_USER;
$password = DB_PASS;
$dbname = DB_NAME;
$db = mysqli_connect( $host, $user, $password, $dbname );

$timestamp = date('Y-m-d H:i:s', $argv[2]);

$splitTimeStamp = explode(" ",$timestamp);
$date = $splitTimeStamp[0];
$time = $splitTimeStamp[1];

if (isset($argv[3]) && $argv[3] === "instantkw") {
	$stmt = mysqli_prepare($db, "
            INSERT INTO
		InstantPower
		(instantPower, Dates, Times, Calculated)
	    VALUES
		(?, ?, ?, ?)
	";

	$calculated = $argv[1] / 1; // tydligvis???
        mysqli_stmt_bind_param("dssd", $argv[1], $date, $time, $calculated);
}
else
{
	$stmt = mysqli_prepare($db, "
            INSERT INTO
		TotalPower
		(totalActivePower, Dates, Times)
	    VALUES
		(?, ?, ?)
	";

        mysqli_stmt_bind_param("dss", $argv[1], $date, $time);
}

mysqli_stmt_execute($stmt);