File manager - Edit - /home/autoph/public_html/pms_v1/reports/loadCompany.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); include '../css/mainCSS.php'; //error_reporting(0); if(isset($_POST['searchEmP'])){ $searchText = $_POST['searchText']; $userID = $_POST['userID']; if($searchText==""){ $getPCPHeaders = "SELECT * FROM `vts_company` WHERE `comp_status`=1 ORDER BY `comp_name` ASC"; }else{ $getPCPHeaders = "SELECT * FROM `vts_company` WHERE `comp_status`=1 AND `comp_name` LIKE '%$searchText%' || `comp_status`=1 AND `comp_code` LIKE '%$searchText%' ORDER BY `comp_name` ASC"; } $pcpHead = mysqli_query($conn,$getPCPHeaders); $statRow = mysqli_num_rows($pcpHead); echo "<table class='w-100'>"; echo "<thead>"; echo "<th class='PeachBG'>ID</th>"; echo "<th class='PeachBG'>CODE</th>"; echo "<th class='PeachBG'>COMPANY NAME</th>"; echo "<th class='PeachBG'></th>"; echo "</thead>"; while($row = mysqli_fetch_array($pcpHead)){ ?><tr onclick="javascript:pcpSelection(this);" ><?php echo "<td class='text-dark'>".$row['comp_id']."</td>"; echo "<td class='cotext-darkl'>".$row['comp_code']."</td>"; echo "<td class='text-dark'>".$row['comp_name']."</td>"; echo "<td style='width:3%'>";?> <!--<abbr title='View KRA'><i class='fa fa-plus-circle' aria-hidden='true' style='cursor:pointer;color:green;float:right;font-size:18px'></i> </abbr>--> <i onClick="window.open('./pdfViewer/RPTEmployee_listByCompany.php?id=<?php echo $row['comp_id'];?>&source=<?php echo $userID;?>')" class="fa fa-print" style='cursor:pointer;color:green;float:right;font-size:16px'></i> <?php echo "</td>"; echo "<tr>"; } echo "</table>"; $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings