File manager - Edit - /home/autoph/public_html/pms_v1/apr/searchEmpByCompany.php
Back
<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['iSearch'])){ $selUnitID = $_POST['selUnitID']; $searchEmployee = $_POST['searchEmployee']; $getEmpInfo = "SELECT * FROM `pms_employee_data` WHERE `deleted`=0 AND `last_name` LIKE '%$searchEmployee%' || `first_name` LIKE '%$searchEmployee%' || `emp_id` LIKE '%$searchEmployee%' ORDER BY `last_name` ASC LIMIT 10"; $getEmp = mysqli_query($conn,$getEmpInfo); $statRow = mysqli_num_rows($getEmp); ?><table style="width:100%;border-collapse:collapse;"> <?php if($statRow > 0){ echo "<thead> <th style='width:20%;padding-left:2px;text-align:left;border:0px solid red'>REC.ID</thd> <th style='width:20%;padding-left:2px;text-align:left;border:0px solid red'>EMP. ID</th> <th style='width:60%;padding-left:2px;text-align:left;border:0px solid red'>EMPLOYEE NAME</th> </thead>"; while($eow = mysqli_fetch_array($getEmp)){ ?><tr onclick="javascript:getSearchEmpID(this);" style="width:100%"><?php echo "<td style='width:20%;border:0px solid red'>".$eow['id']."</td>"; echo "<td style='width:20%;border:0px solid red'>".$eow['emp_id']."</td>"; echo "<td style='width:60%;border:0px solid red'>".strtoupper($eow['last_name']).", ".strtoupper($eow['first_name'])."</td>"; echo "</tr>"; } }else{ echo "<h6 style='padding:20px;text-align:center'>No record found.</h6>"; } ?> </table> <?php $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings