newbie help
Posted: Wed Apr 14, 2004 12:54 am
How can i subtract time ?
ex. 23:30:15 - 18:15:35
thanks!
ex. 23:30:15 - 18:15:35
thanks!
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?php
$date1 = mktime(23,30,15,0,0,0);
$date2 = mktime(18,15,35);
$date3 = $date1 - $date2;
?>Code: Select all
<?php
$date3 = date("H:i:s" ,$date3);
?>Code: Select all
<?php
$time = "23:30:15"; // assuming that it is in hh:mm:ss format
$time = explode(":", $time);
// $time[0] = hour
// $time[1] = minute
// $time[2] = seconds
?>Code: Select all
$time1 = '23:30:15';
$time2 = '18:15:35';
list($hour, $minute, $second) = explode(':', $time1);
$t_time1 = mktime($hour, $minute, $second);
list($hour, $minute, $second) = explode(':', $time2);
$t_time2 = mktime($hour, $minute, $second);
echo date('h:i:s', $t_time1 - $t_time2);Code: Select all
$today = date("H:i:s");
include "./connect.php";
$connect = mysql_pconnect($dbhost,$dbusername,$dbuserpassword);
$result = mysql_db_query($dbname,"SELECT * from asian_field where code = '$code'");
$time1 = $row["timein"];
$time2 = $today;
list($hour, $minute, $second) = explode(':', $time1);
$t_time1 = mktime($hour, $minute, $second);
list($hour, $minute, $second) = explode(':', $time2);
$t_time2 = mktime($hour, $minute, $second);
$total = date('h:i:s', $t_time2 - $t_time1);
$query = "update asian_field set timeout = '$today', elapse_time = '$total' where code = '$code'";
$result = mysql_db_query($dbname,$query);You never set $row, maybe you are missing a :$time1 = $row["timein"];
Code: Select all
<?
$today = date("H:i:s");
include "./connect.php";
$connect = mysql_pconnect($dbhost,$dbusername,$dbuserpassword);
$result = mysql_db_query($dbname,"SELECT * from asian_field where code = '$code'");
$row = mysql_fetch_array($result);
$time1 = $row["timein"];
$time2 = $today;
list($hour, $minute, $second) = explode(':', $time1);
$t_time1 = mktime($hour, $minute, $second);
list($hour, $minute, $second) = explode(':', $time2);
$t_time2 = mktime($hour, $minute, $second);
$total = date('h:i:s', $t_time2 - $t_time1);
$query = "update asian_field set timeout = '$today', elapse_time = '$total' where code = '$code'";
$result = mysql_db_query($dbname,$query);
?>Don't worrydyowel wrote:sorry admin
Bech100 wrote:Don't worrydyowel wrote:sorry admin
Try echoing $time1 and $time2 to make sure they are the times you expect.
Post back saying what they were.
Mark