Page - 119
Coding for Announcement.php
###Code for save announcement#####
function save_announcement()
$statement = "UPDATE `announcement` SET";
$cond = "WHERE `announcement_id` = '$R[announcement_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `announcement` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`announcement_title` = '$R[announcement_title]',
`announcement_class_id` = '$R[announcement_class_id]',
`announcement_teacher_id` = '".
$_SESSION['user_details']['user_id']."',
`announcement_date` = '$R[announcement_date]',
`announcement_description` = '$R[announcement_description]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
header("Location:../announcement-report.php?msg=$msg");
}
#########Function for delete announcement##########3 function delete_announcement()
{
/////////Delete the record//////////
Page - 121
$SQL="DELETE FROM announcement WHERE announcement_id =
$_REQUEST[announcement_id]";
mysql_query($SQL) or die(mysql_error());
header("Location:../announcement-report.php?msg=Deleted Successfully.");
###Code for save announcement#####
$statement = "UPDATE `announcement` SET";
$cond = "WHERE `announcement_id` = '$R[announcement_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `announcement` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`announcement_title` = '$R[announcement_title]',
`announcement_class_id` = '$R[announcement_class_id]',
`announcement_teacher_id` = '".
$_SESSION['user_details']['user_id']."',
`announcement_date` = '$R[announcement_date]',
`announcement_description` = '$R[announcement_description]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
Page - 123
header("Location:../announcement-report.php?msg=$msg");
}
#########Function for delete announcement##########3 function delete_announcement()
{
/////////Delete the record//////////
$SQL="DELETE FROM announcement WHERE announcement_id =
$_REQUEST[announcement_id]";
mysql_query($SQL) or die(mysql_error());
header("Location:../announcement-report.php?msg=Deleted Successfully.");
}
###Code for save class#####
function save_class() {
$R=$_REQUEST;
if($R[class_id]) {
$statement = "UPDATE `class` SET";
$cond = "WHERE `class_id` = '$R[class_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `class` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`class_title` = '$R[class_title]',
`class_description` = '$R[class_description]'".
$cond;
Page - 125
$rs = mysql_query($SQL) or die(mysql_error());
header("Location:../class-report.php?msg=$msg");
}
#########Function for delete class##########3 function delete_class()
{
/////////Delete the record//////////
$SQL="DELETE FROM class WHERE class_id = $_REQUEST[class_id]";
mysql_query($SQL) or die(mysql_error());
header("Location:../class-report.php?msg=Deleted Successfully.");
exit;
###Code for save event#####
function save_event() {
$R=$_REQUEST;
if($R[event_id]) {
$statement = "UPDATE `event` SET";
$cond = "WHERE `event_id` = '$R[event_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `event` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`event_title` = '$R[event_title]',
`event_class_id` = '$R[event_class_id]',
Page - 127
`event_teacher_id` = '".$_SESSION['user_details']
['user_id']."',
`event_date_start` = '$R[event_date_start]',
`event_date_end` = '$R[event_date_end]',
`event_description` = '$R[event_description]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
header("Location:../event-report.php?msg=$msg");
}
#########Function for delete event##########3 function delete_event()
{
/////////Delete the record//////////
$SQL="DELETE FROM event WHERE event_id = $_REQUEST[event_id]";
mysql_query($SQL) or die(mysql_error());
header("Location:../event-report.php?msg=Deleted Successfully.");
exit;
###Code for save files#####
function save_files() {
$R=$_REQUEST;
/////////////////////////////////////
$file_name = $_FILES[files_filename][name];
$location = $_FILES[files_filename][tmp_name];
if($file_name!="")
$file_name = $R[avail_file];
Page - 129
} //die;
if($R[files_id]) {
$statement = "UPDATE `files` SET";
$cond = "WHERE `files_id` = '$R[files_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `files` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`files_title` = '$R[files_title]',
`files_class_id` = '$R[files_class_id]',
`files_teacher_id` = '".$_SESSION['user_details']
['user_id']."',
`files_description` = '$R[files_description]',
`files_filename` = '$file_name'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
header("Location:../files-report.php?msg=$msg");
}
#########Function for delete files##########3 function delete_files()
Page - 130
{
$SQL="SELECT * FROM files WHERE files_id = $_REQUEST[files_id]";
$rs=mysql_query($SQL);
$data=mysql_fetch_assoc($rs);
/////////Delete the record//////////
$SQL="DELETE FROM files WHERE files_id = $_REQUEST[files_id]";
mysql_query($SQL) or die(mysql_error());
//////////Delete the file///////////
if($data[files_filename])
##############Function for reporting ##################3 function get_report()
{
$fname = 'myCSV.csv';
$fp = fopen($fname,'w');
$column_name =
'"ID","files_name","files_add1","files_add2","files_state","files_email","files_city","file s_mobile","files_gender","files_dob","files_nl_id","files_filename"'."\n\r";
fwrite($fp,$column_name);
$SQL="SELECT * FROM files,city WHERE files_city = city_id";
$rs=mysql_query($SQL);
Page - 131
while($data=mysql_fetch_assoc($rs))
header("Content-Disposition: inline; filename=".$fname);
readfile($fname);
if($_REQUEST[act] == "change_password")
Page - 132
{
change_password();
}
if($_REQUEST[act] == "check_student_login") {
check_student_login();
}
####Function check user#######
function check_login() {
$user_user=$_REQUEST[user_user];
$user_password=$_REQUEST[user_password];
$SQL="SELECT * FROM user WHERE user_username = '$user_user' AND user_password = '$user_password' AND user_level_id = 2";
$rs = mysql_query($SQL) or die(mysql_error());
if(mysql_num_rows($rs)) {
$_SESSION[login]=1;
$_SESSION['user_details'] = mysql_fetch_assoc($rs);
header("Location:../dashboard.php");
} else {
header("Location:../login.php?act=check_login&msg=Invalid User and Password.");
}
Page - 133
}
####Function check user#######
function check_student_login() {
$user_user=$_REQUEST[user_user];
$user_password=$_REQUEST[user_password];
$SQL="SELECT * FROM student WHERE student_username = '$user_user' AND student_password = '$user_password'";
$rs = mysql_query($SQL) or die(mysql_error());
if(mysql_num_rows($rs)) {
$_SESSION[login]=1;
$_SESSION['user_details'] = mysql_fetch_assoc($rs);
$_SESSION['user_details']['user_level_id'] = 3;
$_SESSION['user_details']['user_id'] = $_SESSION['user_details'] User and Password.");
} }
####Function logout####
function logout()
Page - 134
{
if($_SESSION['user_details']['user_level_id'] == 3) {
$act= "check_student_login";
} else {
$act= "check_login";
}
$_SESSION[login]=0;
$_SESSION['user_details'] = 0;
header("Location:../login.php?act=$act&msg=Logout Successfullly.");
}
#####Function for changing the password ####
function change_password() {
$R = $_REQUEST;
if($R['user_confirm_password'] != $R['user_new_password']) {
header("Location:../change-password.php?msg=Your new passsword and confirm password does not match!!!");
exit;
}
$SQL = "UPDATE `user` SET user_password = '$R[user_new_password]' WHERE `user_id` = ".$_SESSION['user_details']['user_id'];
$rs = mysql_query($SQL) or die(mysql_error());
header("Location:../change-password.php?msg=Your Password Changed Successfully !!!");
Coding for Message.php
###Code for save message#####
Page - 136
function save_message() {
$R=$_REQUEST;
if($R[message_id]) {
$statement = "UPDATE `message` SET";
$cond = "WHERE `message_id` = '$R[message_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `message` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`message_receiver_id` = '$R[message_receiver_id]',
`message_sender_id` = '".$_SESSION['user_details']
['user_id']."',
`message_sender_type` = '".$_SESSION['user_details']
['user_level_id']."',
`message_subject` = '$R[message_subject]',
`message_type` = '$R[message_type]',
`message_content` = '$R[message_content]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
$msg = "Message sent successfully.";
Page - 137
header("Location:../send_message.php?msg=$msg");
}
#########Function for delete message##########3 function delete_message()
{
/////////Delete the record//////////
$SQL="DELETE FROM message WHERE message_id =
$_REQUEST[message_id]";
mysql_query($SQL) or die(mysql_error());
header("Location:../message-report.php?msg=Deleted Successfully.");
}
#########Function for get message##########3 function getData()
{
/////////Delete the record//////////
$SQL = "SELECT * FROM message WHERE message_id =
$_REQUEST[message_id]";
$rs = mysql_query($SQL) or die(mysql_error());
$data = mysql_fetch_assoc($rs);
$data['message_content'] = nl2br($data['message_content']);
echo json_encode($data);
include_once("../admin/includes/db_connect.php");
###Code for save quiz#####
function save_quiz() {
$R=$_REQUEST;
Page - 139
if($R[quiz_id]) {
$statement = "UPDATE `quiz` SET";
$cond = "WHERE `quiz_id` = '$R[quiz_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `quiz` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`quiz_title` = '$R[quiz_title]',
`quiz_class_id` = '$R[quiz_class_id]',
`quiz_teacher_id` = '".$_SESSION['user_details']
['user_id']."',
`quiz_description` = '$R[quiz_description]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
header("Location:../quiz-report.php?msg=$msg");
}
#########Function for delete quiz##########3 function delete_quiz()
{
/////////Delete the record//////////
$SQL="DELETE FROM quiz WHERE quiz_id = $_REQUEST[quiz_id]";
Page - 140
mysql_query($SQL) or die(mysql_error());
header("Location:../quiz-report.php?msg=Deleted Successfully.");
}
#########Function for delete quiz##########3 function save_quiz_ans()
{
$quiz_correct_answer = $_SESSION['quiz_answer'];
$total_question = count($_SESSION['quiz']);
$quiz_id = $_SESSION['quiz'][1]['qq_quiz_id'];
$student_id = $_SESSION['user_details']['student_id'];
$SQL = "INSERT INTO quiz_result SET qr_quiz_id = '$quiz_id',
qr_student_id = '$student_id',
qr_total_question = '$total_question', qr_answer = '$quiz_correct_answer' ";
mysql_query($SQL) or die(mysql_error());
header("Location:../student-quiz-report.php?msg=Exam was successfully completed.");
include_once("../admin/includes/functions.php");
###Code for save quiz_question#####
function save_quiz_question() {
$R=$_REQUEST;
if($R[qq_id]) {
$statement = "UPDATE `quiz_question` SET";
$cond = "WHERE `qq_id` = '$R[qq_id]'";
$msg = "Data Updated Successfully.";
}
Page - 142
else {
$statement = "INSERT INTO `quiz_question` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`qq_quiz_id` = '$R[qq_quiz_id]',
`qq_question` = '$R[qq_question]',
`qq_option1` = '$R[qq_option1]',
`qq_option2` = '$R[qq_option2]',
`qq_option3` = '$R[qq_option3]',
`qq_option4` = '$R[qq_option4]',
`qq_correct` = '$R[qq_correct]',
`qq_description` = '$R[qq_description]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
header("Location:../quiz-question-report.php?
quiz_id=$R[qq_quiz_id]&msg=$msg");
}
#########Function for delete quiz_question##########3 function delete_quiz_question()
{
/////////Delete the record//////////
$SQL="DELETE FROM quiz_question WHERE qq_id = $_REQUEST[qq_id]";
mysql_query($SQL) or die(mysql_error());
Page - 143
header("Location:../quiz-question-report.php?msg=Deleted Successfully.");
###Code for save student#####
function save_student() {
Page - 144
$R=$_REQUEST;
$query = http_build_query($R);
///Checking Username Exits or not ////
$SQL="SELECT * FROM student WHERE student_username = '$_REQUEST[student_username]'";
$rs=mysql_query($SQL);
$data=mysql_fetch_assoc($rs);
if($data['student_username'] && $R['student_id'] == "") {
header("Location:../student.php?".$query."&msg=Username Already Exits. Kindly choose another....");
return;
}
/////////////////////////////////////
$image_name = $_FILES[student_image][name];
$location = $_FILES[student_image][tmp_name];
if($image_name!="")
$image_name = $R[avail_image];
} //die;
if($R[student_id]) {
Page - 145
$statement = "UPDATE `student` SET";
$cond = "WHERE `student_id` = '$R[student_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `student` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`student_course_id` = '$R[student_course_id]',
`student_rollno` = '$R[student_rollno]',
`student_name` = '$R[student_name]',
`student_username` = '$R[student_username]',
`student_password` = '$R[student_password]',
`student_father_name` = '$R[student_father_name]',
`student_dob` = '$R[student_dob]',
`student_mobile` = '$R[student_mobile]',
`student_photo` = '$image_name',
`student_details` = '$R[student_details]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
if(!$_SESSION['login']) {
Page - 146
header("Location:../login.php??
act=check_student_login&msg=You are registered successfully. Login with your credential !!!");
exit;
}
header("Location:../student.php?msg=Your account updated successfully !!!");
}
#########Function for delete student##########3 function delete_student()
{
$SQL="SELECT * FROM student WHERE student_id =
$_REQUEST[student_id]";
$rs=mysql_query($SQL);
$data=mysql_fetch_assoc($rs);
/////////Delete the record//////////
$SQL="DELETE FROM student WHERE student_id = $_REQUEST[student_id]";
mysql_query($SQL) or die(mysql_error());
//////////Delete the image///////////
if($data[student_image])
##############Function for reporting ##################3
Page - 147
function get_report() {
$fname = 'myCSV.csv';
$fp = fopen($fname,'w');
$column_name =
'"ID","student_name","student_add1","student_add2","student_state","student_emai l","student_city","student_mobile","student_gender","student_dob","student_nl_id","
student_image"'."\n\r";
fwrite($fp,$column_name);
$SQL="SELECT * FROM student,city WHERE student_city = city_id";
$rs=mysql_query($SQL);
header("Content-Disposition: inline; filename=".$fname);
readfile($fname);
include_once("../admin/includes/functions.php");
###Code for save user#####
function save_user() {
$R=$_REQUEST;
$query = http_build_query($R);
///Checking Username Exits or not ////
$SQL="SELECT * FROM user WHERE user_username = '$_REQUEST[user_username]'";
$rs=mysql_query($SQL);
$data=mysql_fetch_assoc($rs);
if($data['user_username'] && $R['user_id'] == "") {
Page - 149
header("Location:../user.php?".$query."&msg=Username Already Exits. Kindly choose another....");
return;
}
/////////////////////////////////////
$image_name = $_FILES[user_image][name];
$location = $_FILES[user_image][tmp_name];
if($image_name!="")
$image_name = $R[avail_image];
} //die;
if($R[user_id]) {
$statement = "UPDATE `user` SET";
$cond = "WHERE `user_id` = '$R[user_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `user` SET";
$cond = "";
Page - 150
$msg="Data saved successfully.";
}
$SQL= $statement."
`user_level_id` = '$R[user_level_id]',
`user_username` = '$R[user_username]',
`user_password` = '$R[user_password]',
`user_name` = '$R[user_name]',
`user_add1` = '$R[user_add1]',
`user_add2` = '$R[user_add2]',
`user_city` = '$R[user_city]',
`user_state` = '$R[user_state]',
`user_country` = '$R[user_country]',
`user_email` = '$R[user_email]',
`user_mobile` = '$R[user_mobile]',
`user_gender` = '$R[user_gender]',
`user_dob` = '$R[user_dob]',
`user_image` = '$image_name'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
if(!$_SESSION['login']) {
header("Location:../login.php?act=check_login&msg=You are registered successfully. Login with your credential !!!");
exit;
}
header("Location:../user.php?msg=Your account updated successfully !!!");
Page - 151
}
#########Function for delete user##########3 function delete_user()
{
$SQL="SELECT * FROM user WHERE user_id = $_REQUEST[user_id]";
$rs=mysql_query($SQL);
$data=mysql_fetch_assoc($rs);
/////////Delete the record//////////
$SQL="DELETE FROM user WHERE user_id = $_REQUEST[user_id]";
mysql_query($SQL) or die(mysql_error());
//////////Delete the image///////////
if($data[user_image])
##############Function for reporting ##################3 function get_report()
{
$fname = 'myCSV.csv';
$fp = fopen($fname,'w');
$column_name =
'"ID","user_name","user_add1","user_add2","user_state","user_email","user_city","u ser_mobile","user_gender","user_dob","user_nl_id","user_image"'."\n\r";
Page - 152
fwrite($fp,$column_name);
$SQL="SELECT * FROM user,city WHERE user_city = city_id";
$rs=mysql_query($SQL);
header("Content-Disposition: inline; filename=".$fname);
readfile($fname);
{
delete_department();
exit;
}
###Code for save department#####
function save_department() {
$R=$_REQUEST;
if($R[department_id]) {
$statement = "UPDATE `department` SET";
$cond = "WHERE `department_id` = '$R[department_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `department` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`department_title` = '$R[department_title]',
`department_code` = '$R[department_code]',
`department_description` = '$R[department_description]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
Page - 154
header("Location:../department-report.php?msg=$msg");
}
#########Function for delete department##########3 function delete_department()
{
/////////Delete the record//////////
$SQL="DELETE FROM department WHERE department_id =
$_REQUEST[department_id]";
mysql_query($SQL) or die(mysql_error());
header("Location:../department-report.php?msg=Deleted Successfully.");
}
###Code for save school_year#####
function save_school_year() {
$R=$_REQUEST;
if($R[syear_id]) {
$statement = "UPDATE `school_year` SET";
$cond = "WHERE `syear_id` = '$R[syear_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `school_year` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`syear_title` = '$R[syear_title]',
`syear_description` = '$R[syear_description]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
header("Location:../school_year-report.php?msg=$msg");
}
#########Function for delete school_year##########3 function delete_school_year()
Page - 156
{
/////////Delete the record//////////
$SQL="DELETE FROM school_year WHERE syear_id = $_REQUEST[syear_id]";
mysql_query($SQL) or die(mysql_error());
header("Location:../school_year-report.php?msg=Deleted Successfully.");
###Code for save subject#####
function save_subject() {
Page - 157
$R=$_REQUEST;
if($R[subject_id]) {
$statement = "UPDATE `subject` SET";
$cond = "WHERE `subject_id` = '$R[subject_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `subject` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`subject_title` = '$R[subject_title]',
`subject_class_id` = '$R[subject_class_id]',
`subject_code` = '$R[subject_code]',
`subject_description` = '$R[subject_description]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
header("Location:../subject-report.php?msg=$msg");
}
#########Function for delete subject##########3 function delete_subject()
{
/////////Delete the record//////////
Page - 158
$SQL="DELETE FROM subject WHERE subject_id = $_REQUEST[subject_id]";
mysql_query($SQL) or die(mysql_error());
header("Location:../subject-report.php?msg=Deleted Successfully.");
###Code for save teacher_class#####
function save_teacher_class() {
$R=$_REQUEST;
if($R[tc_id])
Page - 159
{
$statement = "UPDATE `teacher_class` SET";
$cond = "WHERE `tc_id` = '$R[tc_id]'";
$msg = "Data Updated Successfully.";
} else {
$statement = "INSERT INTO `teacher_class` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`tc_user_id` = '$R[tc_user_id]',
`tc_class_id` = '$R[tc_class_id]',
`tc_description` = '$R[tc_description]'".
$cond;
$rs = mysql_query($SQL) or die(mysql_error());
header("Location:../teacher-class-report.php?msg=$msg");
}
#########Function for delete teacher_class##########3 function delete_teacher_class()
{
/////////Delete the record//////////
$SQL="DELETE FROM teacher_class WHERE tc_id = $_REQUEST[tc_id]";
mysql_query($SQL) or die(mysql_error());
Page - 160
header("Location:../teacher-class-report.php?msg=Deleted Successfully.");
$SERVER_PATH = "http://127.0.0.1:81/elearning_management_system/admin/";
##Function for generating the dynamic options #######
function get_new_optionlist($table,$id_col,$value_col,$selected=0, $cond = 1) {
$SQL="SELECT * FROM $table WHERE $cond ORDER BY $value_col";
$rs=mysql_query($SQL);
$option_list="<option value=''>Please Select</option>";
while($data=mysql_fetch_assoc($rs))
return $option_list;
}
##Function for generating the dynamic options #######
function get_checkbox($name,$table,$id_col,$value_col,$selected=0) {
$selected_array=explode(",",$selected);
$SQL="SELECT * FROM $table ORDER BY $value_col";
$rs=mysql_query($SQL);
$option_list.="<input type='checkbox' value='$data[$id_col]' name='".$name."[]' id='$name' checked>$data[$value_col]<br>";
} else {
$option_list.="<input type='checkbox' value='$data[$id_col]' name='".$name."[]' id='$name'>$data[$value_col]<br>";
Conclusion of the Project E-learning Management System:
Our project is only a humble venture to satisfy the needs to manage their project work. Several user friendly coding have also adopted. This package shall prove to be a powerful package in satisfying all the requirements of the school. The objective of software planning is to provide a frame work that enables the manger to make reasonable estimates made within a limited time frame at the beginning of the software project and should be updated regularly as the project progresses.
At the end it is concluded that we have made effort on following points…
A description of the background and context of the project and its relation to work already done in the area.
Made statement of the aims and objectives of the project.
The description of Purpose, Scope, and applicability.
We define the problem on which we are working in the project.
We describe the requirement Specifications of the system and the actions that can be done on these things.
We understand the problem domain and produce a model of the system, which describes operations that can be performed on the system.
We included features and operations in detail, including screen layouts.
We designed user interface and security issues related to system.
Finally the system is implemented and tested according to test cases.
Page - 163
Future Scope of the Project:
In a nutshell, it can be summarized that the future scope of the project circles around maintaining information regarding:
We can add printer in future.
We can give more advance software for E-learning Management System including more facilities
We will host the platform on online servers to make it accessible worldwide
Integrate multiple load balancers to distribute the loads of the system
Create the master and slave database structure to reduce the overload of the database queries
Implement the backup mechanism for taking backup of codebase and database on regular basis on different servers
The above mentioned points are the enhancements which can be done to increase the applicability and usage of this project. Here we can maintain the records of Assignment and Student. Also, as it can be seen that now-a-days the players are versatile, i.e. so there is a scope for introducing a method to maintain the E-learning Management System. Enhancements can be done to maintain all the Assignment, Student, TEACHER, QUIZ, QUESTION.
We have left all the options open so that if there is any other future requirement in the system by the user for the enhancement of the system then it is possible to implement them.In the last we would like to thanks all the persons involved in the development of the system directly or indirectly. We hope that the project will serve its purpose for which it is develop there by underlining success of process.
Page - 164
Limitation of Project on E-learning Management System
Although I have put my best efforts to make the software flexible, easy to operate but limitations cannot be ruled out even by me. Though the software presents a broad range of options to its users some intricate options could not be covered into it; partly because of logistic and partly due to lack of sophistication. Paucity of time was also major constraint, thus it was not possible to make the software foolproof and dynamic.
Lack of time also compelled me to ignore some part such as storing old result of the candidate etc.
Considerable efforts have made the software easy to operate even for the people not related to the field of computers but it is acknowledged that a layman may find it a bit problematic at the first instance. The user is provided help at each step for his convenience in working with the software.
List of limitations which is available in the E-learning Management System:
Excel export has not been developed for Assignment, Student due to some criticality.
The transactions are executed in off-line mode, hence on-line data for TEACHER, QUIZ capture and modification is not possible.
Off-line reports of Assignment, QUESTION, TEACHER cannot be generated due to batch mode execution.
Page - 165
References and Bibliography:
Google for problem solving
http://www.javaworld.com/javaworld/jw-01-1998/jw-01-Credentialreview.html
Database Programming with JDBC and Java by O'Reilly
Head First Java 2nd Edition
http://www.jdbc-tutorial.com/
Java and Software Design Concepts by Apress
https://www.tutorialspoint.com/java/
http://www.javatpoint.com/java-tutorial
https://docs.oracle.com/javase/tutorial/
http://www.wampserver.com/en/
http://www.JSP.net/
http://www.tutorialspoint.com/mysql/
httpd.apache.org/docs/2.0/misc/tutorials.html
Page - 166