File manager - Edit - /home/autoph/public_html/pms_v1/apr/searchEmployee.php
Back
<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['iSearch'])){ $searchString= $_POST['sEmpl']; $getUnit = "SELECT * FROM `pms_employee_data` WHERE `deleted`=0 AND `first_name` LIKE '%$searchString%' || `deleted`=0 AND `last_name` LIKE '%$searchString%' || `deleted`=0 AND `emp_id` LIKE '%$searchString%' ORDER BY `last_name` ASC LIMIT 20"; $getU = mysqli_query($conn,$getUnit); $statRow = mysqli_num_rows($getU); while($row = mysqli_fetch_array($getU)){ ?><tr onclick="javascript:employeeMenuID(this);" ><?php echo "<td class='menuItem'>".$row['id']."</td>"; echo "<td class='menuItem'>".$row['last_name'].", ".$row['first_name']." - ".$row['emp_id']."</td>"; echo "</tr>"; } $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings