[SOLVED] Your last visit is Today??

Monie · #1 Oct 23rd, 2007, 09:04

Just wondering how to do that?
Instead of displaying today's date, it display "Today".

Thanks..

Marc · #2 Oct 23rd, 2007, 09:29

It will be a little IF function... I guess but i am no PHP expert

karinne · #3 Oct 23rd, 2007, 12:28

Yeah ... I would use a simple IF function that IF the date is today, then display Today.

alexgeek · #4 Oct 23rd, 2007, 16:18

PHP-section?

If you have any code I might be able to edit it for you.

karinne · #5 Oct 23rd, 2007, 16:32

monie usually posts in the ASP section ... but he didn't specify so I left it here.

AdRock · #6 Oct 23rd, 2007, 18:34

Surely a cookie must be set so it knows when you last logged in

Marc · #7 Oct 23rd, 2007, 18:49

Quote:

Originally Posted by AdRock

Surely a cookie must be set so it knows when you last logged in

By my reckoning monie never asked how the login works.. He asks how it displays today instead of the date.... Thus uses an IF function....

AdRock · #8 Oct 23rd, 2007, 19:17

Quote:

Originally Posted by Marc

By my reckoning monie never asked how the login works.. He asks how it displays today instead of the date.... Thus uses an IF function....

Ahh...i see

I was just thinking if you hadn't logged for a few days, how it knows when you last logged in

Marc · #9 Oct 23rd, 2007, 19:23

It would then probubly use a Cookie... No, not a chocolate chip one

Daniel · #10 Oct 24th, 2007, 00:18

Its a bit of php script that uses the server calendar to determine what day it is.

Monie · #11 Oct 24th, 2007, 01:42

Quote:

Originally Posted by alexgeek

PHP-section?

If you have any code I might be able to edit it for you.

I can smell php code alex... but I prefer ASP

I think, either way, the solution would be almost similar, right?

Quote:

Originally Posted by karinne

monie usually posts in the ASP section ... but he didn't specify so I left it here.

Ahh... you notice that

It's because I don't know if this is done with asp or javascript or maybe php. So I post it here. Could you move this thread to the ASP section karinne, thanks.

Quote:

Originally Posted by AdRock

Ahh...i see

I was just thinking if you hadn't logged for a few days, how it knows when you last logged in

I use an update statement that capture todays date and time and update them in the database once the user log off..

Logout page:

Code: Select all

<%
    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
    newtime = time()
%>
<%
Dim connectionString, rs, conn, user
user = Session("name")
    
connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=monieweb; UID=root;PASSWORD=monie;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open(connectionString)
Set rs = conn.Execute("UPDATE userlogin SET status = 'Offline', lastactivedate = '" & newdate & "', lastactivetime = '" & newtime & "' WHERE username =  '" & user & "'")

Session.Abandon
Response.Redirect("default.asp")
%>

Greeting Page:

Code: Select all

Welcome <%=rs("fullname")%>! Your last visit here is <%=rs("lastactivedate ")%> at <%=rs("lastactivetime ")%>

karinne · #12 Oct 24th, 2007, 13:32

Quote:

Originally Posted by monie

Ahh... you notice that

It's because I don't know if this is done with asp or javascript or maybe php. So I post it here. Could you move this thread to the ASP section karinne, thanks.

Oh yes I notice

This is my zoo after all ... apparently!

Monie · #13 Oct 25th, 2007, 02:02

Quote:

Originally Posted by karinne

Oh yes I notice

This is my zoo after all ... apparently!

yeah, I heard you say that before! I can't remember where? lol..

alexgeek · #14 Oct 25th, 2007, 07:08

Jacob's thread.

Monie · #15 Oct 25th, 2007, 07:30

Quote:

Originally Posted by alexgeek

Jacob's thread.

Ohh yeah...

Ok back to topic guys..

Quote:

Originally Posted by karinne

Yeah ... I would use a simple IF function that IF the date is today, then display Today.

How does we make the checking as karinne suggest. Obviously, in my example, we have to query the "lastactivedate" from my database and make comparison to the current date. I don't get the picture how to do that?

Hemmm....

Marc · #16 Oct 25th, 2007, 09:10

This is PHP but it will maybey give you the layout!! I am no expert!! (I know you want it in ASP but it might give you a rough way how to do it!)

PHP: Select all



if($row['lastvisited'] == $todays_date) {
// The person did visit today
echo "Your last visit was Today - Welcome!";

} else {
// The person never visited today
echo "Your last visit was" . $row['lastvisited'];
}

Please bear in mind this is the way i would do it in PHP so it probubly isnt right!!

Also i havent included the select statement - you probubly know how to do it.....

Ignore $row['lastvisited'] - that would be the way i was doing it if i was using PHP - instead use your variable for getting the date from the database.

Hope that helps bearing in mind i done it in PHP - not ASP

Monie · #17 Oct 25th, 2007, 09:25

Quote:

Originally Posted by Marc

This is PHP but it will maybey give you the layout!! I am no expert!! (I know you want it in ASP but it might give you a rough way how to do it!)

Please bear in mind this is the way i would do it in PHP so it probubly isnt right!!

Also i havent included the select statement - you probubly know how to do it.....

Ignore $row['lastvisited'] - that would be the way i was doing it if i was using PHP - instead use your variable for getting the date from the database.

Hope that helps bearing in mind i done it in PHP - not ASP

Relax Marc, I understand a little bit of PHP as I am learning them if I have a free time. I do understand your code there 100%, but...
it only check

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
[SOLVED] Your last visit is Today??