[Sourceforce]
Version 1.0
TABLE OF CONTENTS
Introduction |
Download & Installation |
How To Use |
For Developers |
INTRODUCTION
WHAT IS “I WAS HERE”?
I Was Here is a simple, free, and open source PHP Student Attendance Management System. It may not be the best in the world, but it is at least a complete basic system and will give the developers a quick boost with all the essentials done.
Built using pure HTML, CSS, and Javascript – I Was Here has no dependency on third-party client-side frameworks such as jQuery or Bootstrap. No need to learn any of those, and no added script bloating.
LICENSE
I Was Here is released under the MIT License – You are free to use it for your own personal and commercial projects, modify it as you see fit. On the condition that there the software is provided “as-is”. There are no warranties provided and “no strings attached” – Code Boxx and the authors are not liable for any claims, damages, or any liabilities.
CREDITS
I Was Here is made better with the following:
DOWNLOAD & INSTALLATION
DOWNLOAD & REQUIREMENTS
You can download I Was Here from Sourceforge. I Was Here has not been extensively tested, but it should work well with most modern XAMPP installations –
- PHP 5.6 and above.
- Apache web server.
- Should work on IIS as well.
HOW TO INSTALL
- Create a new database and import iwashere.sql inside the lib folder.
- Update the database settings in lib/config.php
- Done! The default administrator account is admin@iwh.com and password is 123456.
HOW TO USE
STEP 1) REGISTER USERS
First, register all the students under the “users” tab. You can use the import function to quickly upload a list of students.
STEP 2) REGISTER COURSES
Next, register your available courses under the “courses” tab. For example, English, Math, Science, Computer, Marketing, etc…
STEP 3) STUDENTS TO COURSES
When you are done with registering the students and courses, it is time to assign the students to their respective courses. Again, you can use the import function to quickly upload a list of students.
STEP 4) CREATE CLASSES
Following up, create your classes under the “attendance” tab.
STEP 5) TAKE ATTENDANCE
Finally, take the attendance of the students in the class. You can export the attendance sheet into a spreadsheet if you want.
FOR THE DEVELOPERS
FOLDER STRUCTURE
-
/
The base project folder holds all the landing pages and AJAX handlers.lib/
This is the library folder that holds all the config and critical library files. Not publically accessible.public/
This is where all the client-side scripts and assets are put in – Images, CSS, and Javascript.vendor/
Contains PHPSpreadSheet.
DATABASE TABLES
Field | Description |
user_id | The user ID, primary key, auto-increment. |
user_name | Name of the user. |
user_email | Email of the user, unique and does not allow duplicates. |
user_role | Teacher or Student. |
user_password | Account password. |
Field | Description |
course_code | The course code, primary key. |
course_name | Name of the course. |
course_desc | A short description of the course. |
Field | Description |
course_code | The course code, primary key. |
user_id | The user ID, primary key. |
Field | Description |
class_id | The class ID, primary key, auto-increment. |
couse_code | The course code. |
class_date | Date and time of the class. |
class_desc | Short description of the class. |
Field | Description |
class_id | The class ID, primary key. |
user_id | The user ID, primary key. |
GENERAL FLOW
The entire project folder may seem to be a little complicated at the first look, but it is actually pretty well organized and straightforward. The generic sequence of how the scripts will be loaded when a user access a page is:
- The landing page will be loaded first when the user accesses a page. For example, the courses page is courses.php in the base folder.
- The related Javascript files are all placed inside the public folder – For example, courses.js in the public folder.
- All user actions will be processed via AJAX. For example, adding a new course will be handled by the ajax-courses.php file.
- Finally, the library files deal with all the database SQL processing – For example, LIB-courses.php in the lib folder.
COMPONENTS & FILES
Component | Related Files |
Users | Landing page – users.php
Javascript – public/users.js AJAX handler – ajax-users.php Library file – lib/LIB-user.php |
Courses | Landing page – courses.php
Javascript – public/courses.js AJAX handler – ajax-courses.php Library file – lib/LIB-course.php |
Classes | Landing page – classes.php
Javascript – public/classes.js AJAX handler – ajax-class.php Library file – lib/LIB-class.php |
Attendance | Note – This is a component that allows students to view their own attendance records only.
Landing page – attendance.php Javascript – public/attendance.js AJAX handler – ajax-attendance.php Library file – lib/LIB-attendance.php |
Login | Landing page – login.php
Javascript – public/login.js AJAX handler – ajax-session.php Library file – lib/LIB-user.php |
SESSION VARIABLES
Well, the only thing that is put into the session is the user information upon successful login.
Field | Description |
id | The user ID. |
name | User name. |
User email. | |
role | User role. |
iwashere.sql error excute
https://code-boxx.com/faq/#notwork
https://code-boxx.com/import-sql-file-in-mysql/