Hi there I have a device that sends values from my sensors to table called 'sensors'... in my table I have a column called 'event' which is TIMESTAMP, date and time from my server which is -8 hours of my local time... because my device can't send time and date to my table, I try to call my server admin to change the timezone of the server but no luck from there, so now I need somehow when ever the device sends data to table in 'mytime' column to put 'event'TIMESTAMP+8hours how do I do that? here is my code
<?php
// Connect to MySQL
include("dbconnect1.php");
// Prepare the SQL statement
mysqli_query($dbcon,"SELECT * FROM sensors");
mysqli_query($dbcon,"INSERT INTO sensors (sensor1 ,sensor2, sensor3, sensor4, sensor5, sensor6 ,sensor7, sensor8, sensor9, sensor10, sensor11, sensor12)
VALUES ('".$_GET["s1"]."', '".$_GET["s2"]."','".$_GET["s3"]."','".$_GET["s4"]."','".$_GET["s5"]."','".$_GET["s6"]."','".$_GET["s7"]."','".$_GET["s8"]."','".$_GET["s9"]."','".$_GET["s10"]."','".$_GET["s11"]."','".$_GET["s12"]."')");
mysqli_close($dbcon);
?>