File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/API/GetMembership.php
Back
<?php if(isset($_GET['C_ID'])) { require_once("Connection.php"); $id = $_GET['C_ID']; $sql = "SELECT `amc_membership_table`.`amc_membership_id` AS 'AMC_ID',`amc_membership_table`.`amc_membership_name` AS 'AMC_NAME',`amc_membership_table`.`no_of_solution` AS 'NO_OF_SOLU',`amc_membership_table`.`duration_month` AS 'DURA',`amc_membership_table`.`description` AS 'DESC',`amc_membership_table`.`price` AS 'PRICE',`solu_type_table`.`solution_name` AS 'SOLU_NAME',`amc_member_table`.`starting_date` 'S_DATE',`amc_member_table`.`ending_date` AS 'E_DATE',`amc_member_table`.`used_solution` AS 'USED_SOLU' FROM `amc_member_table`,`amc_membership_table`,`solu_type_table`WHERE `amc_membership_table`.`amc_membership_id` = `amc_member_table`.`amc_membership_id` AND `amc_membership_table`.`solution_id` = `solu_type_table`.`solution_id` AND `amc_member_table`.`client_id` = ".$id; $rows = $con->query($sql); if($rows->num_rows > 0) { $Memberships["Memberships"] = array(); while($row = $rows->fetch_assoc()) { $Membership = array(); $Membership = $row; array_push($Memberships["Memberships"],$Membership); } $Memberships["success"] = 1; } else { $Memberships["success"] = 0; } echo json_encode($Memberships); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings