invisio v2.0

<?php
	include("innerpageheader.php");
	include("config.php");
	$result = $js->query('SELECT * FROM `employees` ORDER BY `id`');
			$result->execute();
	
			
?>
      
		<section>
			<div class="content listing-content">
				<div class="in-content-wrapper">
					<div class="row no-gutters">

<div class="col">
							<div class="heading-messages">
								<h3>Employees</h3>
							</div>
						</div>
						<div class="col-md-4">
							
						</div>
					</div>
                  <div class="box">
						<div class="row no-gutters">
							<div class="col-auto me-auto text-start pe-0">
								<div class="add-new">
									<a href="add_employees.php">Add New<i class="fas fa-plus"></i></a>
								</div>
							</div>

</div>
						<div class="row no-gutters">
							<div class="col-12 table-responsive">
								<table id="example" class="table table-hover responsive listing">
                                    <thead>
                                        <tr>
                                            <th>Name</th>
                                            <th>Mobile No</th>
                                            <th>Email</th>
                                            <th>Location</th>
                                            <th>Designation</th>
											<th>Department</th>
											<th>Branch</th>
											<th>User ID</th>
											<th>Password</th>
                                        </tr>
                                    </thead>










                                    <tbody>
									<?php
									$uname='';
									$pass='';
										while($row = $result->fetch(PDO::FETCH_ASSOC)) 
										{
											$empid = $row['empid'];
											
											$sql = $js->prepare('SELECT * FROM login WHERE userid = :empid ');
											 $sql->execute(array(':empid' => $empid));
											//$result1->execute();
											while($row1 = $sql->fetch(PDO::FETCH_ASSOC)) 
											{
												$uname = $row1['userid'];
												$pass = $row1['userpassword'];
											}
											$empname = $row['empname'];
											$empaddr = $row['empaddr'];
											$emploc = $row['location'];
											$empdept = $row['dept'];
											
											$empmob = $row['mobile'];
											$empmail = $row['email'];
											$desig = $row['desig'];
											$br = $row['branch'];

echo "<tr>";
												echo "<td>$empname</td>";
												echo "<td>$empmob</td>";
												echo "<td>$empmail</td>";
												echo "<td>$emploc</td>";
												echo "<td>$empdept</td>";
												echo "<td>$desig</td>";
												echo "<td>$br</td>";
												echo "<td>$uname</td>";
												echo "<td>$pass</td>";
											echo "</tr>";
											$brname='';
											$deptname = '';
										}
									?>
                                        
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

</div>

</div>

<script src="js/jquery-3.3.1.min.js"></script>
	<script src="js/popper.min.js"></script>
	<script src="js/bootstrap-5.3.2.min.js"></script>
	<script src="vendors/datatables/datatables.min.js"></script>
	<script src="js/customscriptfile.js"></script>

</html>