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