File manager - Edit - /home/autoph/public_html/portal/includes/phic/monthly_list.php
Back
<div style='overflow:auto;border-radius:0px 0px 5px 5px;padding:5px;position:relative;height:500px;width:98.7%;border:1px solid #000;background:#fff'> <table style='width:100%;border-collapse:collapse'> <tr> <th style='width:5%'>No.</th> <th style='width:10%'>Ref.No.</th> <th style='width:25%'>Date Covered</th> <th style='width:35%'>Branch ID.</th> <th style='width:10%'>Amount</th> <th style='width:10%'>Encoded By</th> <th style='width:10%'>View</th> </tr> <?php $getMon =$_GET['code']; $getYear =$_GET['search']; $startDate = $getMon ."/01/".$getYear; $endDate = $getMon ."/31/".$getYear; $getU = mysql_query("SELECT * FROM `phic_claim_summary` WHERE `start_date` BETWEEN '$startDate' AND '$endDate' ORDER by `start_date` ASC"); while($myMT = mysql_fetch_array($getU)){ $branch = $myMT['branch_code']; $bname=mysql_result(mysql_query("SELECT `company_name` FROM `company` WHERE `company_id`=$branch"),0); $count = $count + 1; echo "<tr>"; echo "<td>".$count."</td>"; echo "<td style='text-align:center;padding-left:0px;'>".$myMT['ref_number']."</td>"; echo "<td style='text-align:center;padding-left:0px;'>".$myMT['start_date']." - ".$myMT['end_date']."</td>"; echo "<td style='text-align:left;padding-left:10px;'>".$bname."</td>"; echo "<td style='text-align:center;padding-left:10px;'>".$myMT['amount']."</td>"; echo "<td style='text-align:center;padding-left:10px;'>".$myMT['created_by']."</td>"; echo "<td style='text-align:center;'><a href='phic_claims.php?comp=$branch&ed=$startDate&sd=$endDate&search=$startDate&searchBy=Date Covered&lookup=Search&id=".$myMT['id']."&view=dtl'><ABBR title='View Details'><img src='images/searchbutton.png' width='20px' ></img></a></ABBR></td>"; echo "<tr>"; } ?> <table> </div>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings