PHP - Time Clock Time Worked

I have read almost every forum post I could find on this subject and still couldnt find what I am looking for.

What I need this program to do is allow an employee to punch in and punch out as often as needed. Then I need to be able to calculate the total time they were punched in for that day.

This is what I currently have set up.

The Database
id(auto inc) -- employee -- date -- time

Once the employee logs in I have a button they can click which will create a record in the database. What I need is to be able to do is run a mysql_query and show their total time.

I know there is still a lot left to script and code still. But I wanted to know if I am on the right track with the database. I wasnt sure if I should have two buttons "clock in" and "clock out" and record them in different columns, or if having one column for both clock in and out was sufficient for calculating hours.

I do not need the ability to change hours for an admin because I will be able to manually go into the database if need be. What I do need is to be able to keep this records so that you can look at past weeks.

<?php 
$user = $_SESSION['myusername'];
$result = mysql_query("SELECT * FROM hours WHERE member='$user'");

while ($row = mysql_fetch_array($result)){
echo $row['date'] . " " . $row['time'] . "<br />";
}die (mysql_error());

?>

This is what I currently have just to display all the records from the logged in user. I need to be able to subtract time and organize by date then by week.

Any help will be appreciated.

Thanks in advance.

PHP date and time function is not showing correct time on my local system

I have the following php code

date_default_timezone_set("Africa/Lagos");

$date = date('d-m-y h:i:s');

echo "Server Time ".$date ."<br>";

echo "The time is " . date("h:i:sa")."<br>";

$current_datetime = date("Y-m-d") . ' ' . date("H:i:s", STRTOTIME(date('h:i:sa')));

echo "Current time1: ".$current_datetime . "<br>";

 

Output

Server Time 21-05-21 09:55:39
The time is 09:55:39am
Current time1: 2021-05-21 09:55:39

 

Expected Output

Server Time 21-05-21 10:55:39
The time is 10:55:39am
Current time1: 2021-05-21 10:55:3

 

Any help would be appreciated.

 

Edited May 21 by Ponel

Basically I have recently been playing around with parsing a csv file. What I am looking to do at this point is simply take the date/timestamp (part of the csv file), which is in the following format:DD/MM HH:MM:SS.100th/s
For the sake of argument, lets say I have this in an array string called $csv[0] and the file has several lines that span the course of a couple hours. I wouldn't mind having to use explode() to breakup/remove the date or 100th/s IF that would make things a lot simpler.

So where would I start in trying to achieve this?. The result I am looking for will simply return "X Seconds". Storing this in a string variable would be a bonus, as I plan to use this to divide a separate piece of information.

Any examples or ideas would be great. Thank you.

ps:
Here is an example time from the csv file itself:
Code: [Select]
11/19 22:23:18.143

I am trying to simulate an ad expiration and carry out an action if the ad is expired. And I cannot get the if/else to work properly... I've tried many variations and I cannot see what I am doing wrong here. Any tips please 3 hours and counting of no solution!

$ad_start = time()-14 . "<br />"; // 14 days from today in the past (negative)
echo $ad_start;

$current_time = time() . "<br />"; // current epoch time
echo $current_time;

$days_past = $ad_start - $current_time; // days past

echo "<br />$days_past days have past since the ad started!<br />";

if($days_past <= 14)
{
echo "<br />Ad is less than 14 days.  Not expired.";
}
else
{
echo "<br />Ad is over 14 days. Expired.";
}

What are the differences and implications of UTC time and Zulu time?
  

<?php
function getArr(string $time):array
{
    $dateTime = new \DateTime($time);
    return [
        'time'=>$time,
        'timestamp'=> $dateTime->getTimestamp(),
        'dateTime' => $dateTime
    ];
}
$arr = getArr('2020-08-05');  
$arr_z = getArr('2020-08-05T00:00:00Z');  

print_r($arr);
print_r($arr_z);

echo('equal timestamps: '.($arr['timestamp'] === $arr['timestamp']?'true':'false'));

 

Array
(
    [time] => 2020-08-05
    [timestamp] => 1596585600
    [dateTime] => DateTime Object
        (
            [date] => 2020-08-05 00:00:00.000000
            [timezone_type] => 3
            [timezone] => UTC
        )

)
Array
(
    [time] => 2020-08-05T00:00:00Z
    [timestamp] => 1596585600
    [dateTime] => DateTime Object
        (
            [date] => 2020-08-05 00:00:00.000000
            [timezone_type] => 2
            [timezone] => Z
        )

)
equal timestamps: true