timestamp script weird problem

[Miko]

Hi!

 

To calculate my real time hours worked for/at a client I've made 3scripts, 1 to start the time, 1 to show the running time and 1 for stopping it.

The first and last are put into my hosted DB. I'm accessing them through SSH so that I don't need my laptop all the time.

 

Now here's the problem, when I start the time and I look into my DB I see the actual correct time and date (timestamp), but when I execute the script for stopping it the start time changes, so for example I started at 9:00, that time will be changed to for example 11:00 when I stop it... very strange, here are my scripts:

 

start:

 

<?php
date_default_timezone_set('Europe/Brussels');
$timestamp = date('Y-m-d H:i:s');
$conn = mysql_connect('server' 'user', 'pw') or die(mysql_error());
mysql_select_db('hystudi_timesheets', $conn) or die(mysql_error());
mysql_query("INSERT INTO timesheet (t_start_timestamp) VALUES ('$timestamp')", $conn) or die(mysql_error());
?>

 

stop:

 

<?php
date_default_timezone_set('Europe/Brussels');
$timestamp = date('Y-m-d H:i:s');
$conn = mysql_connect('server', 'user', 'pw') or die(mysql_error());
mysql_select_db('hystudi_timesheets', $conn) or die(mysql_error());
$records = mysql_query("SELECT id, t_start_timestamp FROM timesheet ORDER BY id DESC LIMIT 1");
while ($row = mysql_fetch_array($records)) {
        $id = $row['id'];
        $start_timestamp = date("U", strtotime($row['t_start_timestamp']));
}
$duration = (date("U", strtotime($timestamp)) - $start_timestamp) / 3600; // duration
mysql_query("UPDATE timesheet SET t_end_timestamp = '$timestamp', t_calculated_time = '".round($duration,2)."' WHERE id = $id", $conn) or die(mysql_error());
?>

 

Anyone sees what I'm doing wrong here? Or could it be my server? It's a shared host

[lenstanbera]

I'm new to PHP but done some C++, but as much as I see they are very similar. when you assign value to variable, it's stored in memory until it's unset "PHP". you using the same variable $timestamp in stop script as in start, statement: $timestamp = date('Y-m-d H:i:s'); in stop script gives $timestamp date-time value of time stop script is executed, hence reassigning new date-time value. In stop script, replace $timestamp variable with something different eg: $stop_timestamp or anything you fancy, so stop script should look like this:

 

 

<?php

date_default_timezone_set('Europe/Brussels');

$stop_timestamp = date('Y-m-d H:i:s');

$conn = mysql_connect('server', 'user', 'pw') or die(mysql_error());

mysql_select_db('hystudi_timesheets', $conn) or die(mysql_error());

$records = mysql_query("SELECT id, t_start_timestamp FROM timesheet ORDER BY id DESC LIMIT 1");

while ($row = mysql_fetch_array($records)) {

        $id = $row['id'];

        $start_timestamp = date("U", strtotime($row['t_start_timestamp']));

}

$duration = (date("U", strtotime($stop_timestamp)) - $start_timestamp) / 3600; // duration

mysql_query("UPDATE timesheet SET t_end_timestamp = '$stop_timestamp', t_calculated_time = '".round($duration,2)."' WHERE id = $id", $conn) or die(mysql_error());

?>

 

As I've mentioned I'm new to PHP, so hopefully this solution helps. If not, hopefully somebody else will come up with it.

 

[Miko]

Thanks lenstanbera,

 

It didn't work the way you say, but what I've done is when I get the record I take the t_start_timestamp value and store it in a seperate variable, then I update both t_start_timestamp AND t_end_timestamp.

 

Seems that the problem was my hosting server, since this one is in the US and I'm in Belgium the server updated the t_start_timestamp to the local acutal time. After checking the parameters of my table I saw that I've set the t_start_timestamp to 'CURRENT TIME' or something like that ... changed this and problem solved

[lenstanbera]

glad you've sorted the problem pal. I'm in Scotland not far from u; ;-P