File Manager

✏️ Edit File: /home/rla105zs937x/public_html/nimirnthunil.in/admin/class.php

<?php
	include_once("../config.php");
	
	if (isset($_POST['name']) && !empty($_POST["password"])) 
	{
		
		
		$name = trim($_POST['name']);   
		$password = base64_encode(base64_encode($_POST['password']));
		
		
			
			
			$query = mysqli_query( $conn,"select * from `admin` where `username`='".$name."' and `password` = '".$password."' ");
			
			$rowcount = mysqli_num_rows($query);  
			if($rowcount==1)
			{
				$log= mysqli_fetch_assoc($query);
				$_SESSION['user_id'] = $log['sno'];
				if($name=='admin')  
        		{
        			$_SESSION['login_type'] = 'Admin';
        		}
        		else
        		{
        			$_SESSION['login_type'] = 'Staff';
        		}
				echo '<script type="text/javascript">window.location.href="dashboard.php";</script>';	
				
			}
			else
			{
				echo '<script type="text/javascript">alert("username and password is wrong..!!!");window.location.href="index.php";</script>';
			}
			
				
	
	
		echo '<script type="text/javascript">;window.location.href="index.php";</script>';
		
	}
	
	// qus upload starts
	if(isset($_POST["upload"]))
	{
		$class=$_POST['class'];	
		$subject=$_POST['subject'];	
		$file = $_FILES['file']['tmp_name'];
		$handle = fopen($file, "r");
		if ($handle) {
			// Use $handle
			
			$c = 0;$p=0;
			while(($filesop = fgetcsv($handle, 1000, ",")) !== false)
			{
				$p++;
				if($p!=1)
				{
					if($filesop[0]!='')
					{
						$subject_code = $filesop[0];
						$sub_category =str_replace("'","",$filesop[2]);
						$sub_reference = str_replace("'","",$filesop[3]);
						$mode_ans = str_replace("'","",$filesop[4]);
						$options = str_replace("'","",$filesop[5]);
						$qus = str_replace("'","",$filesop[6]);
						$ans_a = str_replace("'","",$filesop[7]);
						$ans_b = str_replace("'","",$filesop[8]);
						$ans_c = str_replace("'","",$filesop[9]);
						$ans_d = str_replace("'","",$filesop[10]);
						$correct_ans = $filesop[11];
						$mode_qus = $filesop[12];
						$status = $filesop[13];
						
						//echo "INSERT INTO `qus_upload` (class, subject,subject_code,sub_subcategory,sub_reference,mode_qus,options,qus,ans_a,ans_b,ans_c,ans_d,crct_ansno,mode_qus,status) VALUES ('$class','$subject','$subject_code','$sub_category','$sub_reference','$mode_ans','$options','$qus','$ans_a','$ans_b','$ans_c','$ans_d','$correct_ans','','$status')";
						
						$sql = "INSERT INTO `qus_upload` (class, subject,subject_code,sub_subcategory,sub_reference,mode_ans,options,qus,ans_a,ans_b,ans_c,ans_d,crct_ansno,mode_qus,status) VALUES ('$class','$subject','$subject_code','$sub_category','$sub_reference','$mode_ans','$options','$qus','$ans_a','$ans_b','$ans_c','$ans_d','$correct_ans','$mode_qus','$status')";
						$c = $c + 1;
						
						
						$res=mysqli_query($conn,$sql) or  die('Error: ' . mysqli_error($conn));
					}
				}
			}
			if($res)
			{
				echo '<script type="text/javascript">alert("file Upload Successfully");window.location.href="qus_upload.php";</script>';
				
			}
			else
			{
				echo '<script type="text/javascript">alert("Sorry! There is some problem.");window.location.href="qus_upload.php";</script>';
				
			}
			} else {
			echo '<script type="text/javascript">alert("Unable to open file!!!");window.location.href="qus_upload.php";</script>';
			
		}
		
		
	}
	//ends
	//current affair code starts
	if(isset($_POST["submit"]))
	{
		header('Content-Type: text/html; charset=utf-8');
		
		$id=$_POST['id'];
		$type=$_POST['type'];
		if($type=='admin')
		{
			$post='admin';
		}
		else
		{
			
			$row=mysqli_query($conn,"select name from `user_list` where email='$id'");
			$sl=mysqli_fetch_array($row);
			$post=$sl['name'];
			
		}
		$file = $_FILES['file']['tmp_name'];
		$handle = fopen($file, "r");
		if ($handle) {
			
			$c = 0;$p=0;
			while(($filesop = fgetcsv($handle, 1000, ",")) !== false)
			{
				$p++;
				if($p!=1)
				{
					$lang = $filesop[0];
					$category=$filesop[1];
					$date = $filesop[2];
					
					$title = str_replace("'","",$filesop[3]);
					$des = str_replace("'","",$filesop[4]);
					$qus = str_replace("'","",$filesop[5]);
					$ans_a = str_replace("'","",$filesop[6]);
					$ans_b = str_replace("'","",$filesop[7]);
					$ans_c = str_replace("'","",$filesop[8]);
					$ans_d = str_replace("'","",$filesop[9]);
					$correct_ans = $filesop[10];
					$mode_qus = $filesop[11];
					$status = $filesop[12];
					
					$datet=date("Y-m-d", strtotime($date));
					$desp=trim($des);
					
					$sql = "INSERT INTO `current_affair` (language,category,event_date,title,description,qus,ans_a,ans_b,ans_c,ans_d,crt_ansno,mode_qus,status,regdate,posed) VALUES ('$lang','$category','$datet','$title','$desp','$qus','$ans_a','$ans_b','$ans_c','$ans_d','$correct_ans','$mode_qus','$status',Now(),'$post')";
					$c = $c + 1;
					//mysqli_set_charset($sql,'utf8');
					$res=mysqli_query($conn,$sql) or  die('Error: ' . mysqli_error($conn));
				}
			}
			if($res){
				echo '<script type="text/javascript">alert("file Upload Successfully");window.location.href="current_affair.php";</script>';
				
			}
			else{
				echo '<script type="text/javascript">alert("Sorry! There is some problem.");window.location.href="current_affair.php";</script>';
				
			}
			} else {
			echo '<script type="text/javascript">alert("Unable to open file!!!");window.location.href="current_affair.php";</script>';
			
		}
		
		
	}
	
	//current affair code ends
	
	
	//pdf upload code starts
	if(isset($_POST["pdf_upload"]))
	{
		
		$path = "../pdf/"; //file to place within the server
		$valid_formats1 = array("pdf"); //list of file extention to be accepted
		$class=$_POST['class'];
		$subject=$_POST['subject'];
		$medium=$_POST['medium'];
		$title=$_POST['title'];
		$term=$_POST['term'];
        $file1 = $_FILES['file']['name']; //input file name in this code is file1
        $fileInfo=pathinfo($file1);
		$ext=$fileInfo['extension'];	
		$ext1=$fileInfo['basename'];		
		if(in_array($ext,$valid_formats1))
		{
			$query = mysqli_query($conn,"SELECT file FROM  pdf_upload WHERE file='$file1'");
			
			if (mysqli_num_rows($query) != 0)
			{
				echo '<script type="text/javascript">alert("File already exists");window.location.href="pdf_upload.php";</script>';
				//echo $_FILES["file"]["name"] . " <span id='invalid'><b>already exists.</b></span> ";
			}
			
			else
			{
				if (file_exists($path . $file1))
				{
					
					echo '<script type="text/javascript">alert("File already exists");window.location.href="pdf_upload.php";</script>';
					
				}
				else
				{
					
					
					$sql=mysqli_query($conn,"insert into  pdf_upload(`medium`,`class`,`subject`,`file`,`term`,`title`,`regdate`)values('$medium','$class','$subject','$ext1','$term','$title',Now())");
					
					
					if($sql==True)
					{
						$tmp =$_FILES['file']['tmp_name'];
                        move_uploaded_file($tmp, $path.$file1);
						
						echo '<script type="application/javascript">alert("Pdf uploaded Successfully");
						var linkz = "pdf_upload.php";window.location.href= linkz;									
						</script>';
					}
					
					else
					{
						
						echo '<script type="application/javascript">alert("Pdf not uploaded");
						var linkz = "pdf_upload.php";window.location.href= linkz;									
						</script>';
					}							
                    
					
				}
			}
		}
		else{
			
			
			echo '<script type="application/javascript">alert("Invalid file Type!.Upload the pdf file only..");
			var linkz = "pdf_upload.php";window.location.href= linkz;									
			</script>';
		}
		
		
	}
	
	
	//pdf upload code ends
	//otherpdf upload code starts
	if(isset($_POST["otherpdf_upload"]))
	{
		
		$path = "../otherpdf/"; //file to place within the server
		$valid_formats1 = array("pdf"); //list of file extention to be accepted
	
		$title=$_POST['title'];
	
        $file1 = $_FILES['file']['name']; //input file name in this code is file1
        $fileInfo=pathinfo($file1);
		$ext=$fileInfo['extension'];	
		$ext1=$fileInfo['basename'];		
		if(in_array($ext,$valid_formats1))
		{
			$query = mysqli_query($conn,"SELECT file FROM  otherpdf_upload WHERE file='$file1'");
			
			if (mysqli_num_rows($query) != 0)
			{
				echo '<script type="text/javascript">alert("File already exists");window.location.href="pdf_upload.php";</script>';
				//echo $_FILES["file"]["name"] . " <span id='invalid'><b>already exists.</b></span> ";
			}
			
			else
			{
				if (file_exists($path . $file1))
				{
					
					echo '<script type="text/javascript">alert("File already exists");window.location.href="otherpdf_upload.php";</script>';
					
				}
				else
				{
					
					
					$sql=mysqli_query($conn,"insert into  otherpdf_upload(`file`,`title`,`regdate`)values('$ext1','$title',Now())");
					
					
					if($sql==True)
					{
						$tmp =$_FILES['file']['tmp_name'];
                        move_uploaded_file($tmp, $path.$file1);
						
						echo '<script type="application/javascript">alert("Pdf uploaded Successfully");
						var linkz = "otherpdf_upload.php";window.location.href= linkz;									
						</script>';
					}
					
					else
					{
						
						echo '<script type="application/javascript">alert("Pdf not uploaded");
						var linkz = "otherpdf_upload.php";window.location.href= linkz;									
						</script>';
					}							
                    
					
				}
			}
		}
		else{
			
			
			echo '<script type="application/javascript">alert("Invalid file Type!.Upload the pdf file only..");
			var linkz = "otherpdf_upload.php";window.location.href= linkz;									
			</script>';
		}
		
		
	}
	
	
	//otherpdf upload code ends
	
	
	//gk upload code starts
	
	if(isset($_POST["gk_upload"]))
	{
		$id=$_POST['id'];
		$type=$_POST['type'];
		if($type=='admin')
		{
			$post='admin';
		}
		else
		{
			
			$row=mysqli_query($conn,"select name from `user_list` where email='$id'");
			$sl=mysqli_fetch_array($row);
			$post=$sl['name'];
			
		}
		$file = $_FILES['file']['tmp_name'];
		$handle = fopen($file, "r");
		if ($handle) {
			
			$c = 0;$p=0;
			while(($filesop = fgetcsv($handle, 1000, ",")) !== false)
			{
				$p++;
				if($p!=1)
				{  
					
					$lang = $filesop[0];
					$category=$filesop[1];
					$date = $filesop[2];
					
					$title = str_replace("'","",$filesop[3]);
					$des = str_replace("'","",$filesop[4]);
					$qus = str_replace("'","",$filesop[5]);
					$ans_a = str_replace("'","",$filesop[6]);
					$ans_b = str_replace("'","",$filesop[7]);
					$ans_c = str_replace("'","",$filesop[8]);
					$ans_d = str_replace("'","",$filesop[9]);
					$correct_ans = $filesop[10];
					$mode_qus = $filesop[11];
					$status = $filesop[12];
					
					$datet=date("Y-m-d", strtotime($date));
					$desp=trim($des);
					$sql = "INSERT INTO `gk_upload` (language,category,event_date,title,description,qus,ans_a,ans_b,ans_c,ans_d,crt_ansno,mode_qus,status,regdate,posed) VALUES ('$lang','$category','$datet','$title','$desp','$qus','$ans_a','$ans_b','$ans_c','$ans_d','$correct_ans','$mode_qus','$status',Now(),'$post')";
					$c = $c + 1;
					$res=mysqli_query($conn,$sql) or  die('Error: ' . mysqli_error($conn));
				}
			}
			if($res){
				echo '<script type="text/javascript">alert("file Upload Successfully");window.location.href="gk_upload.php";</script>';
				
			}
			else{
				echo '<script type="text/javascript">alert("Sorry! There is some problem.");window.location.href="gk_upload.php";</script>';
			}
		}
		else {
			echo '<script type="text/javascript">alert("Unable to open file!!!");window.location.href="gk_upload.php";</script>';   
		}
		
		
	}
	
	//gk upload code ends
	
	
	//current affair uploads
	if(isset($_POST["current_affair"]))
	{
		header('Content-Type: text/html; charset=utf-8');
		$lang=trim($_POST['lang']);
		$date=date("Y-m-d", strtotime($_POST['date']));
		$category=trim($_POST['category']);
		$title=trim(str_replace("'","",$_POST['title']));
		$desp=trim(str_replace("'","",$_POST['desp']));
		$qus=trim(str_replace("'","",$_POST['qus']));
		$ans_a=trim(str_replace("'","",$_POST['ans_a']));
		$ans_b=trim(str_replace("'","",$_POST['ans_b']));
		$ans_c=trim(str_replace("'","",$_POST['ans_c']));
		$ans_d=trim(str_replace("'","",$_POST['ans_d']));
		$crt_ans=trim($_POST['crt_ans']);
		$mode_qus=trim($_POST['mode_qus']);
		$status=$_POST['status'];
		
		$today=date("Y-m-d");
		$id=$_POST['id'];
		$type=$_POST['type'];
		if($type=='admin')
		{
			$post='admin';
		}
		else
		{
			
			$row=mysqli_query($conn,"select name from `user_list` where email='$id'");
			$sl=mysqli_fetch_array($row);
			$post=$sl['name'];
			
		}
		
		
		$sql = "INSERT INTO `current_affair` (language,category,event_date,title,description,qus,ans_a,ans_b,ans_c,ans_d,crt_ansno,mode_qus,status,regdate,posed) VALUES ('$lang','$category','$date','$title','$desp','$qus','$ans_a','$ans_b','$ans_c','$ans_d','$crt_ans','$mode_qus','$status','$today','$post')";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Data Saved");window.location.href="current.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Data not Saved");window.location.href="current.php";</script>';
			
		}
		
		
	}
	//
	
	//gk upload code starts
	
	if(isset($_POST["gk"]))
	{
		header('Content-Type: text/html; charset=utf-8');
		$date=date("Y-m-d", strtotime($_POST['date']));
		$lang=trim($_POST['lang']);
		$category=trim($_POST['category']);
		
		$title=trim(str_replace("'","",$_POST['title']));
		$desp=trim(str_replace("'","",$_POST['desp']));
		$qus=trim(str_replace("'","",$_POST['qus']));
		$ans_a=trim(str_replace("'","",$_POST['ans_a']));
		$ans_b=trim(str_replace("'","",$_POST['ans_b']));
		$ans_c=trim(str_replace("'","",$_POST['ans_c']));
		$ans_d=trim(str_replace("'","",$_POST['ans_d']));
		$crt_ans=trim($_POST['crt_ans']);
		$mode_qus=trim($_POST['mode_qus']);
		$status=$_POST['status'];
		$today=date("Y-m-d");
		$id=$_POST['id'];
		$type=$_POST['type'];
		if($type=='admin')
		{
			$post='admin';
		}
		else
		{
			
			$row=mysqli_query($conn,"select name from `user_list` where email='$id'");
			$sl=mysqli_fetch_array($row);
			$post=$sl['name'];
			
		}
		$sql = "INSERT INTO `gk_upload` (language,category,event_date,title,description,qus,ans_a,ans_b,ans_c,ans_d,crt_ansno,mode_qus,status,regdate,posed) VALUES ('$lang','$category','$date','$title','$desp','$qus','$ans_a','$ans_b','$ans_c','$ans_d','$crt_ans','$mode_qus','$status','$today','$post')";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Data Saved");window.location.href="gk.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Data not Saved");window.location.href="gk.php";</script>';
			
		}
		
		
	}
	//gk upload code starts
	
	
	//question code starts
	
	
	if(isset($_POST["qustions"]))
	{
		header('Content-Type: text/html; charset=utf-8');
		$lang=trim($_POST['lang']);
		$category=trim($_POST['category']);
		$question=trim(str_replace("'","",$_POST['question']));
		$ans_a=trim(str_replace("'","",$_POST['ans_a']));
		$ans_b=trim(str_replace("'","",$_POST['ans_b']));
		$ans_c=trim(str_replace("'","",$_POST['ans_c']));
		$ans_d=trim(str_replace("'","",$_POST['ans_d']));
		$crt_ans=trim($_POST['crt_ans']);
		$status=$_POST['status'];
		$id=$_POST['id'];
		$type=$_POST['type'];
		if($type=='admin')
		{
			$post='admin';
		}
		else
		{
			
			$row=mysqli_query($conn,"select name from `user_list` where email='$id'");
			$sl=mysqli_fetch_array($row);
			$post=$sl['name'];
			
		}
		//	echo "INSERT INTO `tnpsc_qus` (language,category,qus,ans_a,ans_b,ans_c,ans_d,crt_ansno,status,post,regdate) VALUES ('$lang','$category','$question','$ans_a','$ans_b','$ans_c','$ans_d','$crt_ans','$status','$post',Now())";die;
		$sql = "INSERT INTO `tnpsc_qus` (language,category,qus,ans_a,ans_b,ans_c,ans_d,crt_ansno,status,post,regdate) VALUES ('$lang','$category','$question','$ans_a','$ans_b','$ans_c','$ans_d','$crt_ans','$status','$post',Now())";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Data Saved");window.location.href="qus.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Data not Saved");window.location.href="qus.php";</script>';
			
		}
		
	}
	
	//question code ends
	
	
	
	//question edit code starts
	
	
	if(isset($_POST["qus_edit"]))
	{
		header('Content-Type: text/html; charset=utf-8');
		$lang=trim($_POST['lang']);
		$category=trim($_POST['category']);
		$question=trim(str_replace("'","",$_POST['question']));
		$ans_a=trim(str_replace("'","",$_POST['ans_a']));
		$ans_b=trim(str_replace("'","",$_POST['ans_b']));
		$ans_c=trim(str_replace("'","",$_POST['ans_c']));
		$ans_d=trim(str_replace("'","",$_POST['ans_d']));
		$crt_ans=trim($_POST['crt_ans']);
		$status=$_POST['status'];
		$id=$_POST['id'];
		$type=$_POST['type'];
		$qusno=$_POST['qusno'];
		if($type=='admin')
		{
			$post='admin';
		}
		else
		{
			
			$row=mysqli_query($conn,"select name from `user_list` where email='$id'");
			$sl=mysqli_fetch_array($row);
			$post=$sl['name'];
			
		}
		$sql= "update `tnpsc_qus` set  language='$lang',category='$category', qus='$question', ans_a='$ans_a',ans_b='$ans_b',ans_c='$ans_c',ans_d='$ans_d',crt_ansno='$crt_ans',status='$status',post='$post'  where sno='$qusno'";
		
		//$sql = "INSERT INTO `tnpsc_qus` (language,category,qus,ans_a,ans_b,ans_c,ans_d,crt_ansno,status,post,regdate) VALUES ('$lang','$category','$question','$ans_a','$ans_b','$ans_c','$ans_d','$crt_ans','$status','$post',Now())";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Data Updated");window.location.href="qus.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Data not Updated");window.location.href="qus.php";</script>';
			
		}
		
	}
	
	
	
	//test series  code start
	
	
	if(isset($_POST["testseries"]))
	{
		header('Content-Type: text/html; charset=utf-8');
		$testseries_name=trim($_POST['testseries_name']);
		$subject=trim($_POST['subject']);
		$questionid=trim($_POST['questionid']);
		
		//$status=trim($_POST['status']);
		
		
		
		//	echo "INSERT INTO `tnpsc_qus` (language,category,qus,ans_a,ans_b,ans_c,ans_d,crt_ansno,status,post,regdate) VALUES ('$lang','$category','$question','$ans_a','$ans_b','$ans_c','$ans_d','$crt_ans','$status','$post',Now())";die;
		$sql = "INSERT INTO `testseries` (testseries_name,subject,questionid) VALUES ('$testseries_name','$subject','$questionid')";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Data Saved");window.location.href="qus.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Data not Saved");window.location.href="qus.php";</script>';
			
		}
		
	}
	
	//insert Add_unit  code start
	
	
	if(isset($_POST["Add_unit"]) && $_POST["Add_unit"] =='Save')
	{
		
		$class=trim($_POST['class']);
		$subject=trim($_POST['subject']);
		for($i=0;$i<count($_POST['unit_name']);$i++)
		{
		$unit=trim($_POST['unit_name'][$i]);
		
		$sql = "INSERT INTO subject_unit (`class`,`subject`,`unit`) VALUES ('$class','$subject','$unit')";
		$query=mysqli_query($conn,$sql);
		}
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("subject_unit Saved");
			window.location.href="view_unitnames.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("subject_unit not Saved");
			window.location.href="add_unit.php";</script>';
			
		}
		
	}
	
	//insert Add_unit  code end
	
	//Update Add_unit  code start
	if(isset($_POST["Add_unit"]) && $_POST["Add_unit"] =='Update')
	{
		
		$class=trim($_POST['class']);
		$subject=trim($_POST['subject']);
		$unit_name=trim($_POST['unit_name']);
		$oldclass=trim($_POST['oldclass']);
		$oldsubject=trim($_POST['oldsubject']);
		$oldunit=trim($_POST['oldunit']);
		
		$sno=trim($_POST['sno']);
		$sql = "Update subject_unit  set `class`='$class',`subject`='$subject',`unit`='$unit_name' where `sno`='$sno'";
		$query=mysqli_query($conn,$sql);
		
		mysqli_query($conn,"Update subtopics  set `class`='$class',`subject`='$subject',`unit_name`='$unit_name' where `class`='$oldclass' and `subject`='$oldsubject' and `unit_name`='$oldunit'");
		mysqli_query($conn,"update `testseries_qustions` set class='$class',subject='$subject',unit_name='$unit_name' where `class`='$oldclass' and `subject`='$oldsubject' and `unit_name`='$oldunit'");
		
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("unit Updated");
			window.location.href="view_unitnames.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("unit not Updated");
			window.location.href="view_unitnames.php";</script>';
			
		}
		
	}
	
	//UpdateAdd_unit  code end
	//insert Sub-Topic  code start
	
	
	if(isset($_POST["Sub-Topic"]) && $_POST["Sub-Topic"] =='Save')
	{
		
		$class=trim($_POST['class']);
		$subject=trim($_POST['subject']);
		$unit_name=trim($_POST['unit']);
		
		for($i=0;$i<count($_POST['sub_topic']);$i++)
		{
		
		$sub_topic=trim($_POST['sub_topic'][$i]);
		
		$sql = "INSERT INTO subtopics (`class`,`subject`,`unit_name`,`sub_topic`) VALUES ('$class','$subject','$unit_name','$sub_topic')";
		$query=mysqli_query($conn,$sql);
		}
		
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Sub-Topic Saved");
			window.location.href="viewsubtopics.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Sub-Topic not Saved");
			window.location.href="add_subtopic.php";</script>';
			
		}
		
	}
	
	//insert Sub-Topic  code end
	
	//Update Sub-Topic  code start
	if(isset($_POST["Sub-Topic"]) && $_POST["Sub-Topic"] =='Update')
	{
		
		$class=trim($_POST['class']);
		$subject=trim($_POST['subject']);
		$unit_name=trim($_POST['unit']);
		$sub_topic=$_POST['sub_topic'][0];
		
		$sno=trim($_POST['sno']);
		$sql = "Update subtopics  set `class`='$class',`subject`='$subject',`unit_name`='$unit_name',`sub_topic`='$sub_topic' where `sno`='$sno'";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Sub-Topic Updated");
			window.location.href="viewsubtopics.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Sub-Topic not Updated");
			window.location.href="viewsubtopics.php";</script>';
			
		}
		
	}
	
	//Update Sub-Topic  code end
	
	//insert NEET Exam question code starts
	
	
	if(isset($_POST["Test_Question"]) && $_POST["Test_Question"] =='Save')
	{
		header('Content-Type: text/html; charset=utf-8');
		$class=$_POST['class'];
		$subject=$_POST['subject'];
		$unit_name=$_POST['unit'];
		$sub_topic=$_POST['sub_topic'];
		$question=trim(str_replace("'","`",$_POST['question']));
		$answer_a=trim(str_replace("'","`",$_POST['answer_a']));
		$answer_b=trim(str_replace("'","`",$_POST['answer_b']));
		$answer_c=trim(str_replace("'","`",$_POST['answer_c']));
		$answer_d=trim(str_replace("'","`",$_POST['answer_d']));
		$correct_ans=trim($_POST['correct_ans']);
		$description=trim(str_replace("'","`",$_POST['description']));
		$status=$_POST['status'];
		$reference=$_POST['reference'];
		$mode=$_POST['mode'];
		
		if(!empty($_FILES['image']['tmp_name']))
		{
		$sql_cn = mysqli_query($conn,"select MAX(sno) from `testseries_qustions`");
		$qr_cn = mysqli_fetch_array($sql_cn);
		$la_id = $qr_cn['MAX(sno)'] +1;
		$pic ='question'.$la_id.'.jpg';
		$pic_loc = $_FILES['image']['tmp_name'];
		$folder="uploads/";
		move_uploaded_file($pic_loc,$folder.$pic);
		$image='admin/uploads/'.$pic;
		}
		else
		{
		$image='';	
		}
		
		 $sql = "INSERT INTO `testseries_qustions` (class,subject,unit_name,sub_topic,question,image,answer_a,answer_b,answer_c,answer_d,correct_ans,description,reference,mode,status) VALUES ('$class','$subject','$unit_name','$sub_topic','$question','$image','$answer_a','$answer_b','$answer_c','$answer_d','$correct_ans','$description','$reference','$mode','$status')";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Question Upload Successfully "); window.location.href="view_qus_upload.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Question Not Upload Successfully ");
			window.location.href="newqus_upload.php";</script>';
			
		}
		
	}
	
	//insert NEET Exam question codecode ends
	
	
	
	//Update  NEET Exam question code Start
	
	if(isset($_POST["Test_Question"])  && $_POST["Test_Question"] =='Update')
	{
		
		header('Content-Type: text/html; charset=utf-8');
	$class=$_POST['class'];
		$subject=$_POST['subject'];
		$unit_name=$_POST['unit'];
		$sub_topic=$_POST['sub_topic'];
		$question=trim(str_replace("'","`",$_POST['question']));
		$answer_a=trim(str_replace("'","`",$_POST['answer_a']));
		$answer_b=trim(str_replace("'","`",$_POST['answer_b']));
		$answer_c=trim(str_replace("'","`",$_POST['answer_c']));
		$answer_d=trim(str_replace("'","`",$_POST['answer_d']));
		$correct_ans=trim($_POST['correct_ans']);
		$description=trim(str_replace("'","`",$_POST['description']));
		$status=$_POST['status'];
		$reference=$_POST['reference'];
		$mode=$_POST['mode'];
		$sno=$_POST['sno'];
		if(!empty($_FILES['image']['tmp_name']))
		{
		$sql_cn = mysqli_query($conn,"select MAX(sno) from `testseries_qustions`");
		$qr_cn = mysqli_fetch_array($sql_cn);
		$la_id = $qr_cn['MAX(sno)'] +1;
		$pic ='question'.$la_id.'.jpg';
		$pic_loc = $_FILES['image']['tmp_name'];
		$folder="uploads/";
		move_uploaded_file($pic_loc,$folder.$pic);
		$image='admin/uploads/'.$pic;
		}
		elseif(!empty($_POST['oldimage']))
		{
		$image=$_POST['oldimage'];
		}
		else
		{
		$image='';	
		}
		
		$sql= "update `testseries_qustions` set class='$class',subject='$subject',unit_name='$unit_name',sub_topic='$sub_topic', question='$question', image='$image', answer_a='$answer_a', answer_b='$answer_b',answer_c='$answer_c',answer_d='$answer_d',correct_ans='$correct_ans',description='$description',reference='$reference',mode='$mode',status='$status' where sno='$sno'";
		
		$query=mysqli_query($conn,$sql);
		
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Question Upload Successfully ");
			window.location.href="view_qus_upload.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Question Not Upload Successfully ");
			window.location.href="view_qus_upload.php";</script>';
			
		}
		
	}
	// Update  NEET Exam question end
	
	//insert Schedule Name  code start
	
	
	if(isset($_POST["schedule_Name"]) && $_POST["schedule_Name"] =='Save')
	{
		
		$schedule_name=trim($_POST['schedule_name']);
		
		$sql = "INSERT INTO schedule_names (`schedule_name`) VALUES ('$schedule_name')";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Schedule Name Saved");
			window.location.href="viewschedule_name.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Schedule Name not Saved");
			window.location.href="add_schedulename.php";</script>';
			
		}
		
	}
	
	//insert Schedule Name  code end
	
	//Update Schedule Name code start
	if(isset($_POST["schedule_Name"]) && $_POST["schedule_Name"] =='Update')
	{
		
		$schedule_name=trim($_POST['schedule_name']);
		$oldname=trim($_POST['oldname']);
		$sno=trim($_POST['sno']);
		$sql = "Update schedule_names  set `schedule_name`='$schedule_name' where `sno`='$sno'";
		mysqli_query($conn,"Update testschedule set  `schedule_name`='$schedule_name'where schedule_name='$oldname'");
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Schedule Name Updated");
			window.location.href="viewschedule_name.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Schedule Name not Updated");
			window.location.href="viewschedule_name.php";</script>';
			
		}
		
	}
	
	//Update Schedule Name  code end
	
	//insert Test Name  code start
	
	
	if(isset($_POST["Test_Name"]) && $_POST["Test_Name"] =='Save')
	{
		
		
		$test_type=trim($_POST['test_type']);
		$sql = "INSERT INTO test_names (`test_type`) VALUES ('$test_type')";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Test Name Saved");
			window.location.href="viewschedule_testname.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Test Name not Saved");
			window.location.href="add_testname.php";</script>';
			
		}
		
	}
	
	//insert Test Name  code end
	
	//Update Test Name code start
	if(isset($_POST["Test_Name"]) && $_POST["Test_Name"] =='Update')
	{
		
		$oldname=trim($_POST['oldname']);
		$test_type=trim($_POST['test_type']);
		$sno=trim($_POST['sno']);
		$sql = "Update test_names  set `test_type`='$test_type' where `sno`='$sno'";
		mysqli_query($conn,"Update testschedule set  `test_type`='$test_type'where test_type='$oldname'");
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Test Name Updated");
			window.location.href="viewschedule_testname.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Test Name not Updated");
			window.location.href="viewschedule_testname.php";</script>';
			
		}
		
	}
	
	//Update Test Name  code end
	
	//insert Test Schedule  code start
	
	
	if(isset($_POST["Add_Testschedule"]) && $_POST["Add_Testschedule"] == 'Save')
	{
		
		$schedule_name=trim($_POST['schedule_name']);
		$test_type=trim($_POST['test_type']);
		$class=trim($_POST['class']);
		$subject=trim($_POST['subject']);
		$unit=implode('&&', $_POST['unit']);
		$sub_topics=implode('&&', $_POST['sub_topics']);
		$start_date=date("Y-m-d", strtotime($_POST['start_date']));
		$end_date=date("Y-m-d", strtotime($_POST['end_date']));
		$no_qus=trim($_POST['no_qus']);
		$status=trim($_POST['status']);
		$sql = "INSERT INTO testschedule (`schedule_name`,`test_type`,`class`,`subject`,`unit`,`sub_topics`,`start_date`,`end_date`,`no_qus`,`status`) VALUES ('$schedule_name','$test_type','$class','$subject','$unit','$sub_topics','$start_date','$end_date','$no_qus','$status')";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Test Schedule Saved");
			window.location.href="viewtestschedule.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Test Schedule not Saved");
			window.location.href="add_testschedule.php";</script>';
			
		}
		
	}
	
	//insert Test Schedule  code end
	
	//Update Test Schedule  code start
	
	
	if(isset($_POST["Add_Testschedule"]) && $_POST["Add_Testschedule"] == 'Update')
	{
		
		$schedule_name=trim($_POST['schedule_name']);
		$test_type=trim($_POST['test_type']);
		$class=trim($_POST['class']);
		$subject=trim($_POST['subject']);
		$unit=implode('&&', $_POST['unit']);
		$sub_topics=implode('&&', $_POST['sub_topics']);
		$start_date=date("Y-m-d", strtotime($_POST['start_date']));
		$end_date=date("Y-m-d", strtotime($_POST['end_date']));
		$no_qus=trim($_POST['no_qus']);
		$status=trim($_POST['status']);
		$sno=trim($_POST['sno']);
		$sql = "Update testschedule set `schedule_name`='$schedule_name', `test_type`='$test_type', `class`='$class',`subject`='$subject',`unit`='$unit',`sub_topics`='$sub_topics',`start_date`='$start_date', `end_date`='$end_date', `no_qus`='$no_qus',`status`='$status' where sno='$sno'";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Test Schedule Updated");
			window.location.href="viewtestschedule.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Test Schedule not Updated");
			window.location.href="viewtestschedule.php";</script>';
			
		}
		
	}
	
	//Update Test Schedule  code end
	
	//insert Notification  code start
	
	
	if(isset($_POST["Notification"]) && $_POST["Notification"] =='Save')
	{
		
		
		$title=trim($_POST['title']);
		$content=trim($_POST['content']);
		$sql = "INSERT INTO notification (`title`,`content`,`regdate`) VALUES ('$title','$content',Now())";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Notification Saved");
			window.location.href="view_notification.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Notification not Saved");
			window.location.href="add_notification.php";</script>';
			
		}
		
	}
	
	//insert  Notification  code end
	
	//Update Notification code start
	if(isset($_POST["Notification"]) && $_POST["Notification"] =='Update')
	{
		
		
		$title=trim($_POST['title']);
		$content=trim($_POST['content']);
		$sno=trim($_POST['sno']);
		
		$sql = "Update notification  set `title`='$title',`content`='$content'  where `sno`='$sno'";
		$query=mysqli_query($conn,$sql);
		if($query==TRUE)
		{
			echo '<script type="text/javascript">alert("Notification Updated");
			window.location.href="view_notification.php";</script>';
			
		}
		else
		{
			echo '<script type="text/javascript">alert("Notification not Updated");
			window.location.href="view_notification.php";</script>';
			
		}
		
	}
	
	//Update Notification  code end
	
