File manager - Edit - /home/autoph/public_html/pms_v1/reports/loadEmployeeByDepartment.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); include '../css/mainCSS.php'; //error_reporting(0); if(isset($_POST['searchEmP'])){ $searchText = $_POST['searchText']; $userID = $_POST['userID']; if($searchText==""){ $getPCPHeaders = "SELECT * FROM `pms_department_tbl` WHERE `deleted`=0 ORDER BY `dept_name` ASC"; }else{ $getPCPHeaders = "SELECT * FROM `pms_department_tbl` WHERE `deleted`=0 AND `dept_name` LIKE '%$searchText%' || `deleted`=0 AND `dept_code` LIKE '%$searchText%' ORDER BY `dept_name` ASC"; } $pcpHead = mysqli_query($conn,$getPCPHeaders); $statRow = mysqli_num_rows($pcpHead); echo "<table class='w-100'>"; echo "<thead>"; echo "<th class='PeachBG'>ID</th>"; echo "<th class='PeachBG'>CODE</th>"; echo "<th class='PeachBG'>DEPARTMENT NAME</th>"; echo "<th class='PeachBG'></th>"; echo "</thead>"; while($row = mysqli_fetch_array($pcpHead)){ ?><tr onclick="javascript:pcpSelection(this);" ><?php echo "<td class='text-dark'>".$row['id']."</td>"; echo "<td class='cotext-darkl'>".$row['dept_code']."</td>"; echo "<td class='text-dark'>".$row['dept_name']."</td>"; echo "<td style='width:3%'>";?> <i onClick="window.open('./pdfViewer/RPTEmployee_listByDepartment.php?id=<?php echo $row['id'];?>&source=<?php echo $userID;?>')" class="fa fa-print" style='cursor:pointer;color:green;float:right;font-size:16px'></i> <?php echo "</td>"; echo "<tr>"; } echo "</table>"; $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings