Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "practice";
- $conn = new mysqli($servername, $username, $password, $dbname);
- if( $conn->connect_error ) die("Connection failed: " . $conn->connect_error);
- $payload_dump = $_POST['payload'];
- $payload_array = json_decode($payload_dump,true);
- if( is_array( $payload_array ) ){
- $queries=array();
- foreach( $payload_array as $row ){
- //get the data_payload details
- $device = $row['device'];
- $type = $row['data_type'];
- $zone = $row['zone'];
- $sample = $row['sample'];
- $count = $row['count'];
- $time = $row['date_time'];
- $epoch = $row['epoch_stamp'];
- /*note: we do not need to add the semi-colon here as it gets added later when we implode the array */
- $queries[]="INSERT INTO `data` ( `device`, `type`, `zone`, `sample`, `count`, `date_time`, `epoch_stamp` ) VALUES ('$device', '$type', '$zone', '$sample', '$count', '$time', '$epoch')";
- }
- /*
- Previously the below query was being execute on every iteration
- ~ because $epoch is now the last one encountered in the array,
- the value that is updated in ALL records is as it would have been
- previously.
- */
- $queries[]="UPDATE `data` SET `date_time` = from_unixtime( $epoch ) WHERE date_time = 0;";
- $sql=implode( ';', $queries );
- if ( $conn->multi_query( $sql ) === TRUE ) {
- echo "New records created and updated successfully";
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- }
- $conn->close();
- ?>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- // Create connection
- $conn = new mysqli($servername, $username, $password);
- if( $conn->connect_error ) die("Connection failed: " . $conn->connect_error);
- ?>
- <?php
- include 'dbconnect.php';
- $payload_dump = $_POST['payload'];
- $payload_array = json_decode($payload_dump,true);
- if( is_array( $payload_array ) ){
- $queries=array();
- foreach( $payload_array as $row ){
- //get the data_payload details
- $device = $row['device'];
- $type = $row['data_type'];
- $zone = $row['zone'];
- $sample = $row['sample'];
- $count = $row['count'];
- $time = $row['date_time'];
- $epoch = $row['epoch_stamp'];
- //$queries[]="INSERT INTO `data` ( `device`, `type`, `zone`, `sample`, `count`, `date_time`, `epoch_stamp` ) VALUES ('$device', '$type', '$zone', '$sample', '$count', '$time', '$epoch')";
- $queries[]="INSERT INTO `data_test` ( `device`, `type`, `zone`, `sample`, `count`, `date_time`, `epoch_stamp` ) VALUES ('$device', '$type', '$zone', '$sample', '$count', '$time', '$epoch')";
- }
- //$queries[]="UPDATE `data` SET `date_time` = from_unixtime( $epoch ) WHERE date_time = 0;";
- $queries[]="UPDATE `data_test` SET `date_time` = from_unixtime( $epoch ) WHERE date_time = 0;";
- $sql=implode( ';', $queries );
- if ( $conn->multi_query( $sql ) === TRUE ) {
- echo "New records created and updated successfully";
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- }
- $conn->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement