To select time of a day before

[sansoft]

Hi all,

i have got a table taskdatetime with fields entertime and outtime.this table is accessed by users who login and logout.the users logout after 9 hrs of work.
Now some users forget that they have to logout.So when they login the next day a message shud pop up that they have not registered the "logout THE DAY BEFORE"........plz tell me how will i access the record the day before.....................

i know tht subtracting now()-86400 will give me the day before ...but i still dont know how to access.....

Also my version of mysql< 4.1.1 so no modern functions plz

i can use only unix_timestamp function...nothing else...........


plz help......

Sansoft

[WiZARD]

i try help to you.
Algorythm not hevy.....

1) Get the current date (user loged in)
2) add this date into DB like lastvisit
user get out from site....
if user want to site again
3) check different from cuttent date and lastvisit

if you using that algorythm you may use any type of date
it's simple math

[Redcircle]

If you aren't restricted from doing it in mysql you can use PHP functions.

Code: Select all

<?php
$tomorrow  = mktime(0, 0, 0, date("m")  , date("d")+1, date("Y"));
$lastmonth = mktime(0, 0, 0, date("m")-1, date("d"),  date("Y"));
$nextyear  = mktime(0, 0, 0, date("m"),  date("d"),  date("Y")+1);
?>


same goes for the hours etc

[sansoft]

Hi all,

thank you very much....the problem is solved by using the following code..................

Code: Select all



$tomorrow  = mktime(0, 0, 0, date("m")  , date("d")-1, date("Y"));
$tomorrow = getdate($tomorrow);


if($tomorrow["mon"]<10)
{
$tomorrow["mon"]="0".$tomorrow["mon"];
}

if($tomorrow["mday"]<10)
{
$tomorrow["mday"]="0".$tomorrow["mday"];
}



$yesterday  = $tomorrow["year"] . "-" .$tomorrow["mon"] . "-". $tomorrow["mday"]." 00:00:00";

$sqllogouttime="select * from taskdatetime where date_format(outtime,'%Y-%c-%d')=date_format('$yesterday','%Y-%c-%d') and user_id='$sesuserid'";




$result=mysql_query($sqllogouttime,$conn);

$numrowsoflogout=mysql_num_rows($result);

if($numrowsoflogout==0  )
{


$sqlinsflag="insert into taskdatetime(user_id,entertime,outtime,flag)values('$sesuserid','$yesterday','$yesterday','absent')";
$resultinsflag=mysql_query($sqlinsflag,$conn);

header("location:message.php");
}