File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/API/GetAllUserOrder.php
Back
<?php if(isset($_GET['id'])) { require_once("Connection.php"); $id = $_GET['id']; $sql = "SELECT `model_master_table`.`picture` AS 'PIC',`model_master_table`.`model_name` AS 'MODEL',`vehicle_table`.`vehicle_no` AS 'VEHI_NUM',`req_schedule_table`.`pick_datetime` AS 'PICK_DATE',`req_schedule_table`.`pic_pref_time` AS 'PICK_TIME',`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`,`req_schedule_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 `req_schedule_table`.`sr_id` = `solu_request_table`.`sr_id` AND `solu_request_table`.`client_id` = $id"; $rows = $con->query($sql); if($rows->num_rows > 0) { $Orders["Orders"] = array(); while($row = $rows->fetch_assoc()) { $Order = array(); $Order = $row; array_push($Orders["Orders"],$Order); } $Orders["success"] = 1; } else { $Orders["success"] = 0; } echo json_encode($Orders); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings