File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/API/GetOneComView.php
Back
<?php require_once("Connection.php"); if(isset($_GET['id'])) { $id = $_GET['id']; $sql = "SELECT `model_master_table`.`picture` AS 'PIC',`solu_request_table`.`sr_id` AS 'SR_ID',`client_table`.`name` AS 'FNAME',`client_table`.`surname` AS 'LNAME',`client_table`.`mobile_no` AS 'MO_NUM',`model_master_table`.`model_name` AS 'MODEL',`solu_type_table`.`solution_name` AS 'SOLU_NAME',`solu_type_price`.`price` AS 'SOLU_PRICE',`solu_request_table`.`additional_amount` AS 'ADD_AMNT',`offer_table`.`offer_discount` AS 'DIS' FROM `model_master_table`,`solu_request_table`,`client_table`,`solu_type_table`,`solu_type_price`,`offer_table`,`vehicle_table`,`solu_details` WHERE `vehicle_table`.`vehicle_id` = `solu_request_table`.`vehicle_id` AND `solu_request_table`.`client_id` = `client_table`.`client_id` AND `solu_details`.`sr_id` = `solu_request_table`.`sr_id` AND `solu_type_table`.`solution_id` = `solu_details`.`solution_id` AND `model_master_table`.`model_id` = `vehicle_table`.`mo_id` AND `offer_table`.`offer_id` = `solu_request_table`.`offer_id` AND `solu_type_price`.`solution_id` = `solu_details`.`solution_id` AND `solu_type_price`.`vc_id` = `model_master_table`.`vehicle_cat` AND `solu_request_table`.`status` = 'COMPLETED' AND `solu_request_table`.`sr_id` = $id"; $rows = $con->query($sql); if($rows->num_rows > 0) { $Requests["Requests"] = array(); while($row = $rows->fetch_assoc()) { $Request = array(); $Request = $row; array_push($Requests["Requests"],$Request); } $Requests["success"] = 1; } else { $Requests["success"] = 0; } echo json_encode($Requests); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings