1#@!#!123s

: / home / ksclnmuac / www / web / admin /
Filename : viewteacher.php
back
<?php include 'header.php';?>
<?php
include("connection.php");
$query="select * from tbl_teacher";
$res=mysqli_query($dbCon,$query);
?>

		

	<div class="page-header page-header-light">
		<div class="breadcrumb-line breadcrumb-line-light header-elements-md-inline">
			<div class="d-flex">
				<div class="breadcrumb">
					<a href="#" class="breadcrumb-item"><i class="icon-copy"></i> Manage Teacher</a>
					<span class="breadcrumb-item active">View Teacher</span>
				</div>
				<a href="#" class="header-elements-toggle text-default d-md-none"><i class="icon-more"></i></a>
			</div>
		</div>
	</div>
	<!-- /page header -->
	<!-- Content area -->
			<div class="content">

				<!-- Basic initialization -->
	<div class="card">
		<div class="card-header header-elements-inline">
			<h5 class="card-title">Teacher's Record</h5>
			<div class="header-elements">
				<div class="list-icons">
					<a class="list-icons-item" data-action="collapse"></a>
					<a class="list-icons-item" data-action="reload" href="/Admin/ViewTeacher"></a>
					
				</div>
			</div>
		</div>
    <div class="card-body">       
    </div>
    <table class="table datatable-button-init-basic datatable-reorder">
        <thead>
            <tr>
                <th>S.No.</th>
                <th>Pic</th>
                <th>Reg.Date</th>
                <th>Name</th>
                <th>DOB</th>
                <th>Gender</th>
                <th>Father's Name</th>
                <th>Mobile No.</th>
                <th>Email</th>
                <th>Department</th>
                <th>Designation</th>
                <th>Qualification</th>
                <th>Address</th>
                <th>Edit</th>
                <th>Delete</th>
            </tr>
        </thead>
        <tbody>
		<?php
		  $a=1;
		  while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		  {
	    ?>
            <tr>
                <td><?php echo $a; $a++; ?></td>
                <td><img height="100" width="100" src="teacher/<?php echo $row['pic'];?>" /></td>
                <td><?php echo $row['dor'];?></td>
                <td><a href="#"><?php echo $row['name'];?></a></td>
                <td><?php echo $row['dob'];?></td>
                <td><?php echo $row['gender'];?></td>
                <td><?php echo $row['fname'];?></td>
                <td><?php echo $row['mobile'];?></td>
                <td><?php echo $row['email'];?></td>
				<?php
				$dept=$row['dept_id'];
				$query2="select * from tbl_department where dept_id='$dept'";
				$res2=mysqli_query($dbCon,$query2);
				if($row2=mysqli_fetch_array($res2,MYSQLI_BOTH))
				{
					$department=$row2['dept_name'];
				}
				?>
                <td><?php echo $department;?></td>
                <td><?php echo $row['designation'];?></td>
                <td><?php echo $row['qualification'];?></td>
                <td><?php echo $row['address'];?></td>
                <td><a href="#">Edit</a></td>
                <td><a href="tdel.php?id=<?php echo $row['0'];?>">Delete</a></td>
            </tr>
        <?php
		  }
		?>
        </tbody>
    </table>
	</div>
	<!-- /basic initialization -->
	<!-- /main charts -->
	<!-- Dashboard content -->
	<!-- /dashboard content -->
	</div>
	<script>
		function deluser(p) {
			var id = jQuery(p).next().text();
			var status = confirm("Do you want to delete record?");
			if (status == true) {
				window.location.href = '../Admin/deluser?id=' + id;
			}
		}
	</script>
           
           	<?php include 'footer.php';?>