Файловый менеджер - Редактировать - /home2/cocinasdalloway/lotes.cocinasdalloway.com/components/data/getById.php
Назад
<?php header("Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method"); header('Access-Control-Allow-Origin: *'); header("Content-Type: application/json"); if ($_SERVER['REQUEST_METHOD'] === 'GET') { date_default_timezone_set('America/Mexico_City'); $hoy=date('Y-m-d H:i:s'); //Archivo de Configuracion include("../config/config.php"); mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); try{ //Crear Objeto para conexion $conn = new mysqli($host, $username, $password, $database); } catch (Exception $e) { //echo $e->getMessage(); $arr = array('status' => 100, 'detail' => 'error', 'message' => 'Error de conexion. Contacte a soporte'); echo json_encode($arr); exit; } $data = json_decode(file_get_contents("php://input")); $id = $_GET['id']; // Read all clients $sql = "SELECT t0.id,t0.idUsuario,t0.nombre, t0.estatus, t0.colonia, t0.costo, t0.corner1Lat, t0.corner1Lon, t0.corner2Lat, t0.corner2Lon, t0.corner3Lat, t0.corner3Lon, t0.corner4Lat, t0.corner4Lon, t0.activo, T1.descripcion, T1.id AS IdColonia FROM MedidasLotes t0 INNER JOIN Colonias T1 ON t0.colonia = T1.id WHERE t0.activo='si' AND t0.id=$id"; $result = $conn->query($sql); if ($result->num_rows > 0) { $clients = []; while ($row = $result->fetch_assoc()) { $clients[] = $row; } $arr = array('status' => 200, 'detail' => 'success', 'data' => $clients); echo json_encode($arr); } else { $arr = array('status' => 200, 'detail' => 'success', 'data' => []); echo json_encode($arr); } }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => 'No existe servicio de la API'); echo json_encode($arr); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.22 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка