File manager - Edit - /home/autoph/public_html/pms_v1/ajaxCall/onChangeLoadCompanyKPI.php
Back
<?php include_once("../../../cfg/conn.php"); error_reporting(0); if(isset($_POST['loadKPI'])){ $groupKRAid = $_POST['groupKRAid']; //GET THE HIGHER KRA ID TO QUERY THE HIGER KPI $getTopKRAID = "SELECT `comp_kra_id` FROM `kra_branch_tbl` WHERE `id`='$groupKRAid'"; $getKRA = mysqli_query($conn,$getTopKRAID); while($Trow = mysqli_fetch_array($getKRA)){ $topKRAITD = $Trow['comp_kra_id']; } echo "<option>".$$topKRAITD."</option>"; $getBranchList = "SELECT * FROM `kpi_company` WHERE `deleted`='0' AND `kra_id`='$topKRAITD' ORDER BY `kpi_name` ASC"; $getBranch = mysqli_query($conn,$getBranchList); echo "<option value=''>--Select--</option>"; while($row = mysqli_fetch_array($getBranch)){ echo "<option value='".$row['id']."'>".$row['kpi_name']."</option>"; } $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings