User login and registration system built using PHP and MySQL. User login, registration and logout time also saved in database to track user activity.
- Install Xampp and Start Apache Server and MySQL Server.
- Type http://localhost/phpmyadmin in chrome tab. It will head to phpMyAdmin where all MySQL databases are stored.
- Import users SQL file in phpMyAdmin to set up database.
- Type http://localhost/phpmyadmin in chrome tab to access website features.
- Once the user registered, account created time is stored in users table under created_at column.
- Registered user can login into the website and can logout. Both login and logout times are stored in user_logins table.
- If the same user logged in again then it is also stored in new row with the same user id in user_logins table.
- Time is stored based on IST. India Standard Time (IST) is 5:30 hours ahead of Coordinated Universal Time (UTC).
It is helpful to track user activity for implemented website.