Gecko [ gzmcfeni.gov.bd ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
admit	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
datespicker	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
menu	[ DIR ]	drwxr-xr-x
scss	[ DIR ]	drwxr-xr-x
textEdit	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
AjaxDailyAttendanceSheet.php	3.03 KB	-rw-r--r--
AnsPaper.php	10.02 KB	-rw-r--r--
DueandPaidReport.php	4.56 KB	-rw-r--r--
QuestionPaper.php	16.07 KB	-rw-r--r--
RegistrationForm.php	44.94 KB	-rw-r--r--
admit.css	2.66 KB	-rw-r--r--
admit.php	7.78 KB	-rw-r--r--
ajaxAddAns.php	815 B	-rw-r--r--
ajaxDateWiseReport.php	18.07 KB	-rw-r--r--
attendanceReport.php	5.81 KB	-rw-r--r--
changePassword.php	3.93 KB	-rw-r--r--
check_grou_name.php	1.15 KB	-rw-r--r--
cheking_period.php	3.02 KB	-rw-r--r--
dailyAttendanceSheet.php	6.58 KB	-rw-r--r--
dashboard.php	8.84 KB	-rw-r--r--
dueReport.php	8.75 KB	-rw-r--r--
error_log	3.81 KB	-rw-r--r--
index.php	6.88 KB	-rw-r--r--
login.php	4.73 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x
result.php	8.25 KB	-rw-r--r--
singleStdAttendanceReport.php	5.71 KB	-rw-r--r--
student_info.php	22.39 KB	-rw-r--r--

Code Editor : cheking_period.php

<?php

require_once("../db_connect/config.php");
    require_once("../db_connect/conect.php");
    $db = new database();

if(isset($_POST["periodshow"]))
	{
	   	$insert="SELECT * FROM `add_period` WHERE `class_id`='".$_POST['className']."'";
	    $r=$db->link->query($insert);
	    while($fetch_info=$r->fetch_array())
	    {
	    	print "<option value='$fetch_info[0]'>$fetch_info[2]</option>";
	    }
	}

if(isset($_POST["add"]))
	{
			// data :{selectUser:selectUser,className:className,groupname:groupname,section:section,add:add,period:period},
		$group=explode("and",$_POST["groupname"]);
		$section=explode("and",$_POST["section"]);
		$sql="INSERT INTO `subject_priority_att`(`user`,`class`,`group`,`section`,`subjectName`,`SubjectPart`) VALUES('".$_POST["selectUser"]."','".$_POST["className"]."','".$group[0]."','".$section[0]."','".$_POST["period"]."','Null')";
		$result=$db->link->query($sql);
		if($result)
		{
			print "Save Successfully!!";
		}
		else
		{
			print "Save Unsuccessfully!!";
		}

}

if(isset($_POST["view"]))
	{
		$sql=$db->link->query("SELECT `teachers_information`.`teachers_name`,`add_class`.`class_name`,`add_group`.`group_name`,`add_section`.`section_name`,`add_period`.`period_name`,`add_period`.`subject_name`,`subject_priority_att`.`id` FROM `subject_priority_att`
INNER JOIN `teachers_information` ON `teachers_information`.`teachers_id`=`subject_priority_att`.`user`
INNER JOIN `add_period` ON `add_period`.`id`=`subject_priority_att`.`subjectName`
INNER JOIN `add_class` ON `add_class`.`id`=`subject_priority_att`.`class`
INNER JOIN `add_section` ON `add_section`.`id`=`subject_priority_att`.`section`
INNER JOIN `add_group` ON `add_group`.`id`=`subject_priority_att`.`group`  WHERE `subject_priority_att`.`user`='".$_POST["selectUser"]."'");

?>
		<table class="table table-bordered table-striped">
			<tr>
					<td>Sl</td>
					<td>Name</td>
					<td>Class</td>
					<td>Group</td>
					<td>Section</td>
					<td>Period</td>
					<td>Subject</td>
					<td>Action</td>
			</tr>

<?php 
			$i=1;
				while($fetch=$sql->fetch_array())
				{
					?>

<?php
				}
			?>

</table>
<?php

}

if(isset($_POST["del"]))
{

$delete="DELETE FROM `subject_priority_att` WHERE `id`='".$_POST['id']."'";
	  $db->link->query($delete);
	  print "Delete Successfully!!";
}

if(isset($_POST["SearchSection"]))
{

$select="SELECT * FROM `add_section` WHERE `class_id`='".$_POST['className']."' AND `group_id`='".$_POST['groupName']."'";
	  $sql=$db->link->query($select);
	  
	  while($fetch=$sql->fetch_array())
	  {
	  	print "<option value='$fetch[0]'>".$fetch[3]."</option>";
	  		
	  }
	
}
?>

${this.title}

Code Editor : cheking_period.php