Your New Password created. You can login with the following credentials.
User ID : $newpass.
Password : $pas.
" ; $headers .= 'From:Impetus Healthcare Skills' . "\r\n"; mail($to, $subject, $message, $headers); //echo $message."
".$to; echo ""; } } /*-------------------------- Registration End----------------------------------*/ /*-------------------------- Activation Start----------------------------------*/ function active(){ extract($_REQUEST); $sql=mysql_query("UPDATE admin SET Activation='$act' WHERE Userid='$id'"); } function fstlogin(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM admin WHERE Userid='$username' and Password='$password' and (Status='2' or Status='3' or Status='6') and Activation='1'"); $cnt=mysql_num_rows($sql); if($cnt!='0'){ $res=mysql_fetch_assoc($sql); return $res; } else{ echo ""; } } /*-------------------------- Activation End----------------------------------*/ /*------------------ LOGIN QUERY START------------------------------*/ function login(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM admin WHERE Userid='$username' and Password='$password' and (Status='1' or Status='4' or Status='5' or Status='7' )"); $res=mysql_fetch_assoc($sql); return $res; } function Users_logins(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM admin WHERE Userid='$username' and Password='$password' and (Status='2' or Status='3' or Status='6')"); $res=mysql_fetch_assoc($sql); return $res; } function stdlogin(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM admin WHERE Userid='$username' and Password='$password' and (Status='2')"); $res=mysql_fetch_assoc($sql); return $res; } function nurlogin(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM admin WHERE Userid='$username' and Password='$password' and Status='3' "); $res=mysql_fetch_assoc($sql); return $res; } /*------------------ LOGIN QUERY END------------------------------*/ /*------------------------ Student Details Start ----------------------------------------*/ function insert_std(){ extract($_REQUEST); if($_FILES['add_img']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['add_img']['tmp_name']; $img1=$uniqueid.$_FILES['add_img']['name']; move_uploaded_file($tempfile,"../image/Students/".$img1); } else{ $img1=$_REQUEST['oldimg']; } $sql="UPDATE studentdetail SET dob='$datepicker',gender='$gender',mobile='$mobilenum',address='$add_1',address2='$add_2',clg_name='$clg',clg_address='$clg_add1', clg_address2='$clg_add2', university='$univ',year='$yearstudy',city='$city',state='$state',district='$dict',pincode='$pin',image='$img1',clgcity='$clg_city', clgdistrict='$clg_dis',clgstate='$clg_state',clgpincode='$clg_pin' WHERE std_id='".$_SESSION['sid']."' "; $ext=mysql_query($sql); return $sql; /*$sql=mysql_query("INSERT INTO studentdetail (dob,address,clg_name,clg_address,university) VALUES ('".$_SESSION['sid']."','$dob','$add','$styr','$clg','$clgadd','$univ')")or die(mysql_error());*/ //echo ""; } function sel_stdyears(){ extract($_REQUEST); //echo $sqlst="SELECT * FROM studentdetail WHERE std_id='".$_SESSION['sid']."'"; $sqlst=mysql_fetch_assoc(mysql_query("SELECT * FROM studentdetail WHERE std_id='".$_SESSION['sid']."'")); return $sqlst; } /*------------------------ Student Details End ----------------------------------------*/ /*------------------------ Nurse Details Start ----------------------------------------*/ function nur_detail(){ extract($_REQUEST); $sqlst=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_details WHERE nur_id='".$_SESSION['sid']."'")); return $sqlst; } function nur_deta($a){ extract($_REQUEST); $sqlst=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_details WHERE nur_id='$a'")); return $sqlst; } function insert_nrs(){ extract($_REQUEST); if($_FILES['image_add']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['image_add']['tmp_name']; $img1=$uniqueid.$_FILES['image_add']['name']; move_uploaded_file($tempfile,"../image/Subject/".$img1); } $sql=mysql_query("INSERT INTO nur_details (nur_id,dob,address,gender) VALUES ('".$_SESSION['sid']."','$dob','$add_1','$gender')") or die(mysql_error()); echo ""; } function update_nurs_profile(){ extract($_REQUEST); if($_FILES['nur_img']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['nur_img']['tmp_name']; $img1=$uniqueid.$_FILES['nur_img']['name']; move_uploaded_file($tempfile,"image/Nurse/".$img1); }else{ $img1=$_REQUEST['old_img']; } $sql=mysql_query("Update nur_details SET dob='$dob',address='$add_1',address2='$add_2',gender='$gender',city='$city',state='$state',district='$dict',pincode='$pin',rn_number='$rn_number',image='$img1' ,mobile='$mobile',pan_no='$pan_no',adhar_no='$adhar_no' Where nur_id='".$_SESSION['sid']."'"); header('location:updateprofile.php?up=suc'); // echo ""; } function update1_nrs(){ extract($_REQUEST); if($gnm=='gnm') { if(!empty($gnm1)){ $gnmdetails=implode('^',$gnm1); } } if($gnm=='pc'){ if(!empty($gnm2)){ $gnmdetails=implode('^',$gnm2); } if(!empty($pc1)){ $pcdetails=implode('^',$pc1);} } if($gnm=='bsc'){ if(!empty($bsc1)){ $bscdetails=implode('^',$bsc1);} } if($gnm=='msc'){ if(!empty($bsc2)){ $bscdetails=implode('^',$bsc2);} if(!empty($msc1)){ $mscdetails=implode('^',$msc1);} } if($gnm=='phd'){ if(!empty($msc2)){ $mscdetails=implode('^',$msc2);} if(!empty($phd1)){ $phddetails=implode('^',$phd1);} } $sql=mysql_query("Update nur_details SET GNM='$gnmdetails',PC='$pcdetails',BSc='$bscdetails',MSc='$mscdetails',PHd='$phddetails' Where nur_id='".$_SESSION['sid']."'") or die(mysql_error()); header('location:updateprofile.php?up=suc'); } function nrs_exp(){ extract($_REQUEST); $horg=implode('^',$hsadd); $sql=mysql_query("Update nur_details SET Organization='$horg' Where nur_id='".$_SESSION['sid']."' ") or die(mysql_error()); header('location:updateprofile.php?up=suc'); } function nrs_other(){ extract($_REQUEST); $sql="Update nur_details SET other='$other' Where nur_id='".$_SESSION['sid']."' "; $qry=mysql_query($sql) or die(mysql_error()); header('location:updateprofile.php?up=suc'); } /*------------------------ Student Details End ----------------------------------------*/ /*------------------ SUBJECT QUERY START------------------------------*/ function insert_sub(){ extract($_REQUEST); $sel=mysql_num_rows(mysql_query("SELECT * FROM subject WHERE Code='$code'")); if($sel==0){ if($_FILES['attach']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/Subject/".$img1); } //echo $sql="INSERT INTO subject (Year,Subject,Code,Status,Attach,descreption,seo_key,seo_title,seo_desc) VALUES ('$yr','$sub','$code','1','$img1','$sub_desc','$module_seo_key','$module_seo_title','$module_seo_dic')"; $sql=mysql_query("INSERT INTO subject (Year,Subject,Code,Status,Attach,descreption,seo_key,seo_title,seo_desc) VALUES ('$yr','$sub','$code','1','$img1','$sub_desc','$module_seo_key','$module_seo_title','$module_seo_dic')"); echo ""; } else{ echo ""; } } function sel_sub(){ $sql=mysql_query("SELECT * FROM subject"); return $sql; } function sl_sub($a){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM subject Where Code='$a'")); return $sql; } function subby_yr(){ extract($_REQUEST); $sql= mysql_query("SELECT * FROM subject WHERE Year='$yr'"); return $sql; } function year_filter(){ extract($_REQUEST); if($yrfilter=='all'){ $sql= mysql_query("SELECT * FROM subject"); return $sql; } $sql= mysql_query("SELECT * FROM subject WHERE Year='$yrfilter'"); return $sql; } function subby_id(){ extract($_REQUEST); $sql= mysql_fetch_assoc(mysql_query("SELECT * FROM subject WHERE Code='$subj'")); return $sql; } function subby_id1(){ extract($_REQUEST); $sql= mysql_fetch_assoc(mysql_query("SELECT * FROM subject WHERE Code='$subj'")); return $sql; } function titleby_sub(){ extract($_REQUEST); $sql= mysql_query("SELECT * FROM subject WHERE Year='$year' and Subject='$subj'"); return $sql; } function up_subj(){ extract($_REQUEST); if($_FILES['attach']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/Subject/".$img1); } else{ $img1=$_REQUEST['oldimg']; } //echo $sql="UPDATE subject SET Subject='$upsub',Attach='$img1' descreption='$sub_desc',seo_key='$module_seo_key',seo_title='$module_seo_title', //seo_desc='$module_seo_dic' WHERE Code='$subj'"; $sql=mysql_query("UPDATE subject SET Subject='$upsub',Attach='$img1', descreption='$sub_desc',seo_key='$module_seo_key',seo_title='$module_seo_title', seo_desc='$module_seo_dic' WHERE Code='$subj'"); //echo ""; } function subj_status(){ extract($_REQUEST); $sql=mysql_query("UPDATE subject SET Status='$stat' WHERE Id='$id'"); //echo ""; } function del_sub(){ extract($_REQUEST); $sql=mysql_query("DELETE FROM subject WHERE Id='$id'"); echo ""; } /*------------------ SUBJECT QUERY END------------------------------*/ /*------------------ CHAPTER QUERY START------------------------------*/ function add_title(){ extract($_REQUEST); $sel=mysql_num_rows(mysql_query("SELECT * FROM chapter WHERE code='$code'")); if($sel==0){ if($_FILES['attach']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/Lesson/".$img1); } $sql="INSERT INTO chapter (year,subject,code,chapter,discription,attach,Status,serial) Values ('$yr','$subj','$code','$title','$dis','$img1','1','$serial')"; mysql_query($sql); echo ""; } else{ echo ""; } } function sel_chapter(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM chapter"); return $sql; } function sl_chapter($a){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM chapter Where code='$a'")); return $sql; } function titby_yr(){ extract($_REQUEST); $sql= mysql_query("SELECT * FROM chapter WHERE Year='$yr'"); return $sql; } function chapter(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM chapter WHERE subject='$subid'"); return $sql; } function chapter1(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM chapter WHERE subject='$subj'"); return $sql; } function sub_chap(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM chapter WHERE subject='$subjq' and year='$year'"); return $sql; } function sub_chap1(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM chapter WHERE subject='$subjf' and year='$year'"); return $sql; } function up_cha_stat(){ extract($_REQUEST); $sql=mysql_query("UPDATE chapter SET Status='$stat' WHERE id='$id'"); echo ""; } /* function chapby_id(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM chapter WHERE id='$tit'")); return $sql; }*/ /* function chapby_id1(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM chapter WHERE id='$title'")); return $sql; }*/ function chap_id(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM chapter WHERE code='$id'")); return $sql; } function chapby_id(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM chapter WHERE code='$title'")); return $sql; } function chapby_id1(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM chapter WHERE code='$title'")); return $sql; } function chapby_code($a){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM chapter WHERE code='$a'")); return $sql; } function chap_filter(){ extract ($_REQUEST); $sql=mysql_query("SELECT * FROM chapter WHERE subject='$subj' and year='$fyr'"); return $sql; } function up_title(){ extract($_REQUEST); if($_FILES['attach']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/Lesson/".$img1); } else{ $img1=$_REQUEST['oldimg']; } $sql=mysql_query("UPDATE chapter SET chapter='$upsub',discription='$dis',attach='$img1',serial='$upserial' WHERE code='$title'"); echo ""; } function del_tit(){ extract($_REQUEST); $sql=mysql_query("DELETE FROM chapter WHERE id='$id'"); echo ""; } /*------------------ CHAPTER QUERY END------------------------------*/ /*------------------ Nurse Grouping QUERY END------------------------------*/ function sel_group(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM nur_groups WHERE spl_code='$id' and level='$level'"); return $sql; } function ins_group(){ extract($_REQUEST); $exe=implode(",",$exam); //$tt=implode(",",$title); mysql_query("INSERT INTO nur_groups (`spl_code`, `tit_code`, title ,`g_no`, `level`) VALUES ('$id','$exe', '$tt','$set','$lev')"); header('Location:specialization_new.php?id='.$id.'&level='.$lev.''); } function no_grpquestion(){ extract($_REQUEST); $im=implode(",",$s); $im2=implode(",",$ss); mysql_query( "UPDATE nur_groups SET exam_1='$im',exam_2='$im2' WHERE Id='$gid'"); } /*------------------ Nurse Grouping QUERY END------------------------------*/ /*------------------ QUESTION QUERY START------------------------------*/ /* function add_question(){ extract($_REQUEST); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='c';} elseif($crt_ans=='4'){$ans='D';} $sql="INSERT INTO question (Subid,Categry,Question,A,B,C,D,Answer,Reason) VALUES ('$id', '$category','$editor1','$a','$b','$c','$d','$ans','$reason')"; $qry=mysql_query($sql); }*/ function add_nonobject(){ extract($_REQUEST); $quest=mysql_real_escape_string($quest);$ans=mysql_real_escape_string($ans); $quest1=mysql_real_escape_string($quest1);$ans1=mysql_real_escape_string($ans1); $quest2=mysql_real_escape_string($quest2);$ans2=mysql_real_escape_string($ans2); $quest3=mysql_real_escape_string($quest3);$ans3=mysql_real_escape_string($ans3); $quest4=mysql_real_escape_string($quest4);$ans4=mysql_real_escape_string($ans4); $ans5=mysql_real_escape_string($ans5); $ans6=mysql_real_escape_string($ans6); $ans7=mysql_real_escape_string($ans7); $ans8=mysql_real_escape_string($ans8); $ans9=mysql_real_escape_string($ans9); $title2; if(!empty($title1)){ $img_ex1=implode(',',$title1); } if(!empty($title2)){ $img_ex2=implode(',',$title2); } if(!empty($title3)){ $img_ex3=implode(',',$title3); } if(!empty($title4)){ $img_ex4=implode(',',$title4); } if(!empty($title5)){ $img_ex5=implode(',',$title5); } if(!empty($title6)){ $img_ex6=implode(',',$title6); } if(!empty($title7)){ $img_ex7=implode(',',$title7); } if(!empty($title8)){ $img_ex8=implode(',',$title8); } if(!empty($title9)){ $img_ex9=implode(',',$title9); } if(!empty($title10)){ $img_ex10=implode(',',$title10); } $sql="INSERT INTO std_nonobjective (qus_code,subid,title_id,question,answer,ans1,ans2,ans3,ans4,ans5,ans6,ans7,ans8,ans9,ans10, categry,uniq,img1,img2,img3,img4,img5,img6,img7,img8,img9,img10) VALUES('$code','$subj','$title','$quest','$ans','$ans0','$ans1','$ans2','$ans3','$ans4','$ans5','$ans6','$ans7','$ans8','$ans9','$cate','$nos','$img_ex1','$img_ex2','$img_ex3','$img_ex4','$img_ex5','$img_ex6','$img_ex7','$img_ex8','$img_ex9','$img_ex10')"; $qry=mysql_query($sql); echo ""; } function add_nonobject1(){ extract($_REQUEST); $quest=mysql_real_escape_string($quest);$ans=mysql_real_escape_string($ans); $quest1=mysql_real_escape_string($quest1);$ans1=mysql_real_escape_string($ans1); $quest2=mysql_real_escape_string($quest2);$ans2=mysql_real_escape_string($ans2); $quest3=mysql_real_escape_string($quest3);$ans3=mysql_real_escape_string($ans3); $quest4=mysql_real_escape_string($quest4);$ans4=mysql_real_escape_string($ans4); $ans5=mysql_real_escape_string($ans5); $ans6=mysql_real_escape_string($ans6); $ans7=mysql_real_escape_string($ans7); $ans8=mysql_real_escape_string($ans8); $ans9=mysql_real_escape_string($ans9); $title2; if(!empty($title1)){ $img_ex1=implode(',',$title1); } if(!empty($title2)){ $img_ex2=implode(',',$title2); } if(!empty($title3)){ $img_ex3=implode(',',$title3); } if(!empty($title4)){ $img_ex4=implode(',',$title4); } if(!empty($title5)){ $img_ex5=implode(',',$title5); } if(!empty($title6)){ $img_ex6=implode(',',$title6); } if(!empty($title7)){ $img_ex7=implode(',',$title7); } if(!empty($title8)){ $img_ex8=implode(',',$title8); } if(!empty($title9)){ $img_ex9=implode(',',$title9); } if(!empty($title10)){ $img_ex10=implode(',',$title10); } $sql="INSERT INTO std_nonobjective (qus_code,subid,title_id,question,answer,ans1,ans2,ans3,ans4,ans5,ans6,ans7,ans8,ans9,ans10, categry,uniq,img1,img2,img3,img4,img5,img6,img7,img8,img9,img10) VALUES('$code','$subj','$title','$quest','$ans','$ans0','$ans1','$ans2','$ans3','$ans4','$ans5','$ans6','$ans7','$ans8','$ans9','$cate','$nos','$img_ex1','$img_ex2','$img_ex3','$img_ex4','$img_ex5','$img_ex6','$img_ex7','$img_ex8','$img_ex9','$img_ex10')"; $qry=mysql_query($sql); //echo ""; } function add_question(){ extract($_REQUEST); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} $quest=mysql_real_escape_string($quest); $a=mysql_real_escape_string($a); $b=mysql_real_escape_string($b); $c=mysql_real_escape_string($c); $d=mysql_real_escape_string($d); $ans=mysql_real_escape_string($ans); $reason=mysql_real_escape_string($reason); $sql="INSERT INTO question (Sub_ids,Subid,Code,Categry,Question,A,B,C,D,Answer,Reason,Uniq) VALUES ('$subj','$title','$code','$category','$quest','$a','$b','$c','$d','$ans','$reason','$nos')"; $qry=mysql_query($sql); echo ""; } function add_question1(){ extract($_REQUEST); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} $quest=mysql_real_escape_string($quest); $a=mysql_real_escape_string($a); $b=mysql_real_escape_string($b); $c=mysql_real_escape_string($c); $d=mysql_real_escape_string($d); $ans=mysql_real_escape_string($ans); $reason=mysql_real_escape_string($reason); $sql="INSERT INTO question (Sub_ids,Subid,Code,Categry,Question,A,B,C,D,Answer,Reason,Uniq) VALUES ('$subj','$title','$code','$category','$quest','$a','$b','$c','$d','$ans','$reason','$nos')"; $qry=mysql_query($sql); echo ""; } function qusby_code(){ extract($_REQUEST); $fet=mysql_fetch_assoc(mysql_query("SELECT MAX(Uniq) FROM question WHERE Subid='$title' and Categry='$category'")); return $fet; } function nonobjby_code(){ extract($_REQUEST); $fet=mysql_fetch_assoc(mysql_query("SELECT MAX(Uniq) FROM std_nonobjective WHERE title_id='$title' and categry='$qus_type' ")); return $fet; } function question(){ extract($_REQUEST); $sql="SELECT * FROM question WHERE Subid='$id' and Categry='$cate' LIMIT 1"; $fet=mysql_query($sql); return $fet; } function allnonobjective(){ extract($_REQUEST); $sql="SELECT * FROM std_nonobjective WHERE title_id='$type' and categry='$qus_type' "; $fet=mysql_query($sql); return $fet; } function allqus(){ extract($_REQUEST); $sql="SELECT * FROM question WHERE Subid='$tit' and Categry='$cat'"; $fet=mysql_query($sql); return $fet; } function nonobject_id(){ extract($_REQUEST); $sql="SELECT * FROM std_nonobjective WHERE id='$id1'"; $fet=mysql_fetch_assoc(mysql_query($sql)); return $fet; } function nonobject_title(){ extract($_REQUEST); $sql="SELECT * FROM std_nonobjective WHERE title_id='$title' and categry='$qus_type'"; $fet=mysql_query($sql); return $fet; } function qusby_id(){ extract($_REQUEST); $sql="SELECT * FROM question WHERE Id='$id'"; $fet=mysql_fetch_assoc(mysql_query($sql)); return $fet; } function update_nonessay(){ extract($_REQUEST); $quest=mysql_real_escape_string($quest); $ans=mysql_real_escape_string($ans); /* $title1= preg_replace('/^([^,]*).*$/', '$1', $title1); foreach($title1 as $tit){ $tite[]=preg_replace('/^([^,]*).*$/', '$1', $tit); }*/ $img_ex1=implode(',',$title1); if($img_ex1=="0,0,0") { $img1_up=$img1_hideen; } else { $img1_up=$img_ex1; } $sql="UPDATE std_nonobjective SET question='$quest',answer='$ans',img1='$img1_up' where id='$id' "; $res=mysql_query($sql); echo ""; } function update_nonobject(){ extract($_REQUEST); $quest=mysql_real_escape_string($quest); $ans0=mysql_real_escape_string($ans0); $ans1=mysql_real_escape_string($ans1); $ans2=mysql_real_escape_string($ans2); $ans3=mysql_real_escape_string($ans3); $ans4=mysql_real_escape_string($ans4); $ans5=mysql_real_escape_string($ans5); $ans6=mysql_real_escape_string($ans6); $ans7=mysql_real_escape_string($ans7); $ans8=mysql_real_escape_string($ans8); $ans9=mysql_real_escape_string($ans9); $img_ex1=implode(',',$title1); if($img_ex1=="0,0,0") { $img1_up=$img1_hideen; } else { $img1_up=$img_ex1; } $img_ex2=implode(',',$title2); if($img_ex2=="0,0,0") { $img2_up=$img2_hideen; } else { $img2_up=$img_ex2; } $img_ex3=implode(',',$title3); if($img_ex3=="0,0,0") { $img3_up=$img3_hideen; } else { $img3_up=$img_ex3; } $img_ex4=implode(',',$title4); if($img_ex4=="0,0,0") { $img4_up=$img4_hideen; } else { $img4_up=$img_ex4; } $img_ex5=implode(',',$title5); if($img_ex5=="0,0,0") { $img5_up=$img5_hideen; } else { $img5_up=$img_ex5; } $img_ex6=implode(',',$title6); if($img_ex6=="0,0,0") { $img6_up=$img6_hideen; } else { $img6_up=$img_ex6; } $img_ex7=implode(',',$title7); if($img_ex7=="0,0,0") { $img7_up=$img7_hideen; } else { $img7_up=$img_ex7; } $img_ex8=implode(',',$title8); if($img_ex8=="0,0,0") { $img8_up=$img8_hideen; } else { $img8_up=$img_ex8; } $img_ex9=implode(',',$title9); if($img_ex9=="0,0,0") { $img9_up=$img9_hideen; } else { $img9_up=$img_ex9; } $img_ex10=implode(',',$title10); if($img_ex10=="0,0,0") { $img10_up=$img10_hideen; } else { $img10_up=$img_ex10; } /*$sql="UPDATE std_nonobjective SET question='$quest', answer='$ans',stat1='$quest0',ans1='$ans0',stat2='$quest1',ans2='$ans1',stat3='$quest2',ans3='$ans2',stat4='$stat3',ans4='$ans3',stat5='$stat4',ans5='$ans4',images='$imp' WHERE id='$id1'";*/ // echo "UPDATE std_nonobjective SET question='$quest',ans1='$ans0',ans2='$ans1',ans3='$ans2',ans4='$ans3',ans5='$ans4',ans6='$ans5',ans7='$ans6',ans8='$ans7',ans9='$ans8',ans10='$ans9',img1='$img1_up', img2='$img2_up',img3='$img3_up',img4='$img4_up',img5='$img5_up',img6='$img6_up',img7='$img7_up',img8='$img8_up',img9='$img9_up',img10='$img10_up' WHERE id='$id1'"; $sql="UPDATE std_nonobjective SET question='$quest',ans1='$ans0',ans2='$ans1',ans3='$ans2',ans4='$ans3',ans5='$ans4',ans6='$ans5',ans7='$ans6',ans8='$ans7',ans9='$ans8',ans10='$ans9',img1='$img1_up', img2='$img2_up',img3='$img3_up',img4='$img4_up',img5='$img5_up',img6='$img6_up',img7='$img7_up',img8='$img8_up',img9='$img9_up',img10='$img10_up' WHERE id='$id1'"; /*echo "UPDATE std_nonobjective SET question='$quest', answer='$ans',stat1='$quest0',ans1='$ans0',stat2='$quest1',ans2='$ans1',stat3='$quest2',ans3='$ans2',stat4='$quest3',ans4='$ans3',images='$img1_up',img1='$img1_up', img2='$img2_up',img3='$img3_up',img4='$img4_up' WHERE id='$id1'"; */ $res=mysql_query($sql); if($re=="qus"){ echo ""; } else{ echo ""; } } function update_qus(){ extract($_REQUEST); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} $quest=mysql_real_escape_string($quest); $a=mysql_real_escape_string($a); $b=mysql_real_escape_string($b); $c=mysql_real_escape_string($c); $d=mysql_real_escape_string($d); $ans=mysql_real_escape_string($ans); $reason=mysql_real_escape_string($reason); $sql="UPDATE question SET Question='$quest',A='$a',B='$b',C='$c',D='$d',Answer='$ans',Reason='$reason' WHERE Id='$id'"; $res=mysql_query($sql); if($re=="qus"){ echo ""; } else{ echo ""; } } function del_nonobject(){ extract($_REQUEST); $deld="DELETE FROM std_nonobjective WHERE id='$id1'"; $qry=mysql_query($deld); if($re=="qus"){ echo ""; }else{ echo ""; } } function indu_nonqus($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM std_nonobjective WHERE id='$a'")); return $sql; } function del_qus(){ extract($_REQUEST); $deld="DELETE FROM question WHERE Id='$id'"; $qry=mysql_query($deld); if($re=="qus"){ echo ""; } else{ echo ""; } } function question_all(){ extract($_REQUEST); $sql="SELECT * FROM question WHERE Subid='$title' and Categry ='$category'"; $fet=mysql_query($sql); return $fet; } /*------------------ QUESTION QUERY END------------------------------*/ /*------------------------ Practice Test Result Start -----------------------------------------*/ function practice_ans_demo(){ extract($_REQUEST); if($answer==$selans){ $crt=1; } else{ $crt=0; } $time=180-$tim; $ans="INSERT INTO practicetest_result (`subid`,`les_id`, `cat`, `sett`, `attempt`, `qus_id`, `userid`, `answer`, `givenanswer`, `status`, `time`) Values ('$suid','$id','$cate','$set','$at','$qusid','".$_SESSION['sid']."','$answer','$selans','$crt','$time' )"; $sql=mysql_query($ans); $qs=mysql_fetch_assoc(mysql_query("SELECT * FROM question Where Id='$qusid'")); if($answer==$selans){ $res1=$qs['result1']+1; $res2=$qs['result2']+1; $res3=$qs['result3']+1; } else{ $res1=$qs['result1']; $res2=$qs['result2']; $res3=$qs['result3']; } if($at=='1'){ $atte=$qs['attend1']+1; $up=mysql_query("UPDATE question SET attend1='$atte',result1='$res1' WHERE Id='$qusid'"); } if($at=='2'){ $atte=$qs['attend2']+1; $up=mysql_query("UPDATE question SET attend2='$atte',result2='$res2' WHERE Id='$qusid'"); } if($at=='3'){ $atte=$qs['attend3']+1; $up=mysql_query("UPDATE question SET attend3='$atte',result3='$res3' WHERE Id='$qusid'"); } if($lit<=9){ header('Location:practice_test_demo.php?id='.$id.'&lit='.$lit.'&cate='.$cate.'&set='.$set.'&st='.$st.'&at='.$at.'&subj='.$subj.''); } else{ $cnt=mysql_num_rows(mysql_query("SELECT * FROM practicetest_result WHERE userid='".$_SESSION['sid']."' and status='1'")); $atmp=mysql_query("INSERT INTO practice_result (`lesid`, `cat`, `sett`, `mark`, `atempt`, `userid`) Values ('$id','$cate','$set','$cnt','$at','".$_SESSION['sid']."')"); header('Location:demo-result.php?at='.$at.'&cate='.$cate.'&subj='.$subj.'&id='.$id.''); } } function practice_ans(){ extract($_REQUEST); if($answer==$selans){ $crt=1; } else{ $crt=0; } $time=180-$tim; $ans="INSERT INTO practicetest_result (`subid`,`les_id`, `cat`, `sett`, `attempt`, `qus_id`, `userid`, `answer`, `givenanswer`, `status`, `time`) Values ('$suid','$id','$cate','$set','$at','$qusid','".$_SESSION['sid']."','$answer','$selans','$crt','$time' )"; $sql=mysql_query($ans); $qs=mysql_fetch_assoc(mysql_query("SELECT * FROM question Where Id='$qusid'")); if($answer==$selans){ $res1=$qs['result1']+1; $res2=$qs['result2']+1; $res3=$qs['result3']+1; } else{ $res1=$qs['result1']; $res2=$qs['result2']; $res3=$qs['result3']; } if($at=='1'){ $atte=$qs['attend1']+1; $up=mysql_query("UPDATE question SET attend1='$atte',result1='$res1' WHERE Id='$qusid'"); } if($at=='2'){ $atte=$qs['attend2']+1; $up=mysql_query("UPDATE question SET attend2='$atte',result2='$res2' WHERE Id='$qusid'"); } if($at=='3'){ $atte=$qs['attend3']+1; $up=mysql_query("UPDATE question SET attend3='$atte',result3='$res3' WHERE Id='$qusid'"); } if($lit<=19){ header('Location:practice_test.php?id='.$id.'&lit='.$lit.'&cate='.$cate.'&set='.$set.'&st='.$st.'&at='.$at.'&subj='.$subj.''); } else{ $cnt=mysql_num_rows(mysql_query("SELECT * FROM practicetest_result WHERE userid='".$_SESSION['sid']."' and status='1'")); $atmp=mysql_query("INSERT INTO practice_result (`lesid`, `cat`, `sett`, `mark`, `atempt`, `userid`) Values ('$id','$cate','$set','$cnt','$at','".$_SESSION['sid']."')"); header('Location:result.php?at='.$at.'&cate='.$cate.'&subj='.$subj.'&id='.$id.''); } } function practice_result(){ extract($_REQUEST); $sel=mysql_query("SELECT * FROM practicetest_result WHERE userid='".$_SESSION['sid']."'"); return $sel; } function pra_crt_result(){ extract($_REQUEST); $sel=mysql_num_rows(mysql_query("SELECT * FROM practicetest_result WHERE userid='".$_SESSION['sid']."' and status='1'")); return $sel; } function test_restart(){ $cnt=mysql_num_rows(mysql_query("SELECT * FROM practicetest_result WHERE userid='".$_SESSION['sid']."'")); return $cnt; } function nur_restart(){ extract($_REQUEST); $cnt=mysql_num_rows(mysql_query("SELECT * FROM nur_practicetestresult WHERE Userid='".$_SESSION['sid']."' and Modid='$id'")); return $cnt; } /* function test_stqus(){ $qus=mysql_fetch_assoc(mysql_query("SELECT * FROM practicetest_result WHERE userid='".$_SESSION['sid']."' order by id desc limit 1")); return $qus; }*/ function test_stqus(){ extract($_REQUEST); $qus=mysql_fetch_assoc(mysql_query("SELECT * FROM practicetest_result WHERE userid='".$_SESSION['sid']."' and les_id='$id' and cat='$cate' order by id desc limit 1")); return $qus; } function nurtest_stqus($a){ extract($_REQUEST); $qus=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_practicetestresult WHERE Userid='".$_SESSION['sid']."' and Modid='$id' and Cat='$a' order by id desc limit 1")); return $qus; } function restart(){ extract($_REQUEST); $sel=mysql_num_rows(mysql_query("SELECT * FROM practicetest_result WHERE userid='".$_SESSION['sid']."' and les_id='$id' and cat='$cate'")); return $sel; } function prac_nurans(){ extract($_REQUEST); if($answer==$selans){ $crt=1; } else{ $crt=0; } $time=180-$tim; $sql="INSERT INTO nur_practicetestresult (`Splid`, `Modid`, `Cat`, `Sett`, `Attempt`, `Qus_id`, `Userid`, `Answer`, `Given_ans`, `Status`, `Time`) values('$spl','$module','$cate','$set','$at','$qusid','".$_SESSION['sid']."','$answer','$selans','$crt','$time')"; $ex=mysql_query($sql); $qs=mysql_fetch_assoc(mysql_query("SELECT * FROM question Where Id='$qusid'")); if($answer==$selans){ $res1=$qs['result1']+1; $res2=$qs['result2']+1; $res3=$qs['result3']+1; } else{ $res1=$qs['result1']; $res2=$qs['result2']; $res3=$qs['result3']; } if($at=='1'){ $atte=$qs['attend1']+1; $up=mysql_query("UPDATE nur_question SET attend1='$atte',result1='$res1' WHERE Id='$qusid'"); } if($at=='2'){ $atte=$qs['attend2']+1; $up=mysql_query("UPDATE nur_question SET attend2='$atte',result2='$res2' WHERE Id='$qusid'"); } if($at=='3'){ $atte=$qs['attend3']+1; $up=mysql_query("UPDATE nur_question SET attend3='$atte',result3='$res3' WHERE Id='$qusid'"); } if($lit<=19){ header('Location:practice_test.php?id='.$id.'&lit='.$lit.'&cate='.$cate.'&set='.$set.'&st='.$st.'&at='.$at.'&mod_id='.$N_moid.'&ret='.$N_ret.'&mid='.$N_mid); } else{ // $cnt=mysql_num_rows(mysql_query("SELECT * FROM nur_practicetestresult WHERE Userid='".$_SESSION['sid']."' and status='1'")); $cnt=mysql_num_rows(mysql_query("SELECT * FROM nur_practicetestresult WHERE Userid='".$_SESSION['sid']."' and Modid='$module' and Cat='$cate' and Sett='$set' and Attempt='$at' and status='1'")); $atmp="INSERT INTO nur_practiceresult (`Mod_id`, `Cat`, `Sett`, `Mark`, `Attempt`, `Userid`) VALUES ('$module','$cate','$set','$cnt','$at','".$_SESSION['sid']."')"; mysql_query($atmp); header('Location:practice_result.php?at='.$at.'&cate='.$cate.'&id='.$id.'&set='.$set.'&crtans='.$cnt.'&mod_id='.$_REQUEST['mod_id'].'&mid='.$_REQUEST['mid'].''); } } function nurpractice_result(){ extract($_REQUEST); $sel=mysql_query("SELECT * FROM nur_practicetestresult WHERE Userid='".$_SESSION['sid']."'"); return $sel; } function nurpra_res(){ extract($_REQUEST); $sel=mysql_query("SELECT * FROM nur_practicetestresult WHERE Userid='".$_SESSION['sid']."' and Modid='$id' and Cat='$cate' and Sett='$set'"); return $sel; } /*------------------------ Practice Test Result End -----------------------------------------*/ /*------------------ Temp Result QUERY START------------------------------*/ function temp_ans(){ extract($_REQUEST); if($answer==$selans){ $crt=1; } else{ $crt=0; } $ans="INSERT INTO temptest (user_id,ques_id,answer,given_ans,correct) Values ('".$_SESSION['Id']."','$qusid','$answer','$selans','$crt')"; $sql=mysql_query($ans); $li=$lit+1; if($li<=19){ echo ""; } else{ echo ""; } } function temp_ans_demo(){ extract($_REQUEST); if($answer==$selans){ $crt=1; } else{ $crt=0; } $tak=180-$time_taken; $ans="INSERT INTO temptest (user_id,ques_id,answer,given_ans,correct,time) Values ('".$_SESSION['Id']."','$qusid','$answer','$selans','$crt','$tak')"; $sql=mysql_query($ans) or die(mysql_error()); echo $li=$lit+1; $qus_cnt; if($li<5){ header('Location:test_demo.php?ques_id='.$ques_id.'&lit='.$lit.'&id1='.$_REQUEST['id1'].''); echo ""; } else{ $ct=mysql_num_rows(mysql_query("SELECT * FROM nur_demoresult WHERE User_id='".$_SESSION['sid']."' and Spl_id='$id'")); if($ct!=0){ mysql_query("UPDATE nur_demoresult SET Attemt='2' WHERE User_id='".$_SESSION['sid']."' and Spl_id='$id'"); } else{ mysql_query("INSERT INTO nur_demoresult (`User_id`, `Spl_id`, `Attemt`) VALUES ('".$_SESSION['sid']."','$id','1')"); } header('Location:result.php?res=done&spl='.$id1.''); } } function sel_nurdemo($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_demoresult WHERE User_id='".$_SESSION['sid']."' and Spl_id='$a'")); return $sql; } function result(){ extract($_REQUEST); $sel=mysql_query("SELECT * FROM temptest WHERE user_id='".$_SESSION['Id']."'"); return $sel; } function crt_result(){ extract($_REQUEST); $sel=mysql_num_rows(mysql_query("SELECT * FROM temptest WHERE user_id='".$_SESSION['Id']."' and correct='1'")); return $sel; } function clear(){ extract($_REQUEST); $del=mysql_query("DELETE FROM temptest WHERE user_id='$id'"); echo ""; } function clear1(){ extract($_REQUEST); $del=mysql_query("DELETE FROM temptest WHERE user_id='".$_SESSION['Id']."'"); echo ""; } /*------------------ Temp Result QUERY END------------------------------*/ /*----------------- Specialization QUERY START -------------*/ function specialization(){ extract($_REQUEST); $sel=mysql_num_rows(mysql_query("SELECT * FROM nur_specialization WHERE code='$splcode'")); if($sel=='0') { if($_FILES['attach']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/Speciality/".$img1); } $sql=mysql_query(" INSERT INTO nur_specialization (code,special,no,status,description,attach,seo_key,seo_title,seo_disc,cne_point) VALUES ('$splcode','$spl','$no','1','$desc','$img1','$seo_key','$seo_title','$seo_dec','$seo_count_add')"); echo ""; } else{ echo ""; } } function sel_special(){ $sql=mysql_query("SELECT * FROM nur_specialization where status!='0' order by no ASC"); return $sql; } function sel_special_alls(){ $sql=mysql_query("SELECT * FROM nur_specialization order by no ASC"); return $sql; } function sel_spl($a){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_specialization WHERE code='$a'")); return $sql; } function sel_splbycode($a){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM nur_specialization WHERE code='$a'"); return $sql; } function specialby_id(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_specialization where code='$spl'")); return $sql; } function specialby_id1(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_specialization where code='$spl1'")); return $sql; } function nurs_dec(){ extract($_REQUEST); //echo "SELECT * FROM nur_specialization where code='".$_REQUEST['id']."'"; $sql=mysql_query("SELECT * FROM nur_specialization where code='".$_REQUEST['id']."'"); return $sql; } function up_specialization(){ extract($_REQUEST); if($_FILES['attach']['size']>0) { chmod("../image/Speciality/".$_REQUEST['oldimg']."", 0750); $r=unlink("../image/Speciality/".$_REQUEST['oldimg'].""); if($r==1){ echo "suc"; }else{ echo "fail"; } $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/Speciality/".$img1); } else{ //echo "243124254"; $img1=$_REQUEST['oldimg']; } $sql=mysql_query("UPDATE nur_specialization SET special='$upspl',no='$no',description='$desc',attach='$img1',seo_key='$seo_key',seo_title='$seo_title',seo_disc='$seo_dec',cne_point='$seo_count' WHERE code='$spl'"); //echo ""; } function specialization_stat(){ extract($_REQUEST); $sql=mysql_query("UPDATE nur_specialization SET status='$stat' WHERE id='$id'"); echo ""; } function del_spl(){ extract($_REQUEST); $sql=mysql_query("DELETE FROM nur_specialization WHERE id='$id'"); echo ""; } /*----------------- Specialization QUERY END -------------*/ /*-------------------- Nurse Title QUERY START -------------------------*/ function nurse_title(){ extract($_REQUEST); $selw=mysql_num_rows(mysql_query("SELECT * FROM nur_title WHERE code='$chapcode'")); if($selw=='0') { if($_FILES['attach']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/Module/".$img1); } if($_FILES['attach1']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach1']['tmp_name']; $img2=$uniqueid.$_FILES['attach1']['name']; move_uploaded_file($tempfile,"../image/Module/".$img2); } $sql=mysql_query("INSERT INTO nur_title (spl,code,title,discription,attach,image,status,no,seo_module_key,seo_module_title,seo_module_desc,module_practise,module_qa) VALUES ('$spl','$chapcode','$nurtitle','$dis','$img1','$img2','1','$no','$seo_mod_key','$seo_mod_title','$seo_mod_dis','$module_practise','$module_qa')"); echo ""; } else{ echo ""; } } function sel_nurtit(){ $sql=mysql_query("SELECT * FROM nur_title"); return $sql; } function sel_tit($a){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_title WHERE code='$a'")); return $sql; } function nur_special($id){ extract($_REQUEST); //$sql="SELECT * FROM nur_title WHERE spl='$id' order by no Asc"; $sql=mysql_query("SELECT * FROM nur_title WHERE spl='$id' order by no Asc"); return $sql; } function sel_nurtitindu(){ extract($_REQUEST); $ex=explode('^',$id); $sql=mysql_query("SELECT * FROM nur_title WHERE spl='".$ex['0']."'"); return $sql; } function up_stat(){ extract($_REQUEST); $sql=mysql_query("UPDATE nur_title SET status='$stat' Where id='$id'"); echo ""; } function sel_nurtitindu1(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM nur_title WHERE spl='$id1'"); return $sql; } /*function nurtitleby_id(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_title WHERE id='$mod'")); return $sql; }*/ function nurtitleby_id(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_title WHERE code='$nur_tit'")); return $sql; } /*function nurtitleby_id1(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_title WHERE id='$nur_tit'")); return $sql; }*/ function nurtitleby_id1(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_title WHERE code='$nur_tit'")); return $sql; } function nurtitleby_code($a){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_title WHERE code='$a'")); return $sql; } function up_nurchap(){ extract($_REQUEST); if($_FILES['attach']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/Module/".$img1); } else{ $img1=$_REQUEST['oldimg']; } if($_FILES['attach1']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach1']['tmp_name']; $img2=$uniqueid.$_FILES['attach1']['name']; move_uploaded_file($tempfile,"../image/Module/".$img2); } else{ $img2=$_REQUEST['oldimg1']; } $upmod=mysql_real_escape_string($upmod); $dis=mysql_real_escape_string($dis); $module_seo_key=mysql_real_escape_string($module_seo_key); $module_seo_title=mysql_real_escape_string($module_seo_title); $module_seo_dic=mysql_real_escape_string($module_seo_dic); $module_practise_update=mysql_real_escape_string($module_practise_update); $module_qa_update=mysql_real_escape_string($module_qa_update); $qa=mysql_real_escape_string($qa); $sql=mysql_query("UPDATE nur_title SET title='$upmod',no='$no',discription='$dis',attach='$img1',image='$img2',seo_module_key='$module_seo_key', seo_module_title='$module_seo_title',seo_module_desc='$module_seo_dic',module_practise='$module_practise_update',module_qa='$module_qa_update',Sn_dec='$qa' WHERE code='$nur_tit'") or die(mysql_error()); echo ""; } function del_mod(){ extract($_REQUEST); $sql=mysql_query("DELETE FROM nur_title WHERE id='$id'"); echo ""; } function spl_nurtit($a){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM nur_title WHERE spl='$a'"); return $sql; } function on_exam(){ extract($_REQUEST); foreach($exam as $ex){ mysql_query("UPDATE nur_title SET $lev='$set' WHERE id='$ex'"); } header('Location:specialization.php?id='.$id.'&level='.$lev.''); } function no_question(){ extract($_REQUEST); foreach($tit as $j){ //$ss=implode(",",${"s".$j}); mysql_query("UPDATE nur_title SET $lev='${"s".$j}' where code='$j'"); } } function no_finalquestion(){ extract($_REQUEST); foreach($tit as $j){ mysql_query("UPDATE nur_title SET $lev1='${"s".$j}',$lev2='${"ss".$j}' where code='$j'"); } header('Location:gruops.php?id='.$id.'&Final='.$Final.''); } function sel_demomod($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_title WHERE title='$a'")); return $sql; } /*-------------------- Nurse Title QUERY END -------------------------*/ /*-------------------- Nurse Quetion QUERY START -------------------------*/ function nur_question(){ extract($_REQUEST); $qus=implode("~",$qust1); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} if($category!='Short Answer'){ $qus=mysql_real_escape_string($qus); $ans=mysql_real_escape_string($ans); $reason1=mysql_real_escape_string($reason1); $a=mysql_real_escape_string($a); $b=mysql_real_escape_string($b); $c=mysql_real_escape_string($c); $d=mysql_real_escape_string($d); $sql="INSERT INTO nur_question (spl_id,qus_code,title_id,category,question,A,B,C,D,answer,reason,uniq) VALUES ('$spl','$cod','$nur_tit', '$category','$qus','$a','$b','$c','$d','$ans','$reason1','$nos')"; } else{ $saqus=mysql_real_escape_string($saqus); $answer=mysql_real_escape_string($answer); $sql="INSERT INTO nur_nonobjective (spl_id,qus_code,title_id,question,answer,uniq) VALUES ('$spl','$cod','$nur_tit', '$saqus','$answer','$nos')"; } $qry=mysql_query($sql); echo ""; } function nur_question1(){ extract($_REQUEST); $qus=implode("~",$qust1); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} if($category=='Easy'){$cat='E';} elseif($category=='Medium'){$cat='M';} elseif($category=='Hard'){$cat='H';} if($category!='Short Answer'){ $qus=mysql_real_escape_string($qus); $ans=mysql_real_escape_string($ans); $reason1=mysql_real_escape_string($reason1); $a=mysql_real_escape_string($a); $b=mysql_real_escape_string($b); $c=mysql_real_escape_string($c); $d=mysql_real_escape_string($d); $sql="INSERT INTO nur_question (spl_id,qus_code,title_id,category,question,A,B,C,D,answer,reason,uniq) VALUES ('$spl','$cod','$nur_tit', '$category','$qus','$a','$b','$c','$d','$ans','$reason1','$nos')"; } else{ $saqus=mysql_real_escape_string($saqus); $answer=mysql_real_escape_string($answer); $sql="INSERT INTO nur_nonobjective (spl_id,qus_code,title_id,question,answer,uniq) VALUES ('$spl','$cod','$nur_tit', '$saqus','$answer','$nos')"; } $qry=mysql_query($sql); echo ""; } function nur_qussel(){ extract($_REQUEST); $sql="SELECT * FROM nur_question WHERE title_id='$id' LIMIT 1"; $fet=mysql_query($sql); return $fet; } function nur_qus_count(){ extract($_REQUEST); $sql="SELECT * FROM nur_question WHERE spl_id='$id' and title_id LIKE '%GEN%'"; $fet=mysql_query($sql); $num=mysql_num_rows($fet); return $num; } function nur_qussel_demo($a,$b){ extract($_REQUEST); $sql="SELECT * FROM nur_question WHERE title_id='$a' and category='$b' ORDER BY rand() LIMIT 1"; //$sql="SELECT * FROM nur_question WHERE spl_id='$ques_id' ORDER BY rand() LIMIT 5"; $fet=mysql_query($sql); return $fet; } function nurallqus(){ extract($_REQUEST); $sql="SELECT * FROM nur_question WHERE title_id='$mod' and category='$cat'"; $fet=mysql_query($sql); return $fet; } function nurqusby_id(){ extract($_REQUEST); $sql="SELECT * FROM nur_question WHERE id='$id'"; $fet=mysql_fetch_assoc(mysql_query($sql)); return $fet; } function nurqusby_code(){ extract($_REQUEST); $fet=mysql_fetch_assoc(mysql_query("SELECT MAX(uniq) FROM nur_question WHERE title_id='$nur_tit' and category='$category'")); return $fet; } function del_nurqus(){ extract($_REQUEST); $del=mysql_query("DELETE FROM nur_question WHERE id='$id'"); if($re=="qus"){ echo ""; } else{ echo ""; } } function del_nonnurqus($a){ extract($_REQUEST); $del=mysql_query("DELETE FROM nur_nonobjective WHERE id='$a'"); if($re=="qus"){ echo ""; } else{ echo ""; } } function update_nurqus(){ extract($_REQUEST); $qus=implode("~",$quest); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} $qus=mysql_real_escape_string($qus); $ans=mysql_real_escape_string($ans); $reason=mysql_real_escape_string($reason); $a=mysql_real_escape_string($a); $b=mysql_real_escape_string($b); $c=mysql_real_escape_string($c); $d=mysql_real_escape_string($d); $sql="UPDATE nur_question SET question='$qus',A='$a',B='$b',C='$c',D='$d',answer='$ans',reason='$reason' WHERE id='$id'"; $res=mysql_query($sql); if($re=="qus"){ echo ""; } else{ echo ""; }} function nur_questionall(){ extract($_REQUEST); if($category!="Short Answer"){ $sel=mysql_query("SELECT * FROM nur_question WHERE title_id='$nur_tit' and category='$category'"); } else{ $sel=mysql_query("SELECT * FROM nur_nonobjective WHERE title_id='$nur_tit'"); } return $sel; } function nurindu_quss($a){ //$sql="SELECT * FROM nur_question WHERE id='$a'"; $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_nonobjective WHERE id='$a' ")); return $sql; } function nurindu_quss_ques($a){ //echo $sql="SELECT * FROM nur_question WHERE id='$a'"; $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_question WHERE id='$a' ")); return $sql; } /*-------------------- Nurse Quetion QUERY END -------------------------*/ /*------------------ Scenario Qurey Start---------------------------------------------------*/ function add_scenario(){ extract($_REQUEST); $ins="INSERT INTO scenario ( spl_code,title,question,answer) VALUES ('$code','$title','$quest','$ans')"; mysql_query($ins); echo""; } function scenarioby_code(){ extract($_REQUEST); $sel=mysql_query("SELECT * FROM scenario WHERE spl_code='$spl1'"); return $sel; } function scenarioby_id(){ extract($_REQUEST); $sel=mysql_fetch_assoc(mysql_query("SELECT * FROM scenario WHERE id='$id'")); return $sel; } function scenario_update(){ extract($_REQUEST); $up="UPDATE scenario SET question='$quest',answer='$ans',title='$title'"; mysql_query($up); echo " "; } function scenario_del(){ extract($_REQUEST); $del=mysql_query("DELETE FROM scenario WHERE id='$id'"); echo " "; } /*------------------ Scenario Qurey End---------------------------------------------------*/ /*----------------------------- Front End Start--------------------------------------------------------*/ /*------------------Student Page------*/ function sel_stddet(){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM admin WHERE Id='".$_SESSION['sid']."'")); return $sql; } function sel_yrsub($a){ //echo $sql="SELECT * FROM subject WHERE Year='$a'"; $sql=mysql_query("SELECT * FROM subject WHERE Year='$a'") ; return $sql; } function stddet(){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM studentdetail WHERE std_id='".$_SESSION['sid']."'")); return $sql; } /*----------------------------- Front End --------------------------------------------------------*/ /*------------------ SME Start -------------------------*/ function sme_ad(){ extract($_REQUEST); $cnt=mysql_fetch_assoc(mysql_query("SELECT * FROM admin WHERE Userid='".$_SESSION['Id']."'")); return $cnt; } function ins_sme(){ extract($_REQUEST); $cnt=mysql_num_rows(mysql_query("SELECT * FROM admin WHERE Userid='$mailid'")); if($cnt!='0'){ echo ""; } else{ $pas=rand(000000,999999); $sql=mysql_query("INSERT INTO admin (Name,Userid,Password,Mobileno,Status) VALUES ('$name','$mailid','$pas','$mob','4')")or die(mysql_error()); /*------------- Mail ------------*/ $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $to = $mailid; // Send email to our user $subject = 'Signup | Verification'; // Give the email a subject $message .= "
hi $name,
Congrats You are now SME for Healthcareskill Course. Your Userid and password given below here is your Link
User ID : $mailid.
Password : $pas.
"; $headers .= 'From:Healthcare.com' . "\r\n"; mail($to, $subject, $message, $headers); //echo $message ; //echo $to; $sql=mysql_query("INSERT INTO sme (Sme_id,Team_ltr,Name) VALUES ('$mailid','$teamltr','$name')"); echo ""; } } function sel_adsme(){ $sql=mysql_query("SELECT * FROM admin WHERE Status='4'"); return $sql; } function sel_smemb($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT Mobileno FROM admin Where Userid='$a'")); return $sql; } function sel_adsmeidu(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM admin WHERE Userid='$id'")); return $sql; } function sel_allsme(){ $sql=mysql_query("SELECT * FROM sme") or die(mysql_error()); return $sql; } function sme_mail(){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM sme where Sme_id='".$_SESSION['Id']."'")); return $sql; } function sel_sme_id(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM sme where Sme_id='$id'"))or die(mysql_error()); return $sql; } function assign_topics(){ extract($_REQUEST); $cnt=count($right); if($chs=='1') { $less=implode("^",$right); for($i=0;$i<$cnt;$i++){ $sel=mysql_num_rows(mysql_query("SELECT * FROM assigned_topic WHERE Les='$right[$i]' and Sme_id='$id' ")); if($sel=='0'){ $sql="INSERT INTO assigned_topic (Sme_id,Year,Sub,Les,Team_ltr,Type) VALUES ('$id','$year','$subj','$right[$i]','".$_SESSION['Id']."','$chs')"; mysql_query($sql) or die(mysql_error()); }} echo " "; } if($chs=='2') { $mod=implode("^",$right); for($i=0;$i<$cnt;$i++){ $sel=mysql_num_rows(mysql_query("SELECT * FROM assigned_topic WHERE Module='$right[$i]' and Sme_id='$id'")); if($sel=='0'){ $sql="INSERT INTO assigned_topic (Sme_id,Spl,Module,Team_ltr,Type) VALUES ('$id','$spl','$right[$i]','".$_SESSION['Id']."','$chs')"; mysql_query($sql) or die(mysql_error()); }} echo " "; } } function chap_filter1(){ extract ($_REQUEST); $sql=mysql_query("SELECT * FROM chapter WHERE subject='$subj' and year='$yr'"); return $sql; } function sel_ses(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM assigned_topic WHERE Sme_id='".$_SESSION['Id']."' and Status='1'"); return $sql; } function sel_assign(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM assigned_topic WHERE Sme_id='$id'"); return $sql; } function view_assign(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM assigned_topic WHERE Sme_id='$id' and Status='1'"); return $sql; } function view_assignfil(){ extract($_REQUEST); $sql=mysql_query("SELECT DISTINCT(Sub) FROM assigned_topic WHERE Sme_id='$id' and Status='1'"); return $sql; } function view_assignfi2($a){ extract($_REQUEST); $sql=mysql_query("SELECT DISTINCT(serial) FROM chapter Where subject='$a'"); return $sql; } function sel_assign_apprl(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM assigned_topic WHERE Team_ltr='".$_SESSION['Id']."' and Status!='1'"); return $sql; } function admin_approval(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM assigned_topic WHERE Status='0'"); return $sql; } function sel_assignqus($a){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM assigned_topic WHERE Sme_id='$id' and Les='$a' and Sub='$sub'")); return $sql; } function up_assign(){ extract($_REQUEST); $sql=mysql_query("UPDATE assigned_topic SET L1='$L1',L2='$L2',L3='$L3',Sa='$SA',Sn='$Sn',Es='$Es',Deadline='$dead' WHERE Id='$sid'"); if($chs=='1'){ echo " "; } if($chs=='2'){ echo " "; } } function up_L1(){ extract($_REQUEST); $sql=mysql_query("UPDATE assigned_topic SET L1='$L1' WHERE Id='$sid'"); if($chs=='1'){ echo " "; } if($chs=='2'){ echo " "; } } function up_L2(){ extract($_REQUEST); $sql=mysql_query("UPDATE assigned_topic SET L2='$L2' WHERE Id='$sid' "); if($chs=='1'){ echo " "; } if($chs=='2'){ echo " "; } } function up_L3(){ extract($_REQUEST); $sql=mysql_query("UPDATE assigned_topic SET L3='$L3' WHERE Id='$sid' "); if($chs=='1'){ echo " "; } if($chs=='2'){ echo " "; } } function up_SA(){ extract($_REQUEST); $sql=mysql_query("UPDATE assigned_topic SET Sa='$SA' WHERE Id='$sid' "); echo " "; } function up_SN(){ extract($_REQUEST); $sql=mysql_query("UPDATE assigned_topic SET Sn='$SN' WHERE Id='$sid' "); echo " "; } function up_ES(){ extract($_REQUEST); $sql=mysql_query("UPDATE assigned_topic SET Es='$ES' WHERE Id='$sid' "); echo " "; } function sel_qusid($a){ extract($_REQUEST); $sql=mysql_query("SELECT Type,SUM(Qus) AS type FROM sme_qus WHERE Les_id='$a' and Sme_id='".$_SESSION['Id']."' group by Type"); return $sql; } function sel_qus($a){ extract($_REQUEST); $sql=mysql_query("SELECT Type,SUM(Qus) AS type FROM sme_qus WHERE Les_id='$a' and Sme_id='$id' group by Type"); return $sql; } function add_smeqs(){ extract($_REQUEST); if($_FILES['attach']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/Sme/".$img1); } $sql=mysql_query("INSERT INTO sme_qus (Sme_id,Les_id,Type,Qus,Ans) VALUES ('".$_SESSION['Id']."','$Lid','$type','$qus','$img1')") or die(mysql_error()); echo " "; } function sel_top(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM assigned_topic WHERE Id='$Lid'")); return $sql; } function sel_smequs(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM sme_qus WHERE Sme_id='".$_SESSION['Id']."' and Type='$type' and Les_id='$Lid' "); return $sql; } function sel_smequsid(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM sme_qus WHERE Sme_id='$id' and Type='$type' and Les_id='$Lid'"); return $sql; } function sel_smequsbyid(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM sme_qus WHERE Id='$id'")); return $sql; } function qus_up(){ extract($_REQUEST); $sql=mysql_query("UPDATE assigned_topic SET Status='$states' WHERE Id='$sid'"); echo " "; } function sel_sme(){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * , a.Id AS sid, b.Id AS aid FROM sme a JOIN admin b ON sme.Sme_id = admin.Userid where Sme_id='$id'")); return $sql; } function up_sme(){ extract($_REQUEST); $sql=mysql_query("UPDATE sme SET Addrs='$add',Qual='$qual',Exp='$exp',Pos='$pos' WHERE Sme_id='".$_SESSION['Id']."'"); echo " "; } function up_smepas(){ extract($_REQUEST); $sql=mysql_query("UPDATE admin SET Password='$new' WHERE Userid='".$_SESSION['Id']."'"); echo " "; } function del_smequs(){ extract($_REQUEST); $sql=mysql_query("DELETE FROM sme_qus WHERE Id='$Delid'"); echo " "; } function update_smequs(){ extract($_REQUEST); if($_FILES['attach']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/Sme/".$img1); } $sql=mysql_query("UPDATE sme_qus SET Qus='$qus',Ans='$img1' WHERE Id='$id' ") or die(mysql_error()); echo " "; } function teamsub($a){ extract($_REQUEST); $sql=mysql_query("SELECT distinct(Sub) FROM assigned_topic WHERE Team_ltr='$a'"); return $sql; } /*------------------ SME End -------------------------*/ /*------------- TEAM LEADER Start-------------*/ function ins_teamltr(){ extract($_REQUEST); $cnt=mysql_num_rows(mysql_query("SELECT * FROM admin WHERE Userid='$mailid'")); if($cnt!='0'){ echo ""; } else{ $pas=rand(000000,999999); $sql=mysql_query("INSERT INTO admin (Name,Userid,Password,Mobileno,Status) VALUES ('$name','$mailid','$pas','$mob','5')")or die(mysql_error()); /*------------- Mail ------------*/ $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $to = $mailid; // Send email to our user $subject = 'Signup | Verification'; // Give the email a subject $message .= "
hi $name,
Congrats You are now TeamLeader for Healthcareskill Course. Your Userid and password given below here is your Link
User ID : $mailid.
Password : $pas.
"; $headers .= 'From:Healthcare.com' . "\r\n"; mail($to, $subject, $message, $headers); //echo $message ; //echo $to; echo ""; } } function sel_teamltr(){ $sql=mysql_query("SELECT * FROM admin where Status='5'"); return $sql; } function sme_list($a){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM sme Where Team_ltr='$a'"); return $sql; } function teamltr_name($a){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM admin where Userid='$a'")); return $sql; } function del_asstopic(){ extract($_REQUEST); $sql=mysql_query("DELETE FROM assigned_topic WHERE Id='$delid'"); echo ""; } function team_title(){ extract($_REQUEST); $srt=mysql_query("SELECT * FROM nur_title WHERE spl='$spl'"); return $srt; } function up_pass(){ extract($_REQUEST); $sql=mysql_query("UPDATE admin SET Password='$new' Where Userid='".$_SESSION['Id']."'")or die(mysql_error()); } /*------------- TEAM LEADER End-------------*/ /*---------- Tags Start ----------*/ function sel_tag($q){ $sql=mysql_num_rows(mysql_query("select * From mytag where qusid='$q' and userid='".$_SESSION['sid']."'")); return $sql; } /*function tag(){ $sql="SELECT a.Sub_ids,c.Subject,count(a.Categry) as cnt,d.categry from question as a inner join mytag as b on a.Id=b.qusid inner join subject as c on a.Sub_ids=c.Code inner join std_nonobjective as d on b.qusid=d.id WHERE b.userid='".$_SESSION['sid']."' group by a.Sub_ids"; $row=mysql_query($sql); return $row; }*/ function tag(){ $sql="SELECT a.subid, COUNT( case when a.categry='Level 1' then a.categry end ) as cnt1, COUNT( case when a.categry='Level 2' then a.categry end ) as cnt2 , COUNT( case when a.categry='Level 3' then a.categry end ) as cnt3 , COUNT( case when a.categry='Short Answer' then a.categry end ) as cnt4 , COUNT( case when a.categry='Short Note' then a.categry end ) as cnt5 , COUNT( case when a.categry='Essay' then a.categry end ) as cnt6 , a.categry,b.Subject from mytag as a inner join subject as b on a.subid=b.Code WHERE userid ='2' GROUP BY a.subid"; $qry=mysql_query($sql); return $qry; } function tagby_cat($cat){ extract($_REQUEST); if($cat=='Level 1' || $cat=='Level 2' || $cat=='Level 3'){ $sql="SELECT a.Question,a.Answer,a.Reason,b.qusid FROM question as a inner join mytag as b on a.Id=b.qusid where b.userid='".$_SESSION['sid']."' and b.categry='$cat'"; } else{ $sql="SELECT a.question,a.answer,b.qusid FROM std_nonobjective as a inner join mytag as b on a.id=b.qusid where b.userid='".$_SESSION['sid']."' and b.categry='$cat'"; } $qry=mysql_query($sql); return $qry; } function tagby_sub(){ $sql="SELECT * from question as a inner join mytag as b on a.Id=b.qusid inner join chapter as c on a.Subid=c.code WHERE b.userid='".$_SESSION['sid']."'"; $row=mysql_query($sql); return $row; } function tag_remove($a){ $sql=mysql_query("DELETE from mytag WHERE qusid='$a'"); } /*---------- Tags End ----------*/ /*---------- Final Exam Start ----------*/ function sel_finalexam($a,$b,$c){ //$no=$b."_no"; //$sql=mysql_query("SELECT code as co,$no as no from nur_title WHERE spl='$c' and $b='$a'"); $sql=mysql_query("SELECT code as co,$b as no from nur_title WHERE spl='$c'"); $cntqry=mysql_query("SELECT * from nur_group_result where Spl_code='$c' and Level='$b' and `Group`='$a' and User_id='".$_SESSION['sid']."'"); /* if(!$cntqry){ $cnt=0; }else{ $cnt=1; }*/ if($b=='L1'){$level='Level 1';}elseif($b=='L2'){ $level='Level 2'; }elseif($b=='L3'){ $level='Level 3'; } while($res=mysql_fetch_assoc($sql)){ $noti=explode(",",$res['no']); //echo "SELECT id FROM nur_question where title_id='".$res['co']."' and category='$level' ORDER BY RAND() limit $noti[$cnt]"; $question=mysql_query("SELECT id FROM nur_question where title_id='".$res['co']."' and `category`='$level' ORDER BY RAND() limit ".$res['no'].""); //mysql_fetch_assoc($question) or die(mysql_error()); while($qs=mysql_fetch_assoc($question)){ $all[]=$qs; }} /*foreach($all as $al){ $aaa[]=$al['id']; }*/ //print_r($all); return $all; //print_r($aaa); //$qcode=implode(",",$aaa); //mysql_query("INSERT INTO nur_groupq (`User_id`, `Spl_code`, `Level`, `Group`, `Qus_no`)VALUES('".$_SESSION['sid']."','$c','$level','$a','$qcode')"); } function grp_result(){ extract($_REQUEST); mysql_query("INSERT INTO cne_group_result (`User_id`, `Spl_code`, `Level`, `Group`, `Answer`) VALUES ('".$_SESSION['sid']."','$id','$fina','$fi','$ansr')"); } function cne_grp_result(){ extract($_REQUEST); if($id=='DEM017') { $fina='Demo'; mysql_query("INSERT INTO cne_group_result (`User_id`, `Spl_code`, `Level`, `Group`, `Answer`) VALUES ('".$_SESSION['sid']."','$id','$fina','$fi','$ansr')"); } else { mysql_query("INSERT INTO cne_group_result (`User_id`, `Spl_code`, `Level`, `Group`, `Answer`) VALUES ('".$_SESSION['sid']."','$id','$fina','$fi','$ansr')"); } } function test_cont($a,$b,$c){ $cntqry=mysql_query("SELECT * from nur_group_result where Spl_code='$c' and Level='$b' and `Group`='$a' and User_id='".$_SESSION['sid']."'"); return $cntqry; } function chart_final($a,$b){ $cntqry=mysql_query("SELECT * from nur_group_result where Spl_code='$a' and Level='$b' and User_id='".$_SESSION['sid']."'"); return $cntqry; } function chart_final_alllv($a){ $cntqry=mysql_query("SELECT * from nur_group_result where Spl_code='$a' and User_id='".$_SESSION['sid']."'"); return $cntqry; } function chart_finallv($a){ $cntqry=mysql_query("SELECT * from nur_group_result where Spl_code='$a' and User_id='".$_SESSION['sid']."'"); return $cntqry; } function module_list(){ $sql=mysql_query("SELECT * FROM nur_title where spl='".$_REQUEST['id']."'"); return $sql; } function module_dec(){ $sql=mysql_query("SELECT * FROM nur_specialization where code='".$_REQUEST['id']."'"); return $sql; } /*cne question proess*/ function module_question_list(){ $sql="SELECT * FROM nur_title where spl='".$_REQUEST['ques_id']."'"; $qry=mysql_query($sql); return $qry; } function cne_menu_add(){ $sql="SELECT * FROM nur_specialization where code ='".$_REQUEST['ques_id']."'"; $qry=mysql_query($sql); return $qry; } function module_keyword(){ //$sql="SELECT * FROM nur_title where code='".$_REQUEST['id']."'"; $sql=mysql_query("SELECT * FROM nur_title where code='".$_REQUEST['id']."'"); return $sql; } function std_subject(){ //echo $sql="SELECT * FROM subject WHERE Year='".$_REQUEST['id']."'"; $sql=mysql_query("SELECT * FROM subject WHERE Year='".$_REQUEST['id']."'") ; return $sql; } function update_nurnonobj(){ extract($_REQUEST); $quest= mysql_real_escape_string($quest); $ans= mysql_real_escape_string($ans); $sql=mysql_query("UPDATE nur_nonobjective SET question='$quest',answer='$ans' WHERE id='$id'"); header('Location:view_nurquestion.php'); } function nurnonindu_quss($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_nonobjective WHERE id='$a'")); return $sql; } function mytag_nurs(){ $sql=mysql_query("SELECT * FROM mytag where userid='".$_SESSION['sid']."' group by subid"); return $sql; } /*function mytag_nurs(){ $sql=mysql_query("SELECT * FROM mytag group by subid"); return $sql; }*/ function module_address(){ //$sql="SELECT * FROM nur_title where code='".$_REQUEST['id']."'"; $sql=mysql_query("SELECT * FROM subject where Code='".$_REQUEST['subj']."'"); return $sql; } /*---------- Final Exam End ----------*/ /*---------------- Nurse Package-------------------------*/ function add_pack(){ extract($_REQUEST); $imp=implode('`',$spl); $sql="INSERT INTO package (`Name`, `Price`, `Duration`, `Discount`, `Pack`) VALUES ('$pnm','$prc','$dur','$nrm','$imp')"; mysql_query($sql); } function sel_pack(){ $sql=mysql_query("SELECT * FROM package"); return $sql; } function indu_pack($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM package where Id='$a'")); return $sql; } function del_pack($a){ mysql_query("DELETE FROM package where Id='$a'"); } function up_pack($a){ extract($_REQUEST); $imp=implode('`',$spl); mysql_query("UPDATE package SET Name='$pnm',Price='$prc',Duration='$dur',Pack='$imp',Discount='$nrm' where Id='$a'"); } function sel_upack($a){ $sql=mysql_query("SELECT * FROM package where Id IN({$a})"); return $sql; } /*---------------- Order Details-------------------------*/ function sel_order(){ $sql=mysql_query("SELECT * FROM orderdetails"); return $sql; } function sel_induorder(){ $sql=mysql_query("SELECT * FROM orderdetails WHERE User_id='".$_SESSION['sid']."' and Status='APPROVED'"); return $sql; } function sel_stdnur(){ $sql=mysql_query("SELECT * FROM admin where Status='2' or Status='3'"); return $sql; } /*---------------- CNE Section-----------------*/ function add_cnemod(){ extract($_REQUEST); if($_FILES['attach']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/CNE/".$img1); } if($_FILES['attach1']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['attach1']['tmp_name']; $img2=$uniqueid.$_FILES['attach1']['name']; move_uploaded_file($tempfile,"../image/CNE/".$img2); } $sql=mysql_query("INSERT INTO cne (`Code`, `Module`, `Description`, `Attach`, `Image`, `Seo_key`, `Seo_title`, `Seo_des`, `Status`, `No`) VALUES ('$chapcode','$nurtitle','$dis','$img1','$img2','$seo_mod_key','$seo_mod_title','$seo_mod_dis','1','$no')") or die(mysql_error()); } function sel_allcne(){ $sql=mysql_query("SELECT * FROM cne"); return $sql; } function indu_cne($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne WHERE Id='$a'")); return $sql; } function del_cne($a){ $sql=mysql_query("DELETE FROM cne WHERE Id='$a'"); } function up_cnestat($a,$b){ $sql=mysql_query("UPDATE cne SET Status='$b' WHERE Id='$a'") or die(mysql_error()); header('Location:cne_module.php?add=view'); } function up_cne($a){ extract($_REQUEST); if($_FILES['attach']['size']>0){ $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/CNE/".$img1); } else{ $img1=$_REQUEST['oldimg']; } if($_FILES['attach1']['size']>0){ $uniqueid=time(); $tempfile=$_FILES['attach1']['tmp_name']; $img2=$uniqueid.$_FILES['attach1']['name']; move_uploaded_file($tempfile,"../image/CNE/".$img2); } else{ $img2=$_REQUEST['oldimg1']; } $sql=mysql_query("UPDATE cne SET Module='".mysql_real_escape_string($upmod)."',Description='".mysql_real_escape_string($dis)."',Attach='$img1',Image='$img2',Seo_key='".mysql_real_escape_string($seo_key)."',Seo_title='".mysql_real_escape_string($seo_title)."', Seo_des='".mysql_real_escape_string($seo_dic)."',No='$no',Practice='".mysql_real_escape_string($practise)."', QA='".mysql_real_escape_string($qa)."' where Id='$a'"); } function add_cnepack(){ extract($_REQUEST); $sel=mysql_num_rows(mysql_query("SELECT * FROM cne_package WHERE State='$state'")); if($sel==0){ if($_FILES['attach']['size']>0){ $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/States/".$img1); } if($pts!=""){$pts=array_filter($pts);}if($amt!=""){ $amt=array_filter($amt);}if($dis!=""){ $dis=array_filter($dis);}if($amt!=""){ $vali=array_filter($vali);} $imp=implode(",",$mdu); $imp1=implode(",",$pts); $imp2=implode(",",$amt); $imp3=implode(",",$dis); $imp4=implode(",",$vali); $sql=mysql_query("INSERT INTO cne_package (`name`,`State`, `Module`,`Points`,`Price`,`Dis_price`,`Vality`,`Image`,`percentage`) VALUES ('$boardname','$state','$imp','$imp1','$imp2','$imp3','$imp4','$img1','$percentage')") or die(mysql_error()); } else{ header('Location:cne_package.php?msg=err'); } } function cnepack_last(){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne_package order by Id DESC")); return $sql; } function up_cnepts(){ extract($_REQUEST); $imp=implode('`',$pts); $sql=mysql_query("UPDATE cne_package SET Points='$imp' WHERE Id='$pid'"); } function all_cnepack(){ $sql=mysql_query("SELECT * FROM cne_package"); return $sql; } function st_cne($a){ $sql=mysql_query("SELECT * FROM `cne_package` WHERE FIND_IN_SET( $a,`Module` )"); return $sql; } function indu_cnepack($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne_package WHERE Id='$a'")); return $sql; } function cnepack_del($a){ mysql_query("DELETE FROM cne_package WHERE Id='$a'"); header('Location:view_cnepack.php'); } function up_cnepack(){ extract($_REQUEST); if($_FILES['attach']['size']>0){ $uniqueid=time(); $tempfile=$_FILES['attach']['tmp_name']; $img1=$uniqueid.$_FILES['attach']['name']; move_uploaded_file($tempfile,"../image/States/".$img1); } else{ $img1=$_REQUEST['oldimg']; } if($pts!=""){$pts=array_filter($pts);}if($amt!=""){ $amt=array_filter($amt);}if($dis!=""){ $dis=array_filter($dis);}if($amt!=""){ $vali=array_filter($vali);} $imp=implode(",",$mdu); $imp1=implode(",",$pts); $imp2=implode(",",$amt); $imp3=implode(",",$dis); $imp4=implode(",",$vali); mysql_query("UPDATE cne_package SET Module='$imp',Points='$imp1',Price='$imp2',Dis_price='$imp3',Vality='$imp4',Image='$img1',percentage='$percentage',name='$boardname' WHERE Id='$pid'"); header('Location:view_cnepack.php'); } function indu_cnemod($a){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne WHERE Code='$a'")); return $sql; } function cne_question(){ extract($_REQUEST); $ans=mysql_real_escape_string($ans); $reason1=mysql_real_escape_string($reason1); $a=mysql_real_escape_string($a); $b=mysql_real_escape_string($b); $c=mysql_real_escape_string($c); $d=mysql_real_escape_string($d); $qus=implode("~",$qust1); $qus=mysql_real_escape_string($qus); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} if($category!='Short Answer'){ $sql="INSERT INTO cne_question (qus_code,title_id,category,question,A,B,C,D,answer,reason,uniq) VALUES ('$cod','$spl', '$category','$qus','$a','$b','$c','$d','$ans','$reason1','$nos')"; } else{ $saqus=mysql_real_escape_string($saqus); $answer=mysql_real_escape_string($answer); $sql="INSERT INTO cne_nonobjective (Qus_code,Module_id,Question,Answer,Uniq) VALUES ('$cod','$spl', '$saqus','$answer','$nos')"; } $qry=mysql_query($sql)or die(mysql_error()); echo ""; } function cne_question1(){ extract($_REQUEST); $ans=mysql_real_escape_string($ans); $reason1=mysql_real_escape_string($reason1); $a=mysql_real_escape_string($a); $b=mysql_real_escape_string($b); $c=mysql_real_escape_string($c); $d=mysql_real_escape_string($d); $qus=implode("~",$qust1); $qus=mysql_real_escape_string($qus); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} if($category=='Easy'){$cat='E';} elseif($category=='Medium'){$cat='M';} elseif($category=='Hard'){$cat='H';} if($category!='Short Answer'){ $sql="INSERT INTO cne_question (qus_code,title_id,category,question,A,B,C,D,answer,reason,uniq) VALUES ('$cod','$spl', '$category','$qus','$a','$b','$c','$d','$ans','$reason1','$nos')"; } else{ $saqus=mysql_real_escape_string($saqus); $answer=mysql_real_escape_string($answer); $sql="INSERT INTO cne_nonobjective (Qus_code,Module_id,Question,Answer,Uniq) VALUES ('$cod','$spl', '$saqus','$answer','$nos')"; } $qry=mysql_query($sql)or die(mysql_error()); echo ""; } function cnequsby_code(){ extract($_REQUEST); $fet=mysql_fetch_assoc(mysql_query("SELECT MAX(uniq) FROM cne_question WHERE title_id='$spl' and category='$category'")); return $fet; } function cne_questionall(){ extract($_REQUEST); if($category!="Short Answer"){ $sel=mysql_query("SELECT * FROM cne_question WHERE title_id='$spl' and category='$category'"); } else{ $sel=mysql_query("SELECT * FROM cne_nonobjective WHERE Module_id='$spl'"); } return $sel; } function cnequsby_id(){ extract($_REQUEST); $sql="SELECT * FROM cne_question WHERE id='$id'"; $fet=mysql_fetch_assoc(mysql_query($sql)); return $fet; } function update_cnequs(){ extract($_REQUEST); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} $quest=mysql_real_escape_string($quest); $reason=mysql_real_escape_string($reason); $a=mysql_real_escape_string($a); $b=mysql_real_escape_string($b); $c=mysql_real_escape_string($c); $d=mysql_real_escape_string($d); $sql="UPDATE cne_question SET question='$quest',A='$a',B='$b',C='$c',D='$d',answer='$ans',reason='$reason' WHERE id='$id'"; $res=mysql_query($sql); if($re=="qus"){ echo ""; } else{ echo ""; }} function del_cnequs(){ extract($_REQUEST); $del=mysql_query("DELETE FROM cne_question WHERE id='$id'"); if($re=="qus"){ echo ""; } } function cnenonindu_quss($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne_nonobjective WHERE Id='$a'")); return $sql; } function update_cnenonobj(){ extract($_REQUEST); $quest=mysql_real_escape_string($quest); $ans=mysql_real_escape_string($ans); $sql=mysql_query("UPDATE cne_nonobjective SET Question='$quest',Answer='$ans' WHERE Id='$id'"); header('Location:view_cnequestion.php'); } /*----------------------CNE FROM RAJA---------------------------*/ function cne_bycode($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne WHERE Code='$a'")); return $sql; } function cne_byslug($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne WHERE ViewURL='$a'")); return $sql; } function nurse_bycode($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_title WHERE Code='$a'")); return $sql; } function nurse_mod_bycode($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM nur_specialization WHERE Code='$a'")); return $sql; } function cne_res(){ extract($_REQUEST); $sel=mysql_query("SELECT * FROM cne_practicetestresult WHERE Userid='".$_SESSION['sid']."' and Modid='$id' and Cat='$cate' and Sett='$set'"); return $sel; } function cne_dec(){ extract($_REQUEST); //echo "SELECT * FROM nur_specialization where code='".$_REQUEST['id']."'"; $sql=mysql_query("SELECT * FROM cne where Code='".$_REQUEST['id']."'"); return $sql; } function cne_specia($id){ extract($_REQUEST); //$sql="SELECT * FROM nur_title WHERE spl='$id' order by no Asc"; $sql=mysql_query("SELECT * FROM cne WHERE Code='$id' order by No Asc"); return $sql; } function cne_login(){ extract($_REQUEST); $sql=mysql_query("SELECT * FROM admin WHERE Userid='$username' and Password='$password' and Status='6' "); $res=mysql_fetch_assoc($sql); return $res; } function cne_logout(){ extract($_REQUEST); $sqlstlog=mysql_fetch_assoc(mysql_query("SELECT * FROM admin WHERE cne_id='".$_SESSION['sid']."'")); return $sqlstlog; } function cne_detail(){ extract($_REQUEST); $sqlst=mysql_fetch_assoc(mysql_query("SELECT * FROM cne_details WHERE cne_id='".$_SESSION['sid']."'")); return $sqlst; } function update_cne_profile(){ extract($_REQUEST); if($_FILES['cne_img']['size']>0) { $uniqueid=time(); $tempfile=$_FILES['cne_img']['tmp_name']; $img1=$uniqueid.$_FILES['cne_img']['name']; move_uploaded_file($tempfile,"../CNE/cne_images/".$img1); }else{ $img1=$_REQUEST['old_img']; } $sql1=mysql_query("UPDATE admin SET Name='$nam', Mobileno='$mobile' where Id='".$_SESSION['sid']."'"); $sql=mysql_query("Update cne_details SET dob='$dob',address='$add_1',address2='$add_2',gender='$gender',city='$city',district='$dict',pincode='$pin',rn_number='$rn_number',image='$img1' ,mobile='$mobile',pan_no='$pan_no',adhar_no='$adhar_no' Where cne_id='".$_SESSION['sid']."'"); // echo ""; } function update1_cne(){ extract($_REQUEST); if($gnm=='gnm') { if(!empty($gnm1)){ $gnmdetails=implode('^',$gnm1); } } if($gnm=='pc'){ if(!empty($gnm2)){ $gnmdetails=implode('^',$gnm2); } if(!empty($pc1)){ $pcdetails=implode('^',$pc1);} } if($gnm=='bsc'){ if(!empty($bsc1)){ $bscdetails=implode('^',$bsc1);} } if($gnm=='msc'){ if(!empty($bsc2)){ $bscdetails=implode('^',$bsc2);} if(!empty($msc1)){ $mscdetails=implode('^',$msc1);} } if($gnm=='phd'){ if(!empty($msc2)){ $mscdetails=implode('^',$msc2);} if(!empty($phd1)){ $phddetails=implode('^',$phd1);} } $sql=mysql_query("Update cne_details SET GNM='$gnmdetails',PC='$pcdetails',BSc='$bscdetails',MSc='$mscdetails',PHd='$phddetails',rn_number='$rn_number',rm_number='$rm_number' Where cne_id='".$_SESSION['sid']."'") or die(mysql_error()); } function cne_exp(){ extract($_REQUEST); $horg=implode('^',$hsadd); $sql=mysql_query("Update cne_details SET Organization='$horg' Where cne_id='".$_SESSION['sid']."' ") or die(mysql_error()); } function cne_other(){ extract($_REQUEST); $sql="Update cne_details SET other='$other' Where cne_id='".$_SESSION['sid']."' "; $qry=mysql_query($sql) or die(mysql_error()); } function prac_cne(){ extract($_REQUEST); if($answer==$selans){ $crt=1; } else{ $crt=0; } $time=180-$tim; $sql="INSERT INTO cne_practicetestresult (`Splid`, `Modid`, `Cat`, `Sett`, `Attempt`, `Qus_id`, `Userid`, `Answer`, `Given_ans`, `Status`, `Time`) values('$spl','$module','$cate','$set','$at','$qusid','".$_SESSION['sid']."','$answer','$selans','$crt','$time')"; $ex=mysql_query($sql); $qs=mysql_fetch_assoc(mysql_query("SELECT * FROM cne_question Where id='$qusid'")); if($answer==$selans){ $res1=$qs['result1']+1; $res2=$qs['result2']+1; $res3=$qs['result3']+1; } else{ $res1=$qs['result1']; $res2=$qs['result2']; $res3=$qs['result3']; } if($at=='1'){ $atte=$qs['attend1']+1; $up=mysql_query("UPDATE cne_question SET attend1='$atte',result1='$res1' WHERE id='$qusid'"); } if($at=='2'){ $atte=$qs['attend2']+1; $up=mysql_query("UPDATE cne_question SET attend2='$atte',result2='$res2' WHERE id='$qusid'"); } if($at=='3'){ $atte=$qs['attend3']+1; $up=mysql_query("UPDATE cne_question SET attend3='$atte',result3='$res3' WHERE id='$qusid'"); } if($lit<=19){ header('Location:practice_test.php?id='.$id.'&lit='.$lit.'&cate='.$cate.'&set='.$set.'&st='.$st.'&at='.$at.''); } else{ // $cnt=mysql_num_rows(mysql_query("SELECT * FROM nur_practicetestresult WHERE Userid='".$_SESSION['sid']."' and status='1'")); $cnt=mysql_num_rows(mysql_query("SELECT * FROM cne_practicetestresult WHERE Userid='".$_SESSION['sid']."' and Modid='$module' and Cat='$cate' and Sett='$set' and Attempt='$at' and status='1'")); $atmp="INSERT INTO cne_practiceresult (`Mod_id`, `Cat`, `Sett`, `Mark`, `Attempt`, `Userid`) VALUES ('$module','$cate','$set','$cnt','$at','".$_SESSION['sid']."')"; mysql_query($atmp); header('Location:practice_result.php?at='.$at.'&cate='.$cate.'&id='.$id.'&set='.$set.'&crtans='.$cnt.''); } } function cne_special(){ $sql=mysql_query("SELECT * FROM cne where status!='0' order by no ASC"); return $sql; } function cne_tit($a){ extract($_REQUEST); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne WHERE Code='$a'")); return $sql; } function cne_quss($a){ //$sql="SELECT * FROM nur_question WHERE id='$a'"; $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne_nonobjective WHERE id='$a' ")); return $sql; } function cne_quss_ques($a){ //echo $sql="SELECT * FROM nur_question WHERE id='$a'"; $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne_question WHERE id='$a' ")); return $sql; } /*function cne_question(){ extract($_REQUEST); $qus=implode("~",$qust1); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} if($category!='Short Answer'){ $sql="INSERT INTO cne_question (qus_code,title_id,category,question,A,B,C,D,answer,reason,uniq) VALUES ('$cod','$spl', '$category','$qus','$a','$b','$c','$d','$ans','$reason1','$nos')"; } else{ $sql="INSERT INTO cne_nonobjective (qus_code,title_id,question,answer,uniq) VALUES ('$cod','$spl', '$saqus','$answer','$nos')"; } $qry=mysql_query($sql)or die(mysql_error()); echo ""; } function cne_question1(){ extract($_REQUEST); $qus=implode("~",$qust1); if($crt_ans=='1'){ $ans='A';} elseif($crt_ans=='2'){$ans='B';} elseif($crt_ans=='3'){$ans='C';} elseif($crt_ans=='4'){$ans='D';} if($category=='Easy'){$cat='E';} elseif($category=='Medium'){$cat='M';} elseif($category=='Hard'){$cat='H';} if($category!='Short Answer'){ $sql="INSERT INTO cne_question (qus_code,title_id,category,question,A,B,C,D,answer,reason,uniq) VALUES ('$cod','$spl', '$category','$qus','$a','$b','$c','$d','$ans','$reason1','$nos')"; } else{ $sql="INSERT INTO cne_nonobjective (qus_code,title_id,question,answer,uniq) VALUES ('$cod','$spl', '$saqus','$answer','$nos')"; } $qry=mysql_query($sql)or die(mysql_error()); echo ""; }*/ function cne_stqus($a){ extract($_REQUEST); $qus=mysql_fetch_assoc(mysql_query("SELECT * FROM cne_practicetestresult WHERE Userid='".$_SESSION['sid']."' and Modid='$id' and Cat='$a' order by id desc limit 1")); return $qus; } function cne_spl(){ extract($_REQUEST); // "SELECT * FROM cne WHERE Code='".$_REQUEST['id']."'"; $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM cne WHERE Code='".$_REQUEST['id']."'")); return $sql; } function cne_result(){ extract($_REQUEST); mysql_query("INSERT INTO nur_group_result (`User_id`, `Spl_code`, `Level`, `Group`, `Answer`) VALUES ('".$_SESSION['sid']."','$id','$fina','$fi','$ansr')"); } function nurse_result(){ extract($_REQUEST); mysql_query("INSERT INTO nur_group_result (`User_id`, `Spl_code`, `Level`, `Group`, `Answer`,`percentage`,`complete_date`) VALUES ('".$_SESSION['sid']."','$id','$fina','$fi','$ansr','$nur_precentage','$nur_comp_date')"); } /*--------------- States --------------*/ function all_states(){ $sql=mysql_query("SELECT * FROM states"); return $sql; } function state($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM states WHERE Id='$a'")); return $sql; } /*------------------ Marketing --------------------------*/ function add_marketing(){ extract($_REQUEST); if($status!=1){ $stss=implode('`',$state); } else{ $stss=$state; } mysql_query("INSERT INTO marketing (`Name`,`Mail_id`,`State`,`Password`,`Mobile`, `Pan`, `Account`, `Bank`, `Branch`, `Ifsc`,`Address`,`Dob`, `Qualification`,`Personal_id`,`Status`) VALUES ('$name','$mail','$stss','$pas','$mob','$pan','$acc','$bnk','$brc','$ifs','$addrss','$dob','$qul','$pei','$status')") or die(mysql_error()); } function sel_marketing(){ $sel=mysql_query("SELECT * FROM marketing WHERE Status='1'"); return $sel; } function sel_telecaller(){ $sel=mysql_query("SELECT * FROM marketing WHERE Status='2'"); return $sel; } function sel_telesupport(){ $sel=mysql_query("SELECT * FROM marketing WHERE (Status='3' or Status='4')"); return $sel; } function del_market($a){ mysql_query("DELETE FROM marketing WHERE Id='$a'"); } function indu_market($a){ $sel=mysql_fetch_assoc(mysql_query("SELECT * FROM marketing WHERE Id='$a'")); return $sel; } function up_marketing($a){ extract($_REQUEST); if($status!=1){ $imp=implode('`',$state); } else{ $imp=$state; } $sql=mysql_query("UPDATE marketing SET Name='$name',State='$imp',Password='$pas',Mobile='$mob',Pan='$pan',Account='$acc',Bank='$bnk',Branch='$brc', Ifsc='$ifs',Address='$addrss' WHERE Id='$a'")or die(mysql_error()); } function mark_login(){ extract($_REQUEST); $uname=mysql_real_escape_string($uname); $pass=mysql_real_escape_string($pass); $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM marketing where Mail_id='$uname' and Password='$pass'")); return $sql; } function add_cmt(){ extract($_REQUEST); if($type==3){ $qul=$qual1; } else{ $qul=$qual; } $cmt=mysql_real_escape_string($cmt); $sql=mysql_query("INSERT INTO query (`Type`, `Name`, `Qualification`, `Mail_id`, `Mobile_no`, `Pack`, `Comment`, `Status`, `Dates`,`Mid`,`State`,`Cmtby`) VALUES ('$type','$name','$qul','$mail','$mob','$pack','$cmt','$status',now(),'".$_SESSION['Sid']."','".$_SESSION['St']."','$cmtby')") or die(mysql_error()); } function industate_query(){ $sql=mysql_query("SELECT * FROM query WHERE Mid='".$_SESSION['Sid']."'")or die(mysql_error()); return $sql; } function ind_query($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM query WHERE Id='$a'")); return $sql; } function ind_cmt($a){ $sql=mysql_query("SELECT * FROM comments WHERE Qid='$a' and Cid='".$_SESSION['Sid']."' order by Dates DESC") or die(mysql_error()); return $sql; } function add_cmts(){ extract($_REQUEST); mysql_query("UPDATE query SET Status='$status' WHERE Id='$cid'") or die(mysql_error()); mysql_query("INSERT INTO comments (Qid,Cid,Comment,Dates,Cmtby) VALUES ('$cid','".$_SESSION['Sid']."','$cmt',now(),'$cmtby')"); } /*------------ Query section -------------*/ function sel_details($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM admin WHERE Id='$a'")); return $sql; } function tech_qry(){ extract($_REQUEST); $sql=mysql_query("INSERT INTO tech_qry (`User_id`, `Type`, `Comment`, `Dates`) VALUES ('".$_SESSION['sid']."','$type','$cmt',now())") or die(mysql_error()); } function techqry_indu($a){ $sql=mysql_fetch_assoc(mysql_query("SELECT * FROM tech_qry WHERE Id='$a'")); return $sql; } function techqry_user($a){ $sql=mysql_query("SELECT * FROM tech_qry WHERE User_id='$a'"); return $sql; } function techqry_cmt($a){ $sql=mysql_query("SELECT * FROM tech_cmt WHERE Qid='$a' order by Dates DESC"); return $sql; } function add_techcmts(){ extract($_REQUEST); mysql_query("INSERT INTO tech_cmt (`Qid`, `Comment`, `Cmtby`, `Dates`) VALUES ('$Qid','$cmt','$cmtby',now())"); if($status!=""){ mysql_query("UPDATE tech_qry SET Status='$status'"); } } function board_member_add() { extract($_REQUEST); mysql_query("INSERT INTO board_members (`state`, `board_name`,`destination` ,`contact_name`, `mobile1`,`mobile2`,`email`,`password`,`type`) VALUES ('$state','$bordname','$destination','$name','$mobile1','$mobile2','$email','$password','$typ')"); } function board_member_update() { extract($_REQUEST); mysql_query("update board_members set board_name='$bordname',contact_name='$name',mobile1='$mobile1',mobile2='$mobile2',password='$password',destination='$destination' where id='$id'"); } function del_board_member(){ extract($_REQUEST); mysql_query("DELETE FROM board_members WHERE id='$id'"); } function board_member_evaluater() { extract($_REQUEST); mysql_query("INSERT INTO board_members (`state`,`contact_name`, `email`,`password`,`type`) VALUES ('$state','$name','$email','$password','$typ')"); } function board_Evaluater_update() { extract($_REQUEST); mysql_query("update board_members set contact_name='$name',password='$password' where id='$id'"); } function mod_finqs(){ extract($_REQUEST); $imp=implode(",",$txt); mysql_query("UPDATE cne set $clm='$imp' WHERE Id='$id'"); } } ?>