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