File manager - Edit - /home/autoph/public_html/pms_v1/reports/searchGroup.php
Back
<?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['searchEmP'])){ $searchText = $_POST['searchText']; $userID = $_POST['userID']; ?> <table class='table w-100'> <thead> <th class='col-1 bg-light text-dark'>ID</th> <th class='col-1 bg-light text-dark'>CODE</th> <th class='col-9 bg-light text-dark'>GROUP NAME</th> <th class='col-1 bg-light text-dark'></th> </thead> <?php $sql="SELECT * FROM `pms_sub_group` WHERE `deleted`=0 AND `sub_group_code` LIKE '%$searchText%' || `deleted`=0 AND `sub_group_name` LIKE '%$searchText%' ORDER BY `sub_group_name` ASC LIMIT 20"; $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['sub_group_code']."</td>"; echo "<td>".$row['sub_group_name']."</td>"; echo "<td class='col-1 text-danger text-right'><a href='pdfViewer/kra_kra_group.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