Файловый менеджер - Редактировать - /home2/cocinasdalloway/lotes.cocinasdalloway.com/components/data/detalle.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'); // Database connection parameters include("../config/config.php"); // Create a database connection $conn = new mysqli($host, $username, $password, $database); // Check if the connection was successful if ($conn->connect_error) { die(json_encode(["error" => "Connection failed: " . $conn->connect_error])); } // Get user input //$data = json_decode(file_get_contents("php://input")); //$id = $data->Id; $id=$_GET['id']; // Query the database to check if the user exists $query = "SELECT * FROM MedidasLotes T0 INNER JOIN Colonias T1 ON T0.colonia = T1.id WHERE T0.activo='si' AND T0.id=$id"; $result = $conn->query($query); $row_cnt = $result->num_rows; $cont=1; $data=""; $color=""; while ($row = mysqli_fetch_array($result)) { if($cont==$row_cnt){ $data.='{"Nombre":"'.$row['nombre'].'", "Estatus":"'.$row['estatus'].'", "Colonia":"'.$row['descripcion'].'", "Costo":"'.number_format($row['costo'],2).'","Esq1":"'.$row['corner1Lat'].'/'.$row['corner1Lon'].'", "Esq2":"'.$row['corner2Lat'].'/'.$row['corner2Lon'].'", "Esq3":"'.$row['corner3Lat'].'/'.$row['corner3Lon'].'", "Esq4":"'.$row['corner4Lat'].'/'.$row['corner4Lon'].'", "IdCliente":"'.$row['idCliente'].'"}'; } $cont++; } $data.=''; echo ($data); /* const polygonsData = [ { id: 1, coords: [ { lat: 21.2164, lng: -99.4748 }, // Top left corner { lat: 21.2164, lng: -99.4745 }, // Top right corner { lat: 21.2168, lng: -99.4745 }, // Bottom right corner { lat: 21.2168, lng: -99.4748 }, // Bottom left corner ] }, { id: 2, coords: [ { lat: 21.2160, lng: -99.4744 }, // Top left corner { lat: 21.2160, lng: -99.4740 }, // Top right corner { lat: 21.2164, lng: -99.4740 }, // Bottom right corner { lat: 21.2164, lng: -99.4744 }, // Bottom left corner ] } ]; */ ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.22 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка