File manager - Edit - /home/autoph/public_html/pms_v1/reports/searchDepartment.php
Back
<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['searchDept'])){ $searchText = $_POST['searchText']; $userID = $_POST['userID']; ?> <table class='table w-100'> <thead> <th>ID</th> <th>CODE</th> <th>DEPARTMENT</th> <th></th> </thead> <?php $sql="SELECT * FROM `pms_department_tbl` WHERE `deleted`=0 AND `dept_code` LIKE '%$searchText%' || `deleted`=0 AND `dept_name` LIKE '%$searchText%' ORDER BY `dept_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>".$row['dept_code']."</td>"; echo "<td>".$row['dept_name']."</td>"; echo "<td class='col-1 text-danger text-right'><a href='pdfViewer/kra_kra_department.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