1#@!#!123s

: / home / ksclnmuac / www / web /
Filename : teacher.php
back
<?php
include("admin/connection.php");
$query="select * from tbl_teacher";

$res=mysqli_query($dbCon,$query);

?>

	<!-- Header Start -->
	<?php
		include("headernew.php");
	?>
	<!-- Header End -->
	<!-- Inner Banner Wrapper Start -->
		<div class="inner-banner">
			<div class="container">
				<div class="col-sm-12">
					<h2>Teaching Staff</h2>
				</div>
				<div class="col-sm-12 inner-breadcrumb">
					<ul>
						<li><a href="index.html">Home</a></li>
						<li>Teaching Staff</li>
					</ul>
				</div>
			</div>
		</div>
	<!-- Inner Banner Wrapper End -->

	<section class="inner-wrapper">
	  <div class="container">
		<div class="row offset">
		  <h2>FACULTY <span>LIST</span></h2>
		  <div class="inner-wrapper-main offset-top-30">
			<div class="col-sm-12 col-sm-offset col-xs-offset table-responsive">
			  <table class="table-custom striped table-color">	
				<tbody>
				  <tr>
					<th>S.No.</th>
					<th>Pic</th>
					<th>Faculty Name</th>
					<th>Designation</th>
					<th>Department</th>
					<th>Highest Qualification</th>
					<th>Mobile No.</th>
					<th>Email Id</th>
				  </tr>
				  <?php 
				  $a=1;
				 while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
				  {
				  ?>
				  <tr>
					 <td><?php echo $a;$a++;?></td>
					 <td>
						  <img src="admin/teacher/<?php echo $row['pic'];?>" height="100" width="100"  style="border-radius: 50%;"/>
					 </td>
						  <td><?php echo $row['name'];?></td>
						  <td><?php echo $row['designation'];?></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['qualification'];?></td>
						  <td><?php echo $row['mobile'];?></td>
						  <td><?php echo $row['email'];?></td>
				  </tr>
				  <?php
				  }
				  ?>
				  
				  
				</tbody>
			  </table>
			</div>
		  </div>
		</div>
	  </div>
	</section>
	
	<!-- Footer Links Start-->
	<?php include 'footernew.php';?>