🔒 Closed Java netbeans . Log book? Login History?

[PHC-Minchi]

Pano po gumawa yung makikita yung table ng mga user na naglogin kasama yung oras tsaka date? kumbaga parang log book?

 

[dontescape]

hmmm kada login gumawa ka ng another insert sql command and i insert mo yung username and then gawa ka ng column na timestamp sa sql mo . then automatic na yun. kada login masasave yung username and time kelan naglogin.

 

[PHC-Minchi]

hmmm kada login gumawa ka ng another insert sql command and i insert mo yung username and then gawa ka ng column na timestamp sa sql mo . then automatic na yun. kada login masasave yung username and time kelan naglogin.

ayun thanks po

 

[aa1012]

Create a "login logs" table and then create an insert trigger statement in every login of a user. You also need to create an update trigger for every logout of a user. That's the best and easiest way.

 

[PHC-Minchi]

Create a "login logs" table and then create an insert trigger statement in every login of a user. You also need to create an update trigger for every logout of a user. That's the best and easiest way.

di ko po magets . wala rin akong makitang tuts sa youtube hayss

 

[aa1012]

di ko po magets . wala rin akong makitang tuts sa YôùTùbé hayss

Wala talaga kasi sariling diskarte yan. Maiisip mo yan kung marunong ka talaga sa SQL Basics. Aral ka muna.

 

[dontescape]

di ko po magets . wala rin akong makitang tuts sa YôùTùbé hayss

logic is the key