File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/API/GetCompletedOrders.php
Back
<?php require_once("Connection.php"); if(isset($_GET['id'])) { $eid = $_GET['id']; $sql = "SELECT `model_master_table`.`picture` AS 'PIC',`model_master_table`.`model_name` AS 'MODEL',`vehicle_table`.`vehicle_no` AS 'VEHI_NUM',`solu_request_table`.`status` AS 'STATUS',`solu_type_table`.`solution_name` AS 'SOLU_NAME',`solu_request_table`.`sr_id` AS 'SR_ID' FROM `model_master_table`,`vehicle_table`,`solu_request_table`,`solu_type_table`,`solu_details` WHERE `model_master_table`.`model_id` = `vehicle_table`.`mo_id` AND `vehicle_table`.`vehicle_id` = `solu_request_table`.`vehicle_id` AND `solu_type_table`.`solution_id` = `solu_details`.`solution_id` AND `solu_details`.`sr_id` = `solu_request_table`.`sr_id` AND `solu_request_table`.`status` = 'COMPLETED' AND `solu_request_table`.`client_id` = $eid"; $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.01 |
proxy
|
phpinfo
|
Settings