invisio v2.0

<?php
session_start();
include("config.php");
include("innerpageheader.php");
$empids = $_SESSION['empids'];
$sql1 = $js->prepare('SELECT * FROM employees WHERE empid = :empids ');
$sql1->execute(array(':empids' => $empids));

while($row1 = $sql1->fetch(PDO::FETCH_ASSOC)) 
{
	$branch = $row1['empbranch'];
	$ename = $row1['empname'];
	$sql2 = $js->prepare('SELECT * FROM branches WHERE brid = :branch ');
	$sql2->execute(array(':branch' => $branch));
	while($row2 = $sql2->fetch(PDO::FETCH_ASSOC)) 
	{
		$brname = $row2['brname'];
	}	
}		
if($empids == 'admin')
{
	$resemp = $js->query('SELECT * FROM `employees` ORDER BY `id`');
	$resemp->execute();
}
else
{
	$resemp = $js->prepare('SELECT * FROM `employees` WHERE empid = :empids ORDER BY `id`');
	$resemp->execute(array(':empids' => $empids));	
}
								
?>
<section>
			<div class="content add-details">
				<div class="in-content-wrapper">
					<div class="row no-gutters">

<h5 align="center" style="margin-top:40px"> Search Marketing Visits Report</h6>
	   <hr>
	   <br>
                            
                            <form class="user" method="post" action="marketingvisitsreport.php">
                                <div class="form-group row">
									
                                     <div class="col-sm-4 mb-3 mb-sm-0">
                                    	<input type="date" class="form-control form-control-user" id="fdate" name="fdate">
                                      </div>
                                      <div class="col-sm-4 mb-3 mb-sm-0">
                                    	<input type="date" class="form-control form-control-user" id="tdate" name="tdate">
                                      </div>
                                      <div class="col-sm-4 mb-sm-0">
                                      <select class="form-control" style="border-radius: 25px;border-color:#2368BF; height:50px;" id="empids" name="empids">
										<?php
											if($empids == 'admin')
											{
										?>
                                        	<option disabled>Select Employee</option>
                                            <option selected value="All">All</option>	
                                        <?php
											}
										?>										
											<?php
											
												while($rowt = $resemp->fetch(PDO::FETCH_ASSOC)) 
												{
													echo $empid = $rowt['empid'];
													echo $empname = $rowt['empname']; 
													echo "<option value='$empid'>$empname</option>";
												}
											?>
												
										</select>
                                       
                                    </div>
                                   
                                    
                                </div>
                               
                                <input type="submit" value="Generate Report" class="btn btn-primary btn-user btn-block">
                               
                                
                            </form>
                         
    </div>

<?php
	include('footer.php');
?>