File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/API/GetAllRequest.php
Back
<?php require_once("Connection.php"); if(isset($_GET['id'])) { $eid = $_GET['id']; $sql = "SELECT `solu_request_table`.`sr_id` AS 'SR_ID',`solu_request_table`.`status` AS 'SOLU_NAME',`client_table`.`name` AS 'FNAME',`client_table`.`surname` AS 'LNAME',`model_master_table`.`picture` AS 'PIC' FROM `solu_request_table`,`client_table`,`model_master_table`,`vehicle_table`,`emp_schedule_table` WHERE `client_table`.`client_id` = `solu_request_table`.`client_id` AND `vehicle_table`.`vehicle_id` = `solu_request_table`.`vehicle_id` AND `model_master_table`.`model_id` = `vehicle_table`.`mo_id` AND `emp_schedule_table`.`sr_id` = `solu_request_table`.`sr_id` AND `solu_request_table`.`status` != 'COMPLETED' AND `emp_schedule_table`.`emp_id` = $eid ORDER BY `solu_request_table`.`sr_id` DESC "; $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.03 |
proxy
|
phpinfo
|
Settings