Skip to main content

Creating a Simple Activity Log Feature in Web App using PHP/PDO


This is a simple PHP/PDO tutorial script source code that tracks the system users' time log. The program was developed using PHP/PDO, MySQL Database, HTML, Javascript, jQuery, and Bootstrap. This will help you to learn how to create a simple activity log in your PHP web application. In this tutorial app, the system also updates automatically the login status of the user either online or offline. The online status automatically updates when a user successfully logged into the system while offline status will update when the user is successfully logged out.

These are the sample views of the web application

Login Page


Registration Page


Home/Activity Log Page


Mian Features

  • Login
  • Registration
  • Record User Login Log
  • Automatically Update User Log Status

The tutorial source code is free to download. Feel Free to download and modify the source code or make an experiment with the source code to enhance or widen your PHP programming capabilities/knowledge.

How to Run


  • Download and Install any local web server such as XAMPP/WAMP.
  • Download the provided source code zip file. (download button is located below)


  1. Open your XAMPP/WAMP's Control Panel and start the "Apache" and "MySQL".
  2. Extract the downloaded source code file.
  3. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
  4. Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
  5. Create a new database naming "demo".
  6. Import the provided SQL file. The file is known as "demo.sql" located inside the extracted source code folder.
  7. Browse the Simple Activity Log App in a browser. i.e. http://localhost/activitylog


That's it! Just register a new user and continuously log in and log out at first to populate the Activity log display. I hope this PHP Tutorial Script Source Code will help you with what you are looking for.

Happy Coding :)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


Add new comment