?>

Batal

⬅ Naik ke nimirnthunil.in 80 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁Documents	dir	—	2023-03-10 05:38	📂 Buka
📁css	dir	—	2023-04-16 17:40	📂 Buka
📁fonts	dir	—	2023-04-15 16:46	📂 Buka
📁images	dir	—	2023-04-15 16:46	📂 Buka
📁js	dir	—	2023-04-15 16:46	📂 Buka
📁model	dir	—	2024-09-02 19:51	📂 Buka
📁pages	dir	—	2024-09-02 19:51	📂 Buka
📁php-excel-reader	dir	—	2015-04-29 20:24	📂 Buka
📁quiz	dir	—	2023-03-10 05:38	📂 Buka
📁tamil	dir	—	2023-04-18 09:08	📂 Buka
📁testseries	dir	—	2023-04-17 07:10	📂 Buka
📁uploads	dir	—	2026-07-28 09:59	📂 Buka
📄.gitignore	gitignore	24 B	2015-04-29 20:24	✏️ Edit 👁️ View
📄Bamini.ttf	ttf	31 KB	2023-04-18 07:15	✏️ Edit 👁️ View
📝CHANGELOG.md	md	4.3 KB	2015-04-29 20:24	✏️ Edit 👁️ View
📝LICENSE.md	md	1.5 KB	2015-04-29 20:24	✏️ Edit 👁️ View
📝README.md	md	3.6 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘SpreadsheetReader.php	php	8.4 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘SpreadsheetReader_CSV.php	php	6.9 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘SpreadsheetReader_ODS.php	php	8 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘SpreadsheetReader_XLS.php	php	5.8 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘SpreadsheetReader_XLSX.php	php	29 KB	2015-04-29 20:24	✏️ Edit 👁️ View
📗Test.xlsx	xlsx	10.7 KB	2019-11-21 11:42	✏️ Edit 👁️ View
📜accordion.js	js	734 B	2018-01-15 07:25	✏️ Edit 👁️ View
🐘add_newbatches.php	php	4 KB	2023-03-14 10:53	✏️ Edit 👁️ View
🐘add_testseries_course.php	php	4.9 KB	2023-03-14 11:35	✏️ Edit 👁️ View
🐘add_testseries_department.php	php	6.1 KB	2023-10-06 16:55	✏️ Edit 👁️ View
🐘add_testseries_question.php	php	14.7 KB	2023-10-06 17:32	✏️ Edit 👁️ View
🐘add_testseries_question2.php	php	13.8 KB	2023-04-16 17:00	✏️ Edit 👁️ View
🐘add_testseries_topic.php	php	8 KB	2024-11-30 07:29	✏️ Edit 👁️ View
🐘add_whatsnew.php	php	4.7 KB	2020-12-31 10:25	✏️ Edit 👁️ View
🗜️admin.zip	zip	4.7 MB	2025-08-15 09:20	✏️ Edit 👁️ View
🐘ajax_data.php	php	441 B	2018-07-19 08:30	✏️ Edit 👁️ View
🐘ajax_department.php	php	897 B	2020-10-16 11:38	✏️ Edit 👁️ View
🐘ajax_folder.php	php	711 B	2020-04-14 13:18	✏️ Edit 👁️ View
🐘ajax_testseries_department.php	php	667 B	2023-10-07 11:01	✏️ Edit 👁️ View
🐘ajax_testseries_topic.php	php	695 B	2023-10-07 11:04	✏️ Edit 👁️ View
🐘bulk_qus_upload.php	php	3.8 KB	2026-07-28 09:44	✏️ Edit 👁️ View
🐘bulk_qus_upload1.php	php	3.1 KB	2026-07-28 09:43	✏️ Edit 👁️ View
🐘class.php	php	32.4 KB	2023-07-29 11:17	✏️ Edit 👁️ View
📋composer.json	json	652 B	2015-04-29 20:24	✏️ Edit 👁️ View
🐘dashboard.php	php	3.3 KB	2023-03-14 10:41	✏️ Edit 👁️ View
🐘download_testseriesresult.php	php	2.1 KB	2024-12-06 11:23	✏️ Edit 👁️ View
📄error_log	file	1.1 MB	2026-07-28 09:59	✏️ Edit 👁️ View
🐘footer.php	php	824 B	2023-10-07 15:00	✏️ Edit 👁️ View
🐘function.php	php	756 B	2023-03-14 11:51	✏️ Edit 👁️ View
🐘header.php	php	2.9 KB	2023-07-29 11:27	✏️ Edit 👁️ View
🐘index.php	php	1.2 KB	2023-03-10 10:31	✏️ Edit 👁️ View
🐘logout.php	php	145 B	2018-01-15 07:25	✏️ Edit 👁️ View
🐘menu.php	php	2.7 KB	2024-12-09 10:48	✏️ Edit 👁️ View
📜nicEdit.js	js	31.6 KB	2023-04-14 02:54	✏️ Edit 👁️ View
🖼️nicEditorIcons.gif	gif	3.3 KB	2015-10-04 11:56	✏️ Edit 👁️ View
🗜️online_exam_admin.zip	zip	2.4 MB	2023-08-30 10:26	✏️ Edit 👁️ View
🐘profile.php	php	5 KB	2019-12-09 08:54	✏️ Edit 👁️ View
🐘session.php	php	144 B	2023-10-07 15:01	✏️ Edit 👁️ View
🗜️spreadsheet-reader-master.zip	zip	48.9 KB	2023-08-05 06:03	✏️ Edit 👁️ View
🌐tamil.html	html	610 B	2023-04-18 07:56	✏️ Edit 👁️ View
🗜️tamil.zip	zip	40.7 KB	2023-04-18 09:29	✏️ Edit 👁️ View
🐘test.php	php	2.3 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘testseries.php	php	28.3 KB	2026-05-12 05:00	✏️ Edit 👁️ View
🐘testseries1.php	php	26.9 KB	2023-05-13 05:23	✏️ Edit 👁️ View
🐘testseries2.php	php	54.9 KB	2023-04-17 08:12	✏️ Edit 👁️ View
🐘testseries_assign.php	php	1.4 KB	2020-02-24 10:44	✏️ Edit 👁️ View
🐘testseries_exam_category.php	php	4.6 KB	2023-03-14 11:33	✏️ Edit 👁️ View
🐘testseries_exam_department.php	php	6.1 KB	2024-11-30 07:28	✏️ Edit 👁️ View
🐘testseries_exam_topic.php	php	7.9 KB	2024-11-30 07:27	✏️ Edit 👁️ View
🐘testseries_merge_topics.php	php	8.7 KB	2023-10-07 11:30	✏️ Edit 👁️ View
🐘testseries_newstudent.php	php	12.9 KB	2024-12-09 10:46	✏️ Edit 👁️ View
🐘testseries_newuserlist.php	php	9.5 KB	2024-12-09 10:57	✏️ Edit 👁️ View
🐘testseries_oldstudent.php	php	6.4 KB	2020-09-09 09:53	✏️ Edit 👁️ View
🐘testseries_question.php	php	12.9 KB	2025-04-26 06:56	✏️ Edit 👁️ View
🐘testseries_question_old.php	php	10 KB	2024-02-09 07:36	✏️ Edit 👁️ View
🐘testseries_questiontest.php	php	9.4 KB	2023-08-05 06:09	✏️ Edit 👁️ View
🐘testseries_student.php	php	12.9 KB	2023-10-07 11:33	✏️ Edit 👁️ View
🐘testseries_userlist.php	php	9.5 KB	2024-12-09 10:57	✏️ Edit 👁️ View
🐘testseriesresult_download.php	php	8.4 KB	2024-02-09 07:36	✏️ Edit 👁️ View
🐘update_wishes.php	php	4.5 KB	2023-03-14 11:15	✏️ Edit 👁️ View
🐘upload_testseriesqus.php	php	6.2 KB	2024-11-29 06:59	✏️ Edit 👁️ View
🐘view_newbatches.php	php	4.6 KB	2023-03-14 11:13	✏️ Edit 👁️ View
🐘view_whatsnew.php	php	4.5 KB	2023-03-14 11:13	✏️ Edit 👁️ View