Examination Task Handling System runs on the intranet and it has mainly two sections, one section for administration to add relevant data to the system and to control the system whereas other section is for student and lecturers who will view the content of the system which are relevant and important to them. In this system users will be able to view examination timetables, results, student GPA values, student rankings. Moreover it has a separate discussion forum to discuss any subject matters, examination related problems and other important information.
This web based system was designed using object oriented concepts and was developed using PHP, which is a powerful server-side scripting language, MySQL was used as the Database Management System and Apache was used as the web server.
First of all check whether Apache.MySQL and PHP are already installed. If not install them first. Then follow the procedure given below.
To load the contents of the "Database\university.sql" file into MySQL, use the following procedure:
- Goto Command Prompt
- Change directory to where the university.sql file is located
- Then issue this command: mysql -u username –p password (where username and password are your root username and password in MySQL)
- Load the contents of university.sql using following command mysql> SOURCE university.sql;
- You will see quite a bit of output as mysql reads queries from the university.sql file and executes them.
Now you have successfully created the database
All the system files are inside “ETHS”. This folder should be copied to the document directory of the Apache server. i.e.‘htdocs’ folder in Apache installation path.
In this php file, mysql_connect('localhost','root','') is used to connect to the mysql server where 'localhost' is the server, 'root' is the username and ' ' is the password. Change them according to your settings.
• post_max_size = 20M • upload_max_filesize = 20M
• key_buffer = 16M • max_allowed_packet = 16M (appears in two places)
Now you are ready to use the system. You can test the system by running on localhost.
Create domains relevant to administrator,lecturer or student logins on the intranet. Then login and use the system.