File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/API/GetSchedules.php
Back
<?php if(isset($_GET['id'])) { require_once("Connection.php"); $id = $_GET['id']; $sql = "SELECT `emp_schedule_table`.`sr_id` AS 'SR_ID',`emp_schedule_table`.`emp_id` AS 'EMP_ID',`req_schedule_table`.`pick_datetime` AS 'PICK_DATE',`req_schedule_table`.`pic_pref_time` AS 'PICK_TIME',`req_schedule_table`.`del_datetime` AS 'DELI_DATE',`req_schedule_table`.`del_pref_time` AS 'DELI_TIME' FROM `req_schedule_table`,`emp_schedule_table` WHERE `emp_schedule_table`.`sr_id` = `req_schedule_table`.`sr_id` AND `emp_schedule_table`.`emp_id` = ".$_GET['id']; $rows = $con->query($sql); if($rows->num_rows > 0) { $Schedules["Schedules"] = array(); while($row = $rows->fetch_assoc()) { $Schedule = array(); $Schedule = $row; array_push($Schedules["Schedules"],$Schedule); } $Schedules["success"] = 1; } else { $Schedules["success"] = 0; } echo json_encode($Schedules); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings