File manager - Edit - /home/autoph/public_html/pms_v1/mancom/loadMancomReport.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['rptMan'])){ $companyID = $_POST['selectedCompanyID']; $userID = $_POST['userID']; $getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$companyID' AND deleted = 0 ORDER BY `year` DESC"; $qHeads = mysqli_query($conn,$getMansHead); $qhRow = mysqli_num_rows($qHeads); if($qhRow > 0){ while($rec = mysqli_fetch_array($qHeads)){ ?><tr onclick="javascript:getInfo(this);" style="width:100%"><?php echo "<td class='text-left p-2'>".$rec['id']."</td>"; echo "<td class='text-left p-2'>".$rec['year']."</td>"; echo "<td class='text-left p-2'>".getCompanyNameSub($rec['company_id'])[1]."</td>"; echo "<td class='text-left p-2'>".getDealerNameSub($rec['dealer_id'])[1]."</td>"; echo "<td class='text-left p-2'>"; $update = explode(" ", $rec['last_update']); $updateDate = $update[0]; echo $updateDate; echo "</td>"; echo "<td style='border:0px solid red;color:gray;font-family:Calibri;font-size:18px;font-weight:normal'> <i data-toggle='modal' data-target='#updateMancom' class='fa fa-list' aria-hidden='true'></i> </td>"; echo "</tr>"; } }else{ echo "<tr><td colspan='6'><div class='col-lg-12 text-dark p-5 text-center'>No record found.</div></td></tr>"; } $conn->close(); }
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings