View difference between Paste ID: xgetqhr2 and bCMmLjwh
SHOW: | | - or go back to the newest paste.
1
<?php
2
define ('DB_HOST', '');
3
define ('DB_USER', '');
4
define ('DB_PASS', '');
5
define ('DB_NAME', '');
6
7
$host = DB_HOST;
8
$user = DB_USER;
9
$password = DB_PASS;
10
$dbname = DB_NAME;
11
$db = mysqli_connect( $host, $user, $password, $dbname );
12
13
$timestamp = date('Y-m-d H:i:s', $argv[2]);
14-
         $table="InstantPower";
14+
15-
         $keys = "instantPower, Dates, Times";
15+
16
$date = $splitTimeStamp[0];
17
$time = $splitTimeStamp[1];
18-
 {
18+
19-
        $table = "TotalPower";
19+
20-
        $keys = " totalActivePower, Dates, Times";
20+
	$stmt = mysqli_prepare($db, "
21
            INSERT INTO 
22
		InstantPower 
23
		(instantPower, Dates, Times, Calculated) 
24
	    VALUES
25
		(?, ?, ?, ?) 
26
	";
27
28
	$calculated = $argv[1] / 1; // tydligvis???
29-
$values  = "'{$argv[1]}', '{$date}', '{$time}'";
29+
        mysqli_stmt_bind_param("dssd", $argv[1], $date, $time, $calculated);
30
}
31-
$query = "INSERT INTO {$table} ($keys) VALUES($values)";
31+
32-
mysqli_query ( $db, $query );
32+
{
33
	$stmt = mysqli_prepare($db, "
34
            INSERT INTO 
35
		TotalPower 
36
		(totalActivePower, Dates, Times) 
37
	    VALUES
38
		(?, ?, ?) 
39
	";
40
41
        mysqli_stmt_bind_param("dss", $argv[1], $date, $time);
42
}
43
44
mysqli_stmt_execute($stmt);