Hello everyone,
Here i got my work to create a program that has login and logout system. (and also another feature)
I want to do tracking to login and logout system.
So,
If user1 do login, then the system puts the user1 id number and name and create new record. (I used append query)
if user1 do logout, then the system update the record to the user1 record. (I used update query)
then if user2 do login, then the system do the same as the other login.
if user2 logout then same
but, if in another time, user1 do login again, then the system puts the user1 id number and name into new record. (not the same record as before)
and when user1 do logout, the system update its record
How does it work?
i've been googling for my probs, but i got nothing
could someone help me?
Thanks
The table that hold the user log contains :
1. No (as primary key and set to autonumber) -> i think to specify the append and update query
2. ID (the user id number)
3. Account (the user name)
4. Login date (i append this to date())
5. Login time (append as time())
6. Logout date (same as above)
7. Logout time (same as above)
The table could be like this :
No ID Login Date Login Time Logout Date Logout Time
1 user1 23/02/2016 01.00 23/02/2016 02.00
2 user2 24/02/2016 10.00 24/02/2016 12.00
3 user1 24/02/2016 02.00 24/02/2016 05.00
4 user2 25/02/2016 01.00 25/02/2016 02.00
5 user3 25/02/2016 05.00 25/02/2016 05.30
Here i got my work to create a program that has login and logout system. (and also another feature)
I want to do tracking to login and logout system.
So,
If user1 do login, then the system puts the user1 id number and name and create new record. (I used append query)
if user1 do logout, then the system update the record to the user1 record. (I used update query)
then if user2 do login, then the system do the same as the other login.
if user2 logout then same
but, if in another time, user1 do login again, then the system puts the user1 id number and name into new record. (not the same record as before)
and when user1 do logout, the system update its record
How does it work?
i've been googling for my probs, but i got nothing
could someone help me?
Thanks
The table that hold the user log contains :
1. No (as primary key and set to autonumber) -> i think to specify the append and update query
2. ID (the user id number)
3. Account (the user name)
4. Login date (i append this to date())
5. Login time (append as time())
6. Logout date (same as above)
7. Logout time (same as above)
The table could be like this :
No ID Login Date Login Time Logout Date Logout Time
1 user1 23/02/2016 01.00 23/02/2016 02.00
2 user2 24/02/2016 10.00 24/02/2016 12.00
3 user1 24/02/2016 02.00 24/02/2016 05.00
4 user2 25/02/2016 01.00 25/02/2016 02.00
5 user3 25/02/2016 05.00 25/02/2016 05.30