<?php
session_start();
class connection{
//constrction for connection
function connection(){
}
/* function __destruct() {
mysql_close($this->con)or die("not close....");
} */
//insert form firstitme registration
function insert_user_master($first_name,$last_name,$email,$password,$sex,$country,$mobile){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$sel_query="select * from usermaster where Username='$email'";
$r1=mysql_query($sel_query)or die("sel_query query not fire...".__LINE__);
$rows = mysql_num_rows($r1);
if ($rows == 1 ) {
header("location:index.php?log=a_user&id=$email");//if already user registerd then.
}
else{
$user_registere_time=date("Y-m-d H:i:s");
$query="insert into usermaster (Userid,Username,Mobile,Firstname,Lastname,Country,Sex,password,Usertype,Userlogintype,Registrationtype,account_status,registrationDate) values ('','$email','$mobile','$first_name','$last_name','$country','$sex','$password','student','self','self','1','$user_registere_time')";
mysql_query($query)or die("query not fire...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
$_SESSION['login_user']=$email;
header("location:http://englishsikho.nhnfoods.com/mail/2/examples/newuser_mail.php?emailid=$email&first_name=$first_name&last_name=$last_name");
//header('location:index.php?log=log');
}
}
//create new user by admin
function insert_user_master_admin($first_name,$last_name,$email,$password,$sex,$country,$usertype){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="insert into usermaster (Userid,Username,Firstname,Lastname,Country,Sex,password,Usertype,Userlogintype,Registrationtype,account_status) values ('','$email','$first_name','$last_name','$country','$sex','$password','$usertype','self','self','1')";
mysql_query($query)or die("query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header('location:success-registeration.php');
}
//admin and student and techer login here.
Function login_user($email,$password){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from usermaster where Username='$email' AND password='$password'";
$r=mysql_query($query)or die("login user query not fire...");
$rows = mysql_num_rows($r);
if ($rows == 1 ) {
while($row=mysql_fetch_array($r))
{
if($row['Usertype']=='admin')
{
$_SESSION['login_user']=$email;
$_SESSION['Usertype']='admin';
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Admin/all-user.php");
}
else if($row['Usertype']=='student') {
$_SESSION['login_user']=$email;
$_SESSION['Usertype']='student';
mysql_close($con)or die("LINE No:".__LINE__);
if($row['atempted_exam']=='1'){
header("location:dashboard.php");
}else{
header("location:Assessment.php");
}
}else if($row['Usertype']=='techer') {
$_SESSION['login_user']=$email;
$_SESSION['Usertype']='techer';
mysql_close($con)or die("LINE No:".__LINE__);
header("location:techer/index.php");
}
else{
mysql_close($con)or die("LINE No:".__LINE__);
header("location:index.php?log=nouser");
}
}
}else{
mysql_close($con)or die("LINE No:".__LINE__);
header("location:index.php?log=wrong");
}
}
//atempted exam user exam........
/* function atempled_exams($email){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
echo $query="select atempted_exam from usermaster where Username='$email'";
$r=mysql_query($query)or die("error".__LINE__);
$atempted=mysql_fetch_array($r);
if($atempted['atempted_exam']==1){
mysql_close($con)or die("LINE No:".__LINE__);
header('location:http://englishsikho.nhnfoods.com/dashboard.php');
echo "1 attempted.....";
}
} */
//select usermaster
function Displey_usermaster(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from usermaster";
$r=mysql_query($query)or die("login user query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit user by admin
function edit_User_master($uid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from usermaster where Userid=$uid";
$r=mysql_query($query)or die("edit user query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update usermaster
function user_master_update($uid,$username,$firstname,$lastname,$dob,$sex,$address,$country,$state,$City,$Pincode,$phone,$Mobile,$Fax,$Website,$skypeid,$facebook,$Twitter){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query = "UPDATE usermaster SET
Username='$username',
Firstname='$firstname',
Lastname='$lastname',
Birthdate='$dob',
Sex='$sex',
Address='$address',
Country='$country',
State='$state',
City='$City',
Pincode='$Pincode',
Phone='$phone',
Mobile='$Mobile',
Fax='$Fax',
Website='$Website',
Skypeid='$skypeid',
Facebookid='$facebook',
Twitterid='$Twitter'
WHERE Userid=$uid";
mysql_query($query)or die('update master query not working');
mysql_close($con)or die("LINE No:".__LINE__);
}
//active deactive user by admin
function user_active_deactive($uid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_sel="select account_status from usermaster where Userid=$uid";
$status_result=mysql_query($query_sel);
$row = mysql_fetch_assoc( $status_result );
if($row['account_status']==1)
{
$query = "UPDATE usermaster SET account_status='0' WHERE Userid=$uid and account_status=1";
}else
{
$query = "UPDATE usermaster SET account_status='1' WHERE Userid=$uid and account_status=0";
}
mysql_query($query)or die('active deactive query not worked');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-user.php");
}
//add question answer
function add_que_ans($lang,$Question,$question_dis,$anstype,$option1,$option2,$option3,$option4,$option5,$option6,$option1_dis,$option2_dis,$option3_dis,$option4_dis,$option5_dis,$option6_dis,$rightanswer,$rightcomment,$wrongcomment){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="insert into question (Questionid,Questiontitle,Questiondescription,Language) values ('','$Question','$question_dis','$lang')";
mysql_query($query)or die("1 query not fire...");
$query2="SELECT LAST_INSERT_ID()";
$result=mysql_query($query2)or die("2 query not fire...");
$id = mysql_fetch_assoc($result);
$queid=$id['LAST_INSERT_ID()'];
$options=array("$option1","$option2","$option3","$option4","$option5","$option6");
$options= implode('|', $options);
$answer_option_dis=array("$option1_dis","$option2_dis","$option3_dis","$option4_dis","$option5_dis","$option6_dis");
$answer_option_dis= implode('|', $answer_option_dis);
$query3='insert into answer (Answerid,Questionid,Answeroptions,Answertype,RightAnswer,Rightcomment,Wrongcomment,Language,answer_option_dis) values ("","'.$queid.'","'.$options.'","'.$anstype.'","'.$rightanswer.'","'.$rightcomment.'","'.$wrongcomment.'","'.$lang.'","'.$answer_option_dis.'")';
mysql_query($query3)or die("3 query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-questin.php");
}
//display All Questions
function display_all_question(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select question.Questionid,question.Questiontitle,answer.Answeroptions,answer.Answertype,answer.RightAnswer,question.Language from question inner join answer ON question.Questionid=answer.Questionid";
$r=mysql_query($query)or die("login user query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit questions.....
function Edit_question($questionid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select question.Questiontitle,question.Questiondescription,question.Language,answer.Answeroptions,answer.Answertype,answer.RightAnswer,answer.Rightcomment,answer.Wrongcomment ,answer.answer_option_dis from question inner join answer ON $questionid=answer.Questionid where question.Questionid=$questionid";
$r=mysql_query($query)or die("edit question query not fire".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update questions answer
function update_que_ans($lang,$Question,$question_dis,$anstype,$option1,$option2,$option3,$option4,$option5,$option6,$option1_dis,$option2_dis,$option3_dis,$option4_dis,$option5_dis,$option6_dis,$rightanswer,$rightcomment,$wrongcomment,$queid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query = "UPDATE question SET
Questiontitle='$Question',
Questiondescription='$question_dis',
Language='$lang'
WHERE Questionid=$queid";
mysql_query($query)or die('update question query not working');
$options=array("$option1","$option2","$option3","$option4","$option5","$option6");
$options= implode('|', $options);
$answer_option_dis=array("$option1_dis","$option2_dis","$option3_dis","$option4_dis","$option5_dis","$option6_dis");
$answer_option_dis= implode('|', $answer_option_dis);
$query1 = 'UPDATE answer SET
Answeroptions="'.$options.'",
answer_option_dis="'.mysql_real_escape_string($answer_option_dis).'",
Answertype="'.$anstype.'",
RightAnswer="'.$rightanswer.'",
Rightcomment="'.mysql_real_escape_string($rightcomment).'",
Wrongcomment="'.mysql_real_escape_string($wrongcomment).'",
Language="'.$lang.'"
WHERE Questionid="'.$queid.'"';
mysql_query($query1)or die('update answer query not working'.__LINE__);
//mysql_query($query1);
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-questin.php");
}
//Delete Question
function Delete_question($queid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="DELETE FROM question WHERE Questionid = $queid";
mysql_query($query)or die('delete question query not working');
$query1="DELETE FROM answer WHERE Questionid = $queid";
mysql_query($query1)or die('delete answer query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-questin.php");
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=EXAM=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
//create new Exam
function Creat_exam_process($lang,$Examtitle,$Examshorttitle,$Examdescription,$Examduration,$Totalmark,$Passingmark,$Passcomment,$Failcomment){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into exam (Examid,Examtitle,Examshorttitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language) values ("","'.$Examtitle.'","'.$Examshorttitle.'","'.$Examdescription.'","'.$Examduration.'","'.$Totalmark.'","'.$Passingmark.'","'.$Passcomment.'","'.$Failcomment.'","'.$lang.'")';
mysql_query($query)or die("create exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-exam.php");
}
//display all exam
function display_all_exam(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select Examid,Examtitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language from exam";
$r=mysql_query($query)or die("Display exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
// Edit Exam.
function edit_exam($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select Examid,Examtitle,Examshorttitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language from exam where Examid=$examid";
$r=mysql_query($query)or die("edit exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
// Update Exam Process
function Update_exam_process($lang,$Examtitle,$Examshorttitle,$Examdescription,$Examduration,$Totalmark,$Passingmark,$Passcomment,$Failcomment,$Examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
echo $query1 = 'UPDATE exam SET
Examtitle="'.$Examtitle.'",
Examshorttitle="'.$Examshorttitle.'",
Examdescription="'.$Examdescription.'",
Examduration="'.$Examduration.'",
Totalmark="'.$Totalmark.'",
Passingmark="'.$Passingmark.'",
Passcomment="'.mysql_real_escape_string($Passcomment).'",
Failcomment="'.mysql_real_escape_string($Failcomment).'",
Language="'.$lang.'"
WHERE Examid="'.$Examid.'"';
mysql_query($query1)or die('update exam query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-exam.php");
}
//delete exam
function Delete_exam($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="DELETE FROM exam WHERE Examid = $examid";
mysql_query($query)or die('delete exam query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-exam.php");
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=Add Question in exam=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
//question display in manage exam
function display_manage_exam_question($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
//$query="SELECT TT.Questionid,TT.Questiontitle,answer.Answeroptions,answer.Answertype,answer.RightAnswer,tt.Language, (select examquestion.Examquestionid from examquestion where examquestion.Questionid = TT.Questionid and examquestion.Examid=$examid) as chkbox from question As TT inner join answer ON tt.Questionid=answer.Questionid";
$get_exam_language="SELECT Language from exam where Examid=$examid";
$result_exam_language=mysql_query($get_exam_language);
$result_exam_language=mysql_fetch_array($result_exam_language);//get exam language.
$query="SELECT TT.Questionid,TT.Questiontitle,answer.Answeroptions,answer.Answertype,answer.RightAnswer,tt.Language, (select examquestion.Examquestionid from examquestion where examquestion.Questionid = TT.Questionid and examquestion.Examid=$examid and tt.Language='$result_exam_language[0]') as chkbox from question As TT inner join answer ON tt.Questionid=answer.Questionid WHERE tt.Language='$result_exam_language[0]'";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//delete EXAM Question
function delete_exam_question($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_delete="DELETE FROM examquestion WHERE Examid = $examid";
mysql_query($query_delete)or die('delete exam questions query not working');
mysql_close($con)or die("LINE No:".__LINE__);
}
//Add EXAM Question
function add_exam_questions_process($examid,$quesionids){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into examquestion (Examquestionid,Examid,Questionid) values ("","'.$examid.'","'.$quesionids.'")';
mysql_query($query)or die("create exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=Create cource=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
//add course category
function insert_category($category_name,$lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into course_category (categoryid,categoryname,Language) values ("","'.$category_name.'","'.$lang.'")';
mysql_query($query)or die ("cource category insert query not working");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Display-Caurse-category.php");
}
//display course category
function display_course_category(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select categoryid,categoryname,Language from course_category";
$r=mysql_query($query)or die("Display course category query not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit cource category
function edit_course_category($categoryid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from course_category where categoryid=$categoryid";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update category
function update_category($categoryid,$category_name,$lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="UPDATE course_category set
categoryname='$category_name',
Language='$lang'
WHERE categoryid=$categoryid";
mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Display-Caurse-category.php");
}
//Delete cource Category
function Delete_course_category($categoryid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="Delete from course_category where categoryid=$categoryid";
mysql_query($query)or die("Delete category query not working");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Display-Caurse-category.php");
}
///////////////
//create Course
function Creat_course_process($lang,$course_name,$coursedescription,$courseduration,$Feetype,$CourseType,$categoryname){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into course (Courseid,Cousename,Coursedescription,Courseduration,Feetype,Coursetype,Language,categoryname) values ("","'.$course_name.'","'.$coursedescription.'","'.$courseduration.'","'.$Feetype.'","'.$CourseType.'","'.$lang.'","'.$categoryname.'")';
mysql_query($query)or die("create cource query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Courses.php");
}
//Display course
function display_all_course(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='select Courseid,Cousename,Coursedescription,Courseduration,Feetype,Coursetype,Language,categoryname from course';
$r=mysql_query($query)or die("display course query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit cource
function edit_course($courseid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select Courseid,Cousename,Coursedescription,Courseduration,Feetype,Coursetype,Language,categoryname from course where Courseid=$courseid";
$r=mysql_query($query)or die("display course query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update cource
function Update_course_process($Courseid,$lang,$course_name,$coursedescription,$courseduration,$Feetype,$CourseType,$categoryname){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1 = 'UPDATE course SET
Cousename="'.$course_name.'",
Coursedescription="'.mysql_real_escape_string($coursedescription).'",
Courseduration="'.$courseduration.'",
Feetype="'.$Feetype.'",
Coursetype="'.$CourseType.'",
categoryname="'.$categoryname.'",
Language="'.$lang.'"
WHERE Courseid="'.$Courseid.'"';
mysql_query($query1)or die('update course query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Courses.php");
}
//delete cource
function Delete_course($courseid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_delete="DELETE FROM course WHERE Courseid = $courseid";
mysql_query($query_delete)or die('delete exam questions query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Courses.php");
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=add News=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
//add news
function add_news($lang,$newstitle,$Newsdescription){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$news_time=date("Y-m-d H:i:s");
$query='insert into news (Newsid,Title,Description,Language,Datetime) values ("","'.$newstitle.'","'.$Newsdescription.'","'.$lang.'","'.$news_time.'")';
mysql_query($query)or die("add news query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-news.php");
}
//display all news
function display_all_news(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from news ";
$r=mysql_query($query)or die("display news query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit news
function edit_news($newsid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from news where Newsid=$newsid";
$r=mysql_query($query)or die("edit news query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update news
function update_news($newsid,$datetime,$newstitle,$Newsdescription,$lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1 = 'UPDATE news SET
Newsid="'.$newsid.'",
Datetime="'.$datetime.'",
Title="'.$newstitle.'",
Description="'.$Newsdescription.'",
Language="'.$lang.'"
WHERE Newsid="'.$newsid.'"';
mysql_query($query1)or die('update News query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-news.php");
}
//delete news
function Delete_news($newsid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_delete="DELETE FROM news WHERE Newsid = $newsid";
mysql_query($query_delete)or die('delete news query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-news.php");
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=add Video=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
//add video
function add_video($lang,$videotitle,$videodescription,$embed){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$news_time=date("Y-m-d H:i:s");
$query='insert into video (videoid,title,description,embed,datetime,language) values ("","'.$videotitle.'","'.$videodescription.'","'.$embed.'","'.$news_time.'","'.$lang.'")';
mysql_query($query)or die("add video query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-video.php");
}
//display all videos
function display_all_videos(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from video ";
$r=mysql_query($query)or die("display video query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit video
function edit_video($videoid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from video where videoid=$videoid";
$r=mysql_query($query)or die("edit video query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update video
function update_video($videoid,$videotitle,$videodescription,$lang,$embed){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1 = 'UPDATE video SET
title="'.$videotitle.'",
embed="'.mysql_real_escape_string($embed).'",
description="'.mysql_real_escape_string($videodescription).'",
language="'.$lang.'"
WHERE videoid="'.$videoid.'" ';
mysql_query($query1)or die('update video query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-video.php");
}
//delete video
function Delete_video($videoid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_delete="DELETE FROM video WHERE videoid = $videoid";
mysql_query($query_delete)or die('delete news query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-video.php");
}
//display selected id videos
function display_selected_videos($videoid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from video where videoid=$videoid";
$r=mysql_query($query)or die("display video query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@#=User wise report=#@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//Get user as a student @for user wise exam report.
function user_as_a_student(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from usermaster where Usertype='student'";
$r=mysql_query($query)or die("login user query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//display axam list.
function get_users_exam_process($userid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select exam.Examid,exam.Examtitle,userexam.Userid,userexam.Examdate,userexam.Exammark,userexam.Examstatus FROM exam INNER JOIN userexam ON exam.Examid=userexam.Examid WHERE userexam.Userid=$userid";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//return user name
function get_user_name($userid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select Username from usermaster where Userid=$userid";
$r=mysql_query($query);
$row=mysql_fetch_array($r);
mysql_close($con)or die("LINE No:".__LINE__);
return $row[0];
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@#=Exam wise report=#@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
function Exam_given_by_students(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select exam.Examid,exam.Examtitle,exam.Language from exam inner join userexam ON exam.Examid=userexam.Examid GROUP BY exam.Examid";
$r=mysql_query($query)or die("exam wise repot query not fire...__LINE__");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//display student list.
function get_users_exam_process_by_exam($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="SELECT usermaster.Userid,usermaster.Firstname,usermaster.Lastname,usermaster.Username,usermaster.Mobile,userexam.Examstatus,userexam.Exammark FROM usermaster INNER JOIN userexam ON userexam.Userid=usermaster.Userid WHERE userexam.Examid=$examid";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@#=add_contact_details_process=#@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
function add_contact_details_process($contactemail,$ContactMobile,$ContactPhone,$ContactAddress,$ContactCompnyname,$ContactSlogan,$ContactFax,$lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into contect_us (Contect_id,EmailID,Mobile,Phone,Address,CompnyName,Slogan,Fax, Language) values ("","'.$contactemail.'","'.$ContactMobile.'","'.$ContactPhone.'","'.$ContactAddress.'","'.$ContactCompnyname.'","'.$ContactSlogan.'","'.$ContactFax.'","'.$lang.'")';
mysql_query($query)or die("Add contact details query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:show-contact-Details.php");
}
function show_contact_Details(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="Select Contect_id,EmailID,Mobile,Phone,Address,CompnyName,Slogan,Fax,Language From contect_us ";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit contact details
function Edit_contact_details($contactid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="Select Contect_id,EmailID,Mobile,Phone,Address,CompnyName,Slogan,Fax,Language From contect_us where Contect_id=$contactid ";
$r=mysql_query($query)or die("edit contact query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update contect details
function Update_contact_details_process($Contect_id,$contactemail,$ContactMobile,$ContactPhone,$ContactAddress,$ContactCompnyname,$ContactSlogan,$ContactFax,$lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1 = 'UPDATE contect_us SET
EmailID="'.$contactemail.'",
Mobile="'.$ContactMobile.'",
Phone="'.$ContactPhone.'",
Address="'.$ContactAddress.'",
CompnyName="'.$ContactCompnyname.'",
Slogan="'.$ContactSlogan.'",
Fax="'.$ContactFax.'",
Language="'.$lang.'"
WHERE Contect_id="'.$Contect_id.'"';
mysql_query($query1)or die('update contect query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:show-contact-Details.php");
}
//delet contact details
function Delete_contact_details($contactid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="Delete From contect_us where Contect_id=$contactid";
mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
header("Location:show-contact-Details.php");
}
//Contact details footer
function contact_detail_footer(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$lg=$_SESSION['language'];
$query="select * from contect_us where Language='$lg' ";
$r=mysql_query($query)or die ("contact detail footer not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
function newsletter_subscribe($email_newsletter){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$sel_query="select * from news_subscribe where EmailID='$email_newsletter'";
$r1=mysql_query($sel_query)or die("sel_query query not fire...");
$rows = mysql_num_rows($r1);
if ($rows == 1 ) {
}
else{
$query="Insert into news_subscribe (Id,EmailID) values ('','$email_newsletter')";
$r=mysql_query($query)or die ("subscribe query Not working...");
mysql_close($con)or die("LINE No:".__LINE__);
}
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=insert,update page content=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//insert content for developer.
function insert_content_of_page_process($lang,$page_name,$page_content_flag,$Content){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into pagecontent (Contentid,Pagename,contentflag,content,language) values ("","'.$page_name.'","'.$page_content_flag.'","'.$Content.'","'.$lang.'")';
$r=mysql_query($query)or die ("insert page content query Not working...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:insert_content_of_pages.php");
}
//display page wise contact
function display_pages_contents($page){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from pagecontent where Pagename='$page'";
$r=mysql_query($query)or die("page wise contant query not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit page contect
function edit_page_content($Content_id){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from pagecontent where Contentid=$Content_id";
$r=mysql_query($query)or die("edit page content query not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update page content
function update_content_of_page_process($Contentid,$lang,$page_name,$page_content_flag,$Content,$rdirect){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
// $query1 = 'UPDATE pagecontent SET
// Pagename="'.$page_name.'",
// contentflag="'.$page_content_flag.'",
// content="'.$Content.'",
// language="'.$lang.'"
// WHERE Contentid="'.$Contentid.'"';
$query1 = "UPDATE pagecontent SET
Pagename='$page_name',
contentflag='$page_content_flag',
content='$Content',
language='$lang'
WHERE Contentid=$Contentid";
mysql_query($query1)or die('update contect query not working L:490');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:$rdirect");
}
//general_enquire_notification_process
function general_enquire_notification_process(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select count(*) from general_enquire where reading_statues='unread'";
$r=mysql_query($query);
$result=mysql_fetch_array($r);
mysql_close($con)or die("LINE No:".__LINE__);
//print_r($result);
return $result[0];
}
//general_enquire_display
function general_enquire_display(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from general_enquire ORDER BY Enquire_ID DESC";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//messagestatus up date by admin
function messagestatus($msgid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_sel="select reading_statues from general_enquire where Enquire_ID=$msgid";
$status_result=mysql_query($query_sel);
$row = mysql_fetch_assoc($status_result);
print_r($row);
if($row['reading_statues']=='unread')
{
echo $query = "UPDATE general_enquire SET reading_statues='Read' WHERE Enquire_ID=$msgid and reading_statues='unread'";
}else
{
echo $query = "UPDATE general_enquire SET reading_statues='unread' WHERE Enquire_ID=$msgid and reading_statues='Read'";
}
mysql_query($query)or die('message status query not worked');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:inquery_inbox.php");
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//add smtp configuration
function smtp_configuration_setting_process($admin_emailid,$smtp_email,$smtp_host,$smtp_port,$smtp_password){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into smtp_setting (id,admin_emailid,smtp_email,smtp_host,smtp_port,smtp_password) values ("","'.$admin_emailid.'","'.$smtp_email.'","'.$smtp_host.'","'.$smtp_port.'","'.$smtp_password.'")';
$r=mysql_query($query)or die ("insert smtp_setting query Not working...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
}
//display smtp configuration
function display_smtp_configuration(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from smtp_setting";
$r=mysql_query($query)or die ("display smtp_setting query Not working...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit smtp configuration
function smtp_settion_edit_process($id){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from smtp_setting where id=".$id;
$r=mysql_query($query)or die ("edit smtp_setting query Not working...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update smtp configuration
function smtp_setting_update_process($id,$admin_emailid,$smtp_email,$smtp_host,$smtp_port,$smtp_password){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query = 'UPDATE smtp_setting SET
admin_emailid="'.$admin_emailid.'",
smtp_email="'.$smtp_email.'",
smtp_host="'.$smtp_host.'",
smtp_port="'.$smtp_port.'",
smtp_password="'.$smtp_password.'"
WHERE id="'.$id.'"';
$r=mysql_query($query)or die ("update smtp_setting query Not working...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
}
// @#@#@#@#@#@#@#@#@#@#@#@#@
//##@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@ @#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#//
//################################################################### Client Side Functions ##############################################################################// //##@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@ @#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#//
// @#@#@#@#@#@#@#@#@#@#@#@#@
/*
@ User site funtions write here.
@ some users funtions write here.
*/
function User_profile($userid,$usertype){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from usermaster where Username='$userid' and Usertype='$usertype'";
$r=mysql_query($query)or die("user profile query not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//display users exam
function users_exam_display(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
//$query="select Examid,Examtitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language from exam";
$current_username=$_SESSION['login_user'];
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
//old
//echo $query="select exam.Examid,exam.Examtitle,exam.Examdescription,exam.Examduration,exam.Totalmark,exam.Passingmark,exam.Language,(select userexam.Examid from userexam where userexam.Examid=exam.Examid and userexam.Userid='$userid') as view_result from exam";
$lg=$_SESSION['language'];
$query="select exam.Examid,exam.Examtitle,exam.Examdescription,exam.Examduration,exam.Totalmark,exam.Passingmark,exam.Language,(select userexam.Examid from userexam where userexam.Examid=exam.Examid and userexam.Userid='$userid') as view_result from exam where exam.Language='$lg'";
$r=mysql_query($query)or die("Display exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//display exam detail
function exam_details($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select Examid,Examtitle,Examshorttitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language from exam where Examid=$examid";
$r=mysql_query($query)or die("Display exam details query not fire...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//totle exam of question
function total_quetion_of_exam($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select count(*) from examquestion where Examid=$examid";
$r=mysql_query($query)or die("total exam quetion query not fire");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//Exam Start time
function exam_start_time(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
date_default_timezone_set("Asia/Calcutta");
$_SESSION['exam_start_time']=date("Y-m-d H:i:s");
mysql_close($con)or die("LINE No:".__LINE__);
}
//exam start.
function runnig_exam_quesion($examid,$question){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from examquestion where Examid=$examid order By `Questionid` LIMIT $question, 1 ";
$r=mysql_query($query) or die("runnig_exam_quesion query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r ;
}
//DISPLAY QUETION OF RUNNING EXAM
function runnig_exam_quesion_display($queid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select question.Questionid,question.Questiontitle,answer.Answeroptions,answer.Answertype,answer.RightAnswer,question.Language,question.Questiondescription from question inner join answer ON question.Questionid=answer.Questionid where question.Questionid=$queid";
$r=mysql_query($query)or die("login user query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//SUBMIT USERS ANSWER..
function submit_user_answer($priousequetionid,$user_ans,$examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from answer where Questionid=$priousequetionid"; //pques 165
$r=mysql_query($query)or die("answer submit query not fire1");
$row=mysql_fetch_array($r);
$answer_id=$row[0]; //143
$RightAnswer=$row[4]; //yes
$current_username=$_SESSION['login_user'];
//user's answer chacking here.
$RightAnswer2 = explode(",",$RightAnswer);
$user_ans=trim($user_ans);
if(in_array($user_ans,$RightAnswer2)){
$wrong_or_right="Right";
$comment=$row[5];
$answermark=1;
}else{
$wrong_or_right="wrong";
$comment=$row[6];
$answermark=0;
}
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1)or die("answer submit query not fire2");
$row1=mysql_fetch_array($r1);
$userid=$row1[0]; // 89
//$query2='Insert into useranswer (Useranswerid,Examid,Userid,Answerid,Useranswer,Wrongright,comment,Answermark,Quetinoid) values("","'.$examid.'","'.$userid.'","'.$answer_id.'","'.$user_ans.'","'.$wrong_or_right.'","'.$comment.'","'.$answermark.'","'.$priousequetionid.'")';
$query2='Insert into useranswer (Useranswerid,Examid,Userid,Answerid,Useranswer,Wrongright,comment,Answermark,Quetinoid) values ("","'.$examid.'","'.$userid.'","'.$answer_id.'","'.$user_ans.'","'.$wrong_or_right.'","'.mysql_real_escape_string($comment).'","'.$answermark.'","'.$priousequetionid.'")';
mysql_query($query2)or die("answer submit query not fire3");
mysql_close($con)or die("LINE No:".__LINE__);
}
//SUBMINT USER EXAM AND EXAM RESULT
function user_exam($examid,$current_username,$timeout){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
$query2="select Passingmark from exam where Examid=$examid";
$r2=mysql_query($query2);
$row2=mysql_fetch_array($r2);
$passing_mark=$row2[0];//current exams passing mark.
$query3="select count(*) from useranswer where Examid=$examid and Answermark='1' and Userid=$userid";
$right_ans_marks=mysql_query($query3)or die("right ans mark count query not fire");
$right_ans_marks = mysql_fetch_array($right_ans_marks);
$right_ans_marks=$right_ans_marks[0];//right ans by user
if($right_ans_marks< $passing_mark){
$exam_status="Fail";
$query4="select Failcomment from exam where Examid=$examid";
}else{
$exam_status="Pass";
$query4="select Passcomment from exam where Examid=$examid";
}
$exam_comment=mysql_query($query4);
$exam_comment=mysql_fetch_array($exam_comment);
$exam_comment=$exam_comment[0];//exam_comment
$exam_start_time=$_SESSION['exam_start_time'];//exam start time
date_default_timezone_set("Asia/Calcutta");
$exam_end_time=date("Y-m-d H:i:s");
$query5='Insert into userexam (Userexamid,Examid,Userid,Examstatus,Exammark,Comment,exam_start_time,exam_end_time,Timeout,Examdate) values ("","'.$examid.'","'.$userid.'","'.$exam_status.'","'.$right_ans_marks.'","'.$exam_comment.'","'.$exam_start_time.'","'.$exam_end_time.'","'.$timeout.'","'.$exam_start_time.'")';
mysql_query($query5);
mysql_close($con)or die("LINE No:".__LINE__);
}
function atempled_exams_by_user($current_username){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
//user attempted 1 exam then it will run...
$atempted_exam="update usermaster set
atempted_exam='1'
where Username='$current_username'";
mysql_query($atempted_exam)or die("atempted_exam Query not fire".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
}
//view result
function view_result($examid,$current_username){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
$query="select exam.Examtitle,exam.Examdescription,exam.Totalmark,userexam.Examdate,userexam.Examstatus, userexam.Exammark,userexam.comment,userexam.Timeout from exam inner join userexam ON userexam.Examid = exam.Examid AND userexam.Userid=$userid and userexam.Examid=$examid";
$r=mysql_query($query)or die("view result quer1 not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//view quetion in result page
function view_quetion_and_result($examid,$current_username){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
$query="select useranswer.Quetinoid,useranswer.Useranswer,useranswer.Wrongright,useranswer.comment,question.Questiontitle FROM useranswer INNER JOIN
question ON question.Questionid = useranswer.Quetinoid where useranswer.Userid=$userid and useranswer.Examid=$examid";
$r=mysql_query($query)or die("view quetion and result query not working.");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=Home page content highlight_boxs =@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
function select_content_of_page($language,$content_flag,$page_name){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from pagecontent where Pagename='$page_name' and contentflag='$content_flag' and language='$language'";
$r=mysql_query($query)or die("select content for page query not working L:728");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@= caurse by category =@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//Display All course by language
function display_all_course_F($lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='select Courseid,Cousename,Coursedescription,Courseduration,Feetype,Coursetype,Language,categoryname from course where Language="'.$lang.'"';
$r=mysql_query($query)or die("display course query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//display course category by lang
function display_course_category_f($lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select categoryid,categoryname,Language from course_category where Language='$lang'";
$r=mysql_query($query)or die("Display course category query not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
function get_course_by_category($categoryname){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$lg=$_SESSION['language'];
//and Language='$lg'
$query="select * from course where categoryname='$categoryname'";
$r=mysql_query($query)or die("course by category query not working L:734");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@= get news by language =@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//get news by language
function get_news($language){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from news where Language='$language'";
$r=mysql_query($query)or die("get news query not fire... L:742");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//get letest news
function get_letest_news($language){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="SELECT * FROM news WHERE Language='$language' ORDER BY Datetime DESC LIMIT 0,2";
$r=mysql_query($query)or die("letest news query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
function general_enquire_process($firstname_contact,$lastname_contact,$email_contact,$phone_contact,$message_contact,$reading_statues){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="Insert into General_Enquire (Enquire_ID,F_name,L_name,Email,Phone,Message,reading_statues) values('','".$firstname_contact."','".$lastname_contact."','".$email_contact."','".$phone_contact."','".$message_contact."','".$reading_statues."')";
mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
}
//Facebook page like.................
function facebook_count($url){
// Query in FQL
$fql = "SELECT share_count, like_count, comment_count ";
$fql .= " FROM link_stat WHERE url = '$url'";
$fqlURL = "https://api.facebook.com/method/fql.query?format=json&query=" . urlencode($fql);
// Facebook Response is in JSON
$response = file_get_contents($fqlURL);
return json_decode($response);
}
function update_password($email,$password3){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1 = "UPDATE usermaster SET
password='$password3'
WHERE Username=$email";
mysql_query($query1)or die('update contect query not working'.__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
header('location:http://englishsikho.nhnfoods.com/dashboard.php');
}
//as par client requirement.
//it will return userid...
function Give_userid($current_username){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
mysql_close($con)or die("LINE No:".__LINE__);
return $userid;
}
//assessment_exam_list_display
function assessment_exam_list_display(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
//$query="select Examid,Examtitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language from exam";
$current_username=$_SESSION['login_user'];
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
$lg=$_SESSION['language'];
$query="select exam.Examid,exam.Examtitle,exam.Examshorttitle,exam.Examdescription,exam.Examduration,exam.Totalmark,exam.Passingmark,exam.Language from exam where exam.Language='$lg' ORDER BY exam.exam_sequence ASC ";
$r=mysql_query($query)or die("Display exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
Function take_exam_again($userid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$sql_query="DELETE
FROM useranswer
Where Userid = $userid";
mysql_query($sql_query)or die(__LINE__);
$sql_query2="DELETE
FROM userexam
Where Userid = $userid";
mysql_query($sql_query2)or die(__LINE__);
$atempted_exam="update usermaster set
atempted_exam='0'
where Userid=$userid";
mysql_query($atempted_exam)or die("atempted_exam Query not fire".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
}
}//class over here.
?>
session_start();
class connection{
//constrction for connection
function connection(){
}
/* function __destruct() {
mysql_close($this->con)or die("not close....");
} */
//insert form firstitme registration
function insert_user_master($first_name,$last_name,$email,$password,$sex,$country,$mobile){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$sel_query="select * from usermaster where Username='$email'";
$r1=mysql_query($sel_query)or die("sel_query query not fire...".__LINE__);
$rows = mysql_num_rows($r1);
if ($rows == 1 ) {
header("location:index.php?log=a_user&id=$email");//if already user registerd then.
}
else{
$user_registere_time=date("Y-m-d H:i:s");
$query="insert into usermaster (Userid,Username,Mobile,Firstname,Lastname,Country,Sex,password,Usertype,Userlogintype,Registrationtype,account_status,registrationDate) values ('','$email','$mobile','$first_name','$last_name','$country','$sex','$password','student','self','self','1','$user_registere_time')";
mysql_query($query)or die("query not fire...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
$_SESSION['login_user']=$email;
header("location:http://englishsikho.nhnfoods.com/mail/2/examples/newuser_mail.php?emailid=$email&first_name=$first_name&last_name=$last_name");
//header('location:index.php?log=log');
}
}
//create new user by admin
function insert_user_master_admin($first_name,$last_name,$email,$password,$sex,$country,$usertype){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="insert into usermaster (Userid,Username,Firstname,Lastname,Country,Sex,password,Usertype,Userlogintype,Registrationtype,account_status) values ('','$email','$first_name','$last_name','$country','$sex','$password','$usertype','self','self','1')";
mysql_query($query)or die("query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header('location:success-registeration.php');
}
//admin and student and techer login here.
Function login_user($email,$password){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from usermaster where Username='$email' AND password='$password'";
$r=mysql_query($query)or die("login user query not fire...");
$rows = mysql_num_rows($r);
if ($rows == 1 ) {
while($row=mysql_fetch_array($r))
{
if($row['Usertype']=='admin')
{
$_SESSION['login_user']=$email;
$_SESSION['Usertype']='admin';
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Admin/all-user.php");
}
else if($row['Usertype']=='student') {
$_SESSION['login_user']=$email;
$_SESSION['Usertype']='student';
mysql_close($con)or die("LINE No:".__LINE__);
if($row['atempted_exam']=='1'){
header("location:dashboard.php");
}else{
header("location:Assessment.php");
}
}else if($row['Usertype']=='techer') {
$_SESSION['login_user']=$email;
$_SESSION['Usertype']='techer';
mysql_close($con)or die("LINE No:".__LINE__);
header("location:techer/index.php");
}
else{
mysql_close($con)or die("LINE No:".__LINE__);
header("location:index.php?log=nouser");
}
}
}else{
mysql_close($con)or die("LINE No:".__LINE__);
header("location:index.php?log=wrong");
}
}
//atempted exam user exam........
/* function atempled_exams($email){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
echo $query="select atempted_exam from usermaster where Username='$email'";
$r=mysql_query($query)or die("error".__LINE__);
$atempted=mysql_fetch_array($r);
if($atempted['atempted_exam']==1){
mysql_close($con)or die("LINE No:".__LINE__);
header('location:http://englishsikho.nhnfoods.com/dashboard.php');
echo "1 attempted.....";
}
} */
//select usermaster
function Displey_usermaster(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from usermaster";
$r=mysql_query($query)or die("login user query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit user by admin
function edit_User_master($uid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from usermaster where Userid=$uid";
$r=mysql_query($query)or die("edit user query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update usermaster
function user_master_update($uid,$username,$firstname,$lastname,$dob,$sex,$address,$country,$state,$City,$Pincode,$phone,$Mobile,$Fax,$Website,$skypeid,$facebook,$Twitter){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query = "UPDATE usermaster SET
Username='$username',
Firstname='$firstname',
Lastname='$lastname',
Birthdate='$dob',
Sex='$sex',
Address='$address',
Country='$country',
State='$state',
City='$City',
Pincode='$Pincode',
Phone='$phone',
Mobile='$Mobile',
Fax='$Fax',
Website='$Website',
Skypeid='$skypeid',
Facebookid='$facebook',
Twitterid='$Twitter'
WHERE Userid=$uid";
mysql_query($query)or die('update master query not working');
mysql_close($con)or die("LINE No:".__LINE__);
}
//active deactive user by admin
function user_active_deactive($uid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_sel="select account_status from usermaster where Userid=$uid";
$status_result=mysql_query($query_sel);
$row = mysql_fetch_assoc( $status_result );
if($row['account_status']==1)
{
$query = "UPDATE usermaster SET account_status='0' WHERE Userid=$uid and account_status=1";
}else
{
$query = "UPDATE usermaster SET account_status='1' WHERE Userid=$uid and account_status=0";
}
mysql_query($query)or die('active deactive query not worked');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-user.php");
}
//add question answer
function add_que_ans($lang,$Question,$question_dis,$anstype,$option1,$option2,$option3,$option4,$option5,$option6,$option1_dis,$option2_dis,$option3_dis,$option4_dis,$option5_dis,$option6_dis,$rightanswer,$rightcomment,$wrongcomment){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="insert into question (Questionid,Questiontitle,Questiondescription,Language) values ('','$Question','$question_dis','$lang')";
mysql_query($query)or die("1 query not fire...");
$query2="SELECT LAST_INSERT_ID()";
$result=mysql_query($query2)or die("2 query not fire...");
$id = mysql_fetch_assoc($result);
$queid=$id['LAST_INSERT_ID()'];
$options=array("$option1","$option2","$option3","$option4","$option5","$option6");
$options= implode('|', $options);
$answer_option_dis=array("$option1_dis","$option2_dis","$option3_dis","$option4_dis","$option5_dis","$option6_dis");
$answer_option_dis= implode('|', $answer_option_dis);
$query3='insert into answer (Answerid,Questionid,Answeroptions,Answertype,RightAnswer,Rightcomment,Wrongcomment,Language,answer_option_dis) values ("","'.$queid.'","'.$options.'","'.$anstype.'","'.$rightanswer.'","'.$rightcomment.'","'.$wrongcomment.'","'.$lang.'","'.$answer_option_dis.'")';
mysql_query($query3)or die("3 query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-questin.php");
}
//display All Questions
function display_all_question(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select question.Questionid,question.Questiontitle,answer.Answeroptions,answer.Answertype,answer.RightAnswer,question.Language from question inner join answer ON question.Questionid=answer.Questionid";
$r=mysql_query($query)or die("login user query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit questions.....
function Edit_question($questionid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select question.Questiontitle,question.Questiondescription,question.Language,answer.Answeroptions,answer.Answertype,answer.RightAnswer,answer.Rightcomment,answer.Wrongcomment ,answer.answer_option_dis from question inner join answer ON $questionid=answer.Questionid where question.Questionid=$questionid";
$r=mysql_query($query)or die("edit question query not fire".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update questions answer
function update_que_ans($lang,$Question,$question_dis,$anstype,$option1,$option2,$option3,$option4,$option5,$option6,$option1_dis,$option2_dis,$option3_dis,$option4_dis,$option5_dis,$option6_dis,$rightanswer,$rightcomment,$wrongcomment,$queid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query = "UPDATE question SET
Questiontitle='$Question',
Questiondescription='$question_dis',
Language='$lang'
WHERE Questionid=$queid";
mysql_query($query)or die('update question query not working');
$options=array("$option1","$option2","$option3","$option4","$option5","$option6");
$options= implode('|', $options);
$answer_option_dis=array("$option1_dis","$option2_dis","$option3_dis","$option4_dis","$option5_dis","$option6_dis");
$answer_option_dis= implode('|', $answer_option_dis);
$query1 = 'UPDATE answer SET
Answeroptions="'.$options.'",
answer_option_dis="'.mysql_real_escape_string($answer_option_dis).'",
Answertype="'.$anstype.'",
RightAnswer="'.$rightanswer.'",
Rightcomment="'.mysql_real_escape_string($rightcomment).'",
Wrongcomment="'.mysql_real_escape_string($wrongcomment).'",
Language="'.$lang.'"
WHERE Questionid="'.$queid.'"';
mysql_query($query1)or die('update answer query not working'.__LINE__);
//mysql_query($query1);
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-questin.php");
}
//Delete Question
function Delete_question($queid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="DELETE FROM question WHERE Questionid = $queid";
mysql_query($query)or die('delete question query not working');
$query1="DELETE FROM answer WHERE Questionid = $queid";
mysql_query($query1)or die('delete answer query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-questin.php");
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=EXAM=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
//create new Exam
function Creat_exam_process($lang,$Examtitle,$Examshorttitle,$Examdescription,$Examduration,$Totalmark,$Passingmark,$Passcomment,$Failcomment){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into exam (Examid,Examtitle,Examshorttitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language) values ("","'.$Examtitle.'","'.$Examshorttitle.'","'.$Examdescription.'","'.$Examduration.'","'.$Totalmark.'","'.$Passingmark.'","'.$Passcomment.'","'.$Failcomment.'","'.$lang.'")';
mysql_query($query)or die("create exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-exam.php");
}
//display all exam
function display_all_exam(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select Examid,Examtitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language from exam";
$r=mysql_query($query)or die("Display exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
// Edit Exam.
function edit_exam($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select Examid,Examtitle,Examshorttitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language from exam where Examid=$examid";
$r=mysql_query($query)or die("edit exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
// Update Exam Process
function Update_exam_process($lang,$Examtitle,$Examshorttitle,$Examdescription,$Examduration,$Totalmark,$Passingmark,$Passcomment,$Failcomment,$Examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
echo $query1 = 'UPDATE exam SET
Examtitle="'.$Examtitle.'",
Examshorttitle="'.$Examshorttitle.'",
Examdescription="'.$Examdescription.'",
Examduration="'.$Examduration.'",
Totalmark="'.$Totalmark.'",
Passingmark="'.$Passingmark.'",
Passcomment="'.mysql_real_escape_string($Passcomment).'",
Failcomment="'.mysql_real_escape_string($Failcomment).'",
Language="'.$lang.'"
WHERE Examid="'.$Examid.'"';
mysql_query($query1)or die('update exam query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-exam.php");
}
//delete exam
function Delete_exam($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="DELETE FROM exam WHERE Examid = $examid";
mysql_query($query)or die('delete exam query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-exam.php");
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=Add Question in exam=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
//question display in manage exam
function display_manage_exam_question($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
//$query="SELECT TT.Questionid,TT.Questiontitle,answer.Answeroptions,answer.Answertype,answer.RightAnswer,tt.Language, (select examquestion.Examquestionid from examquestion where examquestion.Questionid = TT.Questionid and examquestion.Examid=$examid) as chkbox from question As TT inner join answer ON tt.Questionid=answer.Questionid";
$get_exam_language="SELECT Language from exam where Examid=$examid";
$result_exam_language=mysql_query($get_exam_language);
$result_exam_language=mysql_fetch_array($result_exam_language);//get exam language.
$query="SELECT TT.Questionid,TT.Questiontitle,answer.Answeroptions,answer.Answertype,answer.RightAnswer,tt.Language, (select examquestion.Examquestionid from examquestion where examquestion.Questionid = TT.Questionid and examquestion.Examid=$examid and tt.Language='$result_exam_language[0]') as chkbox from question As TT inner join answer ON tt.Questionid=answer.Questionid WHERE tt.Language='$result_exam_language[0]'";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//delete EXAM Question
function delete_exam_question($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_delete="DELETE FROM examquestion WHERE Examid = $examid";
mysql_query($query_delete)or die('delete exam questions query not working');
mysql_close($con)or die("LINE No:".__LINE__);
}
//Add EXAM Question
function add_exam_questions_process($examid,$quesionids){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into examquestion (Examquestionid,Examid,Questionid) values ("","'.$examid.'","'.$quesionids.'")';
mysql_query($query)or die("create exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=Create cource=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
//add course category
function insert_category($category_name,$lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into course_category (categoryid,categoryname,Language) values ("","'.$category_name.'","'.$lang.'")';
mysql_query($query)or die ("cource category insert query not working");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Display-Caurse-category.php");
}
//display course category
function display_course_category(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select categoryid,categoryname,Language from course_category";
$r=mysql_query($query)or die("Display course category query not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit cource category
function edit_course_category($categoryid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from course_category where categoryid=$categoryid";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update category
function update_category($categoryid,$category_name,$lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="UPDATE course_category set
categoryname='$category_name',
Language='$lang'
WHERE categoryid=$categoryid";
mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Display-Caurse-category.php");
}
//Delete cource Category
function Delete_course_category($categoryid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="Delete from course_category where categoryid=$categoryid";
mysql_query($query)or die("Delete category query not working");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Display-Caurse-category.php");
}
///////////////
//create Course
function Creat_course_process($lang,$course_name,$coursedescription,$courseduration,$Feetype,$CourseType,$categoryname){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into course (Courseid,Cousename,Coursedescription,Courseduration,Feetype,Coursetype,Language,categoryname) values ("","'.$course_name.'","'.$coursedescription.'","'.$courseduration.'","'.$Feetype.'","'.$CourseType.'","'.$lang.'","'.$categoryname.'")';
mysql_query($query)or die("create cource query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Courses.php");
}
//Display course
function display_all_course(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='select Courseid,Cousename,Coursedescription,Courseduration,Feetype,Coursetype,Language,categoryname from course';
$r=mysql_query($query)or die("display course query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit cource
function edit_course($courseid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select Courseid,Cousename,Coursedescription,Courseduration,Feetype,Coursetype,Language,categoryname from course where Courseid=$courseid";
$r=mysql_query($query)or die("display course query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update cource
function Update_course_process($Courseid,$lang,$course_name,$coursedescription,$courseduration,$Feetype,$CourseType,$categoryname){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1 = 'UPDATE course SET
Cousename="'.$course_name.'",
Coursedescription="'.mysql_real_escape_string($coursedescription).'",
Courseduration="'.$courseduration.'",
Feetype="'.$Feetype.'",
Coursetype="'.$CourseType.'",
categoryname="'.$categoryname.'",
Language="'.$lang.'"
WHERE Courseid="'.$Courseid.'"';
mysql_query($query1)or die('update course query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Courses.php");
}
//delete cource
function Delete_course($courseid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_delete="DELETE FROM course WHERE Courseid = $courseid";
mysql_query($query_delete)or die('delete exam questions query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:Courses.php");
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=add News=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
//add news
function add_news($lang,$newstitle,$Newsdescription){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$news_time=date("Y-m-d H:i:s");
$query='insert into news (Newsid,Title,Description,Language,Datetime) values ("","'.$newstitle.'","'.$Newsdescription.'","'.$lang.'","'.$news_time.'")';
mysql_query($query)or die("add news query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-news.php");
}
//display all news
function display_all_news(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from news ";
$r=mysql_query($query)or die("display news query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit news
function edit_news($newsid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from news where Newsid=$newsid";
$r=mysql_query($query)or die("edit news query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update news
function update_news($newsid,$datetime,$newstitle,$Newsdescription,$lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1 = 'UPDATE news SET
Newsid="'.$newsid.'",
Datetime="'.$datetime.'",
Title="'.$newstitle.'",
Description="'.$Newsdescription.'",
Language="'.$lang.'"
WHERE Newsid="'.$newsid.'"';
mysql_query($query1)or die('update News query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-news.php");
}
//delete news
function Delete_news($newsid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_delete="DELETE FROM news WHERE Newsid = $newsid";
mysql_query($query_delete)or die('delete news query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-news.php");
}
/*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=add Video=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
//add video
function add_video($lang,$videotitle,$videodescription,$embed){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$news_time=date("Y-m-d H:i:s");
$query='insert into video (videoid,title,description,embed,datetime,language) values ("","'.$videotitle.'","'.$videodescription.'","'.$embed.'","'.$news_time.'","'.$lang.'")';
mysql_query($query)or die("add video query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-video.php");
}
//display all videos
function display_all_videos(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from video ";
$r=mysql_query($query)or die("display video query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit video
function edit_video($videoid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from video where videoid=$videoid";
$r=mysql_query($query)or die("edit video query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update video
function update_video($videoid,$videotitle,$videodescription,$lang,$embed){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1 = 'UPDATE video SET
title="'.$videotitle.'",
embed="'.mysql_real_escape_string($embed).'",
description="'.mysql_real_escape_string($videodescription).'",
language="'.$lang.'"
WHERE videoid="'.$videoid.'" ';
mysql_query($query1)or die('update video query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-video.php");
}
//delete video
function Delete_video($videoid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_delete="DELETE FROM video WHERE videoid = $videoid";
mysql_query($query_delete)or die('delete news query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:all-video.php");
}
//display selected id videos
function display_selected_videos($videoid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from video where videoid=$videoid";
$r=mysql_query($query)or die("display video query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@#=User wise report=#@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//Get user as a student @for user wise exam report.
function user_as_a_student(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from usermaster where Usertype='student'";
$r=mysql_query($query)or die("login user query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//display axam list.
function get_users_exam_process($userid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select exam.Examid,exam.Examtitle,userexam.Userid,userexam.Examdate,userexam.Exammark,userexam.Examstatus FROM exam INNER JOIN userexam ON exam.Examid=userexam.Examid WHERE userexam.Userid=$userid";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//return user name
function get_user_name($userid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select Username from usermaster where Userid=$userid";
$r=mysql_query($query);
$row=mysql_fetch_array($r);
mysql_close($con)or die("LINE No:".__LINE__);
return $row[0];
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@#=Exam wise report=#@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
function Exam_given_by_students(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select exam.Examid,exam.Examtitle,exam.Language from exam inner join userexam ON exam.Examid=userexam.Examid GROUP BY exam.Examid";
$r=mysql_query($query)or die("exam wise repot query not fire...__LINE__");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//display student list.
function get_users_exam_process_by_exam($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="SELECT usermaster.Userid,usermaster.Firstname,usermaster.Lastname,usermaster.Username,usermaster.Mobile,userexam.Examstatus,userexam.Exammark FROM usermaster INNER JOIN userexam ON userexam.Userid=usermaster.Userid WHERE userexam.Examid=$examid";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@#=add_contact_details_process=#@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
function add_contact_details_process($contactemail,$ContactMobile,$ContactPhone,$ContactAddress,$ContactCompnyname,$ContactSlogan,$ContactFax,$lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into contect_us (Contect_id,EmailID,Mobile,Phone,Address,CompnyName,Slogan,Fax, Language) values ("","'.$contactemail.'","'.$ContactMobile.'","'.$ContactPhone.'","'.$ContactAddress.'","'.$ContactCompnyname.'","'.$ContactSlogan.'","'.$ContactFax.'","'.$lang.'")';
mysql_query($query)or die("Add contact details query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:show-contact-Details.php");
}
function show_contact_Details(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="Select Contect_id,EmailID,Mobile,Phone,Address,CompnyName,Slogan,Fax,Language From contect_us ";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit contact details
function Edit_contact_details($contactid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="Select Contect_id,EmailID,Mobile,Phone,Address,CompnyName,Slogan,Fax,Language From contect_us where Contect_id=$contactid ";
$r=mysql_query($query)or die("edit contact query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update contect details
function Update_contact_details_process($Contect_id,$contactemail,$ContactMobile,$ContactPhone,$ContactAddress,$ContactCompnyname,$ContactSlogan,$ContactFax,$lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1 = 'UPDATE contect_us SET
EmailID="'.$contactemail.'",
Mobile="'.$ContactMobile.'",
Phone="'.$ContactPhone.'",
Address="'.$ContactAddress.'",
CompnyName="'.$ContactCompnyname.'",
Slogan="'.$ContactSlogan.'",
Fax="'.$ContactFax.'",
Language="'.$lang.'"
WHERE Contect_id="'.$Contect_id.'"';
mysql_query($query1)or die('update contect query not working');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:show-contact-Details.php");
}
//delet contact details
function Delete_contact_details($contactid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="Delete From contect_us where Contect_id=$contactid";
mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
header("Location:show-contact-Details.php");
}
//Contact details footer
function contact_detail_footer(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$lg=$_SESSION['language'];
$query="select * from contect_us where Language='$lg' ";
$r=mysql_query($query)or die ("contact detail footer not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
function newsletter_subscribe($email_newsletter){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$sel_query="select * from news_subscribe where EmailID='$email_newsletter'";
$r1=mysql_query($sel_query)or die("sel_query query not fire...");
$rows = mysql_num_rows($r1);
if ($rows == 1 ) {
}
else{
$query="Insert into news_subscribe (Id,EmailID) values ('','$email_newsletter')";
$r=mysql_query($query)or die ("subscribe query Not working...");
mysql_close($con)or die("LINE No:".__LINE__);
}
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=insert,update page content=@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//insert content for developer.
function insert_content_of_page_process($lang,$page_name,$page_content_flag,$Content){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into pagecontent (Contentid,Pagename,contentflag,content,language) values ("","'.$page_name.'","'.$page_content_flag.'","'.$Content.'","'.$lang.'")';
$r=mysql_query($query)or die ("insert page content query Not working...");
mysql_close($con)or die("LINE No:".__LINE__);
header("location:insert_content_of_pages.php");
}
//display page wise contact
function display_pages_contents($page){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from pagecontent where Pagename='$page'";
$r=mysql_query($query)or die("page wise contant query not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit page contect
function edit_page_content($Content_id){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from pagecontent where Contentid=$Content_id";
$r=mysql_query($query)or die("edit page content query not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update page content
function update_content_of_page_process($Contentid,$lang,$page_name,$page_content_flag,$Content,$rdirect){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
// $query1 = 'UPDATE pagecontent SET
// Pagename="'.$page_name.'",
// contentflag="'.$page_content_flag.'",
// content="'.$Content.'",
// language="'.$lang.'"
// WHERE Contentid="'.$Contentid.'"';
$query1 = "UPDATE pagecontent SET
Pagename='$page_name',
contentflag='$page_content_flag',
content='$Content',
language='$lang'
WHERE Contentid=$Contentid";
mysql_query($query1)or die('update contect query not working L:490');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:$rdirect");
}
//general_enquire_notification_process
function general_enquire_notification_process(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select count(*) from general_enquire where reading_statues='unread'";
$r=mysql_query($query);
$result=mysql_fetch_array($r);
mysql_close($con)or die("LINE No:".__LINE__);
//print_r($result);
return $result[0];
}
//general_enquire_display
function general_enquire_display(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from general_enquire ORDER BY Enquire_ID DESC";
$r=mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//messagestatus up date by admin
function messagestatus($msgid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query_sel="select reading_statues from general_enquire where Enquire_ID=$msgid";
$status_result=mysql_query($query_sel);
$row = mysql_fetch_assoc($status_result);
print_r($row);
if($row['reading_statues']=='unread')
{
echo $query = "UPDATE general_enquire SET reading_statues='Read' WHERE Enquire_ID=$msgid and reading_statues='unread'";
}else
{
echo $query = "UPDATE general_enquire SET reading_statues='unread' WHERE Enquire_ID=$msgid and reading_statues='Read'";
}
mysql_query($query)or die('message status query not worked');
mysql_close($con)or die("LINE No:".__LINE__);
header("location:inquery_inbox.php");
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//add smtp configuration
function smtp_configuration_setting_process($admin_emailid,$smtp_email,$smtp_host,$smtp_port,$smtp_password){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='insert into smtp_setting (id,admin_emailid,smtp_email,smtp_host,smtp_port,smtp_password) values ("","'.$admin_emailid.'","'.$smtp_email.'","'.$smtp_host.'","'.$smtp_port.'","'.$smtp_password.'")';
$r=mysql_query($query)or die ("insert smtp_setting query Not working...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
}
//display smtp configuration
function display_smtp_configuration(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from smtp_setting";
$r=mysql_query($query)or die ("display smtp_setting query Not working...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//edit smtp configuration
function smtp_settion_edit_process($id){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from smtp_setting where id=".$id;
$r=mysql_query($query)or die ("edit smtp_setting query Not working...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//update smtp configuration
function smtp_setting_update_process($id,$admin_emailid,$smtp_email,$smtp_host,$smtp_port,$smtp_password){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query = 'UPDATE smtp_setting SET
admin_emailid="'.$admin_emailid.'",
smtp_email="'.$smtp_email.'",
smtp_host="'.$smtp_host.'",
smtp_port="'.$smtp_port.'",
smtp_password="'.$smtp_password.'"
WHERE id="'.$id.'"';
$r=mysql_query($query)or die ("update smtp_setting query Not working...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
}
// @#@#@#@#@#@#@#@#@#@#@#@#@
//##@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@ @#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#//
//################################################################### Client Side Functions ##############################################################################// //##@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@ @#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#@#//
// @#@#@#@#@#@#@#@#@#@#@#@#@
/*
@ User site funtions write here.
@ some users funtions write here.
*/
function User_profile($userid,$usertype){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from usermaster where Username='$userid' and Usertype='$usertype'";
$r=mysql_query($query)or die("user profile query not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//display users exam
function users_exam_display(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
//$query="select Examid,Examtitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language from exam";
$current_username=$_SESSION['login_user'];
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
//old
//echo $query="select exam.Examid,exam.Examtitle,exam.Examdescription,exam.Examduration,exam.Totalmark,exam.Passingmark,exam.Language,(select userexam.Examid from userexam where userexam.Examid=exam.Examid and userexam.Userid='$userid') as view_result from exam";
$lg=$_SESSION['language'];
$query="select exam.Examid,exam.Examtitle,exam.Examdescription,exam.Examduration,exam.Totalmark,exam.Passingmark,exam.Language,(select userexam.Examid from userexam where userexam.Examid=exam.Examid and userexam.Userid='$userid') as view_result from exam where exam.Language='$lg'";
$r=mysql_query($query)or die("Display exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//display exam detail
function exam_details($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select Examid,Examtitle,Examshorttitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language from exam where Examid=$examid";
$r=mysql_query($query)or die("Display exam details query not fire...".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//totle exam of question
function total_quetion_of_exam($examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select count(*) from examquestion where Examid=$examid";
$r=mysql_query($query)or die("total exam quetion query not fire");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//Exam Start time
function exam_start_time(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
date_default_timezone_set("Asia/Calcutta");
$_SESSION['exam_start_time']=date("Y-m-d H:i:s");
mysql_close($con)or die("LINE No:".__LINE__);
}
//exam start.
function runnig_exam_quesion($examid,$question){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from examquestion where Examid=$examid order By `Questionid` LIMIT $question, 1 ";
$r=mysql_query($query) or die("runnig_exam_quesion query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r ;
}
//DISPLAY QUETION OF RUNNING EXAM
function runnig_exam_quesion_display($queid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select question.Questionid,question.Questiontitle,answer.Answeroptions,answer.Answertype,answer.RightAnswer,question.Language,question.Questiondescription from question inner join answer ON question.Questionid=answer.Questionid where question.Questionid=$queid";
$r=mysql_query($query)or die("login user query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//SUBMIT USERS ANSWER..
function submit_user_answer($priousequetionid,$user_ans,$examid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from answer where Questionid=$priousequetionid"; //pques 165
$r=mysql_query($query)or die("answer submit query not fire1");
$row=mysql_fetch_array($r);
$answer_id=$row[0]; //143
$RightAnswer=$row[4]; //yes
$current_username=$_SESSION['login_user'];
//user's answer chacking here.
$RightAnswer2 = explode(",",$RightAnswer);
$user_ans=trim($user_ans);
if(in_array($user_ans,$RightAnswer2)){
$wrong_or_right="Right";
$comment=$row[5];
$answermark=1;
}else{
$wrong_or_right="wrong";
$comment=$row[6];
$answermark=0;
}
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1)or die("answer submit query not fire2");
$row1=mysql_fetch_array($r1);
$userid=$row1[0]; // 89
//$query2='Insert into useranswer (Useranswerid,Examid,Userid,Answerid,Useranswer,Wrongright,comment,Answermark,Quetinoid) values("","'.$examid.'","'.$userid.'","'.$answer_id.'","'.$user_ans.'","'.$wrong_or_right.'","'.$comment.'","'.$answermark.'","'.$priousequetionid.'")';
$query2='Insert into useranswer (Useranswerid,Examid,Userid,Answerid,Useranswer,Wrongright,comment,Answermark,Quetinoid) values ("","'.$examid.'","'.$userid.'","'.$answer_id.'","'.$user_ans.'","'.$wrong_or_right.'","'.mysql_real_escape_string($comment).'","'.$answermark.'","'.$priousequetionid.'")';
mysql_query($query2)or die("answer submit query not fire3");
mysql_close($con)or die("LINE No:".__LINE__);
}
//SUBMINT USER EXAM AND EXAM RESULT
function user_exam($examid,$current_username,$timeout){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
$query2="select Passingmark from exam where Examid=$examid";
$r2=mysql_query($query2);
$row2=mysql_fetch_array($r2);
$passing_mark=$row2[0];//current exams passing mark.
$query3="select count(*) from useranswer where Examid=$examid and Answermark='1' and Userid=$userid";
$right_ans_marks=mysql_query($query3)or die("right ans mark count query not fire");
$right_ans_marks = mysql_fetch_array($right_ans_marks);
$right_ans_marks=$right_ans_marks[0];//right ans by user
if($right_ans_marks< $passing_mark){
$exam_status="Fail";
$query4="select Failcomment from exam where Examid=$examid";
}else{
$exam_status="Pass";
$query4="select Passcomment from exam where Examid=$examid";
}
$exam_comment=mysql_query($query4);
$exam_comment=mysql_fetch_array($exam_comment);
$exam_comment=$exam_comment[0];//exam_comment
$exam_start_time=$_SESSION['exam_start_time'];//exam start time
date_default_timezone_set("Asia/Calcutta");
$exam_end_time=date("Y-m-d H:i:s");
$query5='Insert into userexam (Userexamid,Examid,Userid,Examstatus,Exammark,Comment,exam_start_time,exam_end_time,Timeout,Examdate) values ("","'.$examid.'","'.$userid.'","'.$exam_status.'","'.$right_ans_marks.'","'.$exam_comment.'","'.$exam_start_time.'","'.$exam_end_time.'","'.$timeout.'","'.$exam_start_time.'")';
mysql_query($query5);
mysql_close($con)or die("LINE No:".__LINE__);
}
function atempled_exams_by_user($current_username){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
//user attempted 1 exam then it will run...
$atempted_exam="update usermaster set
atempted_exam='1'
where Username='$current_username'";
mysql_query($atempted_exam)or die("atempted_exam Query not fire".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
}
//view result
function view_result($examid,$current_username){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
$query="select exam.Examtitle,exam.Examdescription,exam.Totalmark,userexam.Examdate,userexam.Examstatus, userexam.Exammark,userexam.comment,userexam.Timeout from exam inner join userexam ON userexam.Examid = exam.Examid AND userexam.Userid=$userid and userexam.Examid=$examid";
$r=mysql_query($query)or die("view result quer1 not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//view quetion in result page
function view_quetion_and_result($examid,$current_username){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
$query="select useranswer.Quetinoid,useranswer.Useranswer,useranswer.Wrongright,useranswer.comment,question.Questiontitle FROM useranswer INNER JOIN
question ON question.Questionid = useranswer.Quetinoid where useranswer.Userid=$userid and useranswer.Examid=$examid";
$r=mysql_query($query)or die("view quetion and result query not working.");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@=Home page content highlight_boxs =@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
function select_content_of_page($language,$content_flag,$page_name){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from pagecontent where Pagename='$page_name' and contentflag='$content_flag' and language='$language'";
$r=mysql_query($query)or die("select content for page query not working L:728");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@= caurse by category =@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//Display All course by language
function display_all_course_F($lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query='select Courseid,Cousename,Coursedescription,Courseduration,Feetype,Coursetype,Language,categoryname from course where Language="'.$lang.'"';
$r=mysql_query($query)or die("display course query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//display course category by lang
function display_course_category_f($lang){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select categoryid,categoryname,Language from course_category where Language='$lang'";
$r=mysql_query($query)or die("Display course category query not working");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
function get_course_by_category($categoryname){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$lg=$_SESSION['language'];
//and Language='$lg'
$query="select * from course where categoryname='$categoryname'";
$r=mysql_query($query)or die("course by category query not working L:734");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@= get news by language =@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
//get news by language
function get_news($language){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="select * from news where Language='$language'";
$r=mysql_query($query)or die("get news query not fire... L:742");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
//get letest news
function get_letest_news($language){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="SELECT * FROM news WHERE Language='$language' ORDER BY Datetime DESC LIMIT 0,2";
$r=mysql_query($query)or die("letest news query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
function general_enquire_process($firstname_contact,$lastname_contact,$email_contact,$phone_contact,$message_contact,$reading_statues){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query="Insert into General_Enquire (Enquire_ID,F_name,L_name,Email,Phone,Message,reading_statues) values('','".$firstname_contact."','".$lastname_contact."','".$email_contact."','".$phone_contact."','".$message_contact."','".$reading_statues."')";
mysql_query($query);
mysql_close($con)or die("LINE No:".__LINE__);
}
//Facebook page like.................
function facebook_count($url){
// Query in FQL
$fql = "SELECT share_count, like_count, comment_count ";
$fql .= " FROM link_stat WHERE url = '$url'";
$fqlURL = "https://api.facebook.com/method/fql.query?format=json&query=" . urlencode($fql);
// Facebook Response is in JSON
$response = file_get_contents($fqlURL);
return json_decode($response);
}
function update_password($email,$password3){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1 = "UPDATE usermaster SET
password='$password3'
WHERE Username=$email";
mysql_query($query1)or die('update contect query not working'.__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
header('location:http://englishsikho.nhnfoods.com/dashboard.php');
}
//as par client requirement.
//it will return userid...
function Give_userid($current_username){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
mysql_close($con)or die("LINE No:".__LINE__);
return $userid;
}
//assessment_exam_list_display
function assessment_exam_list_display(){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
//$query="select Examid,Examtitle,Examdescription,Examduration,Totalmark,Passingmark,Passcomment,Failcomment,Language from exam";
$current_username=$_SESSION['login_user'];
$query1="select Userid from usermaster where Username='$current_username'";
$r1=mysql_query($query1);
$row1=mysql_fetch_array($r1);
$userid=$row1[0];//user id
$lg=$_SESSION['language'];
$query="select exam.Examid,exam.Examtitle,exam.Examshorttitle,exam.Examdescription,exam.Examduration,exam.Totalmark,exam.Passingmark,exam.Language from exam where exam.Language='$lg' ORDER BY exam.exam_sequence ASC ";
$r=mysql_query($query)or die("Display exam query not fire...");
mysql_close($con)or die("LINE No:".__LINE__);
return $r;
}
Function take_exam_again($userid){
$con = mysql_connect("localhost","root","")or die("Database connection not worked");
$db = mysql_select_db("englishsikho",$con)or die("database not found");
$sql_query="DELETE
FROM useranswer
Where Userid = $userid";
mysql_query($sql_query)or die(__LINE__);
$sql_query2="DELETE
FROM userexam
Where Userid = $userid";
mysql_query($sql_query2)or die(__LINE__);
$atempted_exam="update usermaster set
atempted_exam='0'
where Userid=$userid";
mysql_query($atempted_exam)or die("atempted_exam Query not fire".__LINE__);
mysql_close($con)or die("LINE No:".__LINE__);
}
}//class over here.
?>