Students Online Internship Timesheet System using PHP/MySQLi with Source Code

Project: Students Online Internship Timesheet System using PHP/MySQLi

About

The Students Online Internship Timesheet System is a simple PHP/MySQLi project that manages the college students' attendance who will undergo their internship or On the Job Training (OJT). The system has a timer feature that counts the intern student rendered time or duration on the specific company. This system stores the student's list and company list. The students' online internship timesheet system has 2 types of user which is one is the admin who manages the master list of the system, monitors the rendered time or duration of the students and has access for the printable rendered duration report of the student, and the other user type is the student which they can use the timer feature in this system. Talking about the timer feature for the student attendance, the student will simply click the start button to start the timer for the duration calculation he/she rendering to the company and when they stop the timer they will be required to input remarks or they can also enter their task they have done during the timer is running. It is not necessary that each day the student will only start and stop the timer once because the system doesn't have a scheduling feature.

Features

• Login Page
  • The page where the system admin and the students submit their system credentials to access the data and functionalities of the system.
• Home Page
  • The page where the system admin will be redirected by default when logging into the system. This page displays the time duration rendered of all students in the calendar view.
• Company Page
  • The page where the admin manages the list of the companies who allows their students to undergo their OJT training to their company.
• Student Page
  • The page where all the students are listed and managed by the admin.
• Courses Page
  • The page where the list of school courses are listed and managed.
• Attendance Page
  • The page where the list of the students rendered time of their internship or OJT is listed.
• Internship Report Page
  • The page where the students' printable internship attendance report is being shown.
• Users Page
  • ​​​​​​​The page where the system admin manages the list of system admin users or staff.

The Students Online Internship Timesheet System was developed using HTML, PHP/MySQLi, CSS, JavaScript (jQuery/Ajax), and Bootstrap for the design. The source code is fully functional and easy to modify or enhance. Follow the instruction below to have an actual experience using this simple project.

How to Run

1. Download the source code and extract the zip file.
2. Download or set up any local web server that runs PHP script.
3. Open the web-server database and create a new database name it soits_db.
4. Import the SQL file located in the database folder of the source code.
5. Copy and paste the source code to the location where your local web server accessing your local projects. Example for XAMPP('C:\xampp\htdocs')
6. Open a web browser and browse the project. E.g [http://localhost/students-online-internship-timesheet-system]

Admin Default Access

Username: admin

Password: admin123

I hope the simple Students Online Internship Timesheet System will help you with what you are looking for, feel free to download and modify the source code.

Explore more on this website for more source codes and tutorials.

Enjoy!