File manager - Edit - /home/autoph/public_html/pms_v1/reports/searchEmployee.php
Back
<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['searchSec'])){ $searchText = $_POST['searchText']; $userID = $_POST['userID']; include ("../functions/users.php"); ?> <table class='table w-100'> <thead> <th class='col-1'>ID</th> <th class='col-1'>COMP</th> <th class='col-1'>DEAL</th> <th class='col-5'>EMPLOYEE NAME</th> <th class='col-2'>POSITION</th> <th></th> </thead> <?php $sql="SELECT * FROM `pms_employee_data` WHERE `deleted`=0 AND `first_name` LIKE '%$searchText%' || `deleted`=0 AND `last_name` LIKE '%$searchText%' || `deleted`=0 AND `employee_id` LIKE '%$searchText%'ORDER BY `last_name` ASC LIMIT 50"; $qSql = mysqli_query($conn,$sql); $trow = mysqli_num_rows($qSql); if($trow > 0){ while($row = mysqli_fetch_array($qSql)){ ?><tr onclick="javascript:getInfo(this);" ><?php echo "<td>".$row['id']."</td>"; echo "<td>".getCompanyNameSub($row['comp_id'])[1]."</td>"; echo "<td>".getDealerNameSub($row['branch_id'])[1]."</td>"; echo "<td>".$row['last_name'].", ".$row['first_name']."</td>"; echo "<td>".getPositionName($row['position'])[0]."</td>"; echo "<td class='col-1 text-danger text-right'><a href='pdfViewer/kra_kra_employee.php?groupID=".$row['id']."&source=".$userID."' target='_blank'><i class='fa fa-file-pdf-o text-danger' style='font-size:16px'></i></a></td>"; echo "</tr>"; } }else{ echo "<tr>"; echo "<td colspan=4 style='padding:50px;text-align:center;border:0px solid white'>No record found.</td>"; echo "</tr>"; } ?> </table> <?php } $conn->close(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings