[SOLVED] Your last visit is Today?? - Page 2

Monie · October 25th, 2007, 05:48 AM

Ohh I see.. I get the idea now. Let me go back and play with my code.
I'll let you know yesterday! I mean tomorow.. lol

Thanks..

c010depunkk · October 25th, 2007, 05:55 AM

Code:


			
<?php
echo('Your last visit was '.($row['lastvisited']==$todays_date?'Today':($row['lastvisited']==$yesterdays_date?'Yesterday':$row['lastvisit'])).'!');
?>

Marc · October 25th, 2007, 05:58 AM

Go away... Smartie pants... lol

Rob · October 25th, 2007, 06:36 AM

Instead of this code

Code:

dim dd, mm, yyyy, newtime, newdate
        dd=day(date)
    if len(dd)=1 then
        dd="0" & dd
    end if
        mm=month(date)
    if len(mm)=1 then
        mm="0" & mm
    end if
        yyyy=year(date)
    
    'getting new date
    newdate = dd & "-" & mm & "-" & yyyy

Use this:-

Code:

newdate = date(now)

DO NOT store 'today' in the database.... store an actual date/time instead

The correct method to show 'today' would be a comparison when displaying the thing....
not when entering it in the database.

Does that make sense?

Daniel · October 25th, 2007, 06:55 AM

My head hurts

Marc · October 25th, 2007, 07:07 AM

Quote:

Originally Posted by Daniel

My head hurts

Thats ASP for ya

Monie · October 25th, 2007, 09:06 PM

Hey guys.. check out what I've come up with!

I don't know if this way can be consider a "creative" way, but I have accomplished what I am trying to get.

It's not a PHP code, I just use the php tag so that I get a nice colorful ASP code, lol.

Code:

<%    
    dim dd, mm, yyyy, newtime, newdatetoday, newdateyesterday, newdatelastweek, lastweek, yesterday

    dd = day(date) //todays date
    yesterday = dd - 1 //yesterdays date
    lastweek = dd - 7 //last week date
    mm = month(date)    
    yyyy=year(date)

    If Len(dd) = 1 Then
        dd="0" & dd //Add '0' to DD that start with 1-9
    End If    
   
    If len(mm) = 1 Then
        mm="0" & mm
    End If    
    
    //Todays date
    newdatetoday = dd & "-" & mm & "-" & yyyy
    //Yesterdays date
    newdateyesterday = yesterday & "-" & mm & "-" & yyyy
    //Last Week date (exactly 7 days ago)
    newdatelastweek = lastweek & "-" & mm & "-" & yyyy
    //Get time
    newtime = time()
  
    dim lastvisit
    lastvisit = rs("lastactivedate")
       
    If (cdate(lastvisit)) = (cdate(newdatelastweek)) Then
        lastvisit = "Last Week"
    Else If (cdate(lastvisit)) = (cdate(newdateyesterday)) Then
        lastvisit = "Yesterday"
    Else If (cdate(lastvisit)) = (cdate(newdatetoday)) Then
        lastvisit = "Today"
    Else    
        lastvisit = rs("lastactivedate")
    End If
%>

Your last activity: <%Response.Write(lastvisit)%>

CDate function converts a valid date (and time) expression to type Date. After converting them, I found out I can make the comparison directly. I don't know if this can be done in PHP?

Hey Rob, I'll check out your code!

Monie · November 1st, 2007, 01:16 AM

I got it the updated version, much more structured and understandable:

Code:

<%    
    Dim todaytime, todaydate, yesterdaysdate, lastweekdate

    todaydate = (cdate(date())) 'today date
    yesterdaysdate = (cdate(date())) - 1 'yesterdays date
    lastweekdate = (cdate(date())) - 7 'lastweek date
    todaytime = FormatDateTime(Now(), vbShortTime) 'show today time in mm:hh format (24 hour clock)

    If Session("name") <> "" Then
        dim lastvisit
        lastvisit = rs("lastactivedate")
        
        If lastvisit <> "" Then
            If (cdate(lastvisit)) = lastweekdate Then
                lastvisit = "Last Week"
            ElseIf (cdate(lastvisit)) = yesterdaysdate Then
                lastvisit = "Yesterday"
            ElseIf (cdate(lastvisit)) = todaydate Then
                lastvisit = "Today"
            Else    
                lastvisit = rs("lastactivedate")
            End If
        End If
    End If    
%>

Code:

<body>
   You last visited: <%Response.Write(lastvisit)%>
</body>