Файловый менеджер - Редактировать - /home2/cocinasdalloway/lotes.cocinasdalloway.com/components/data/data.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])); } $idUS=$_GET['id']; // Query the database to check if the user exists $query = "SELECT * FROM MedidasLotes WHERE activo='si' AND idUsuario=$idUS"; $result = $conn->query($query); $row_cnt = $result->num_rows; $cont=1; $data="["; $color=""; while ($row = mysqli_fetch_array($result)) { if($row['estatus']=='Vendido'){ $color="#FF0000"; }else{ $color="#25AA23"; } // $data.="{ id: ".$row['id'].", coords: [{lat: ".$row['corner1Lat'].", lng: ".$row['corner1Lon']." },{ lat: ".$row['corner2Lat'].", lng: ".$row['corner2Lon']." },{ lat: ".$row['corner3Lat'].", lng: ".$row['corner3Lon']." },{ lat: ".$row['corner4Lat'].", lng: ".$row['corner4Lon']." }]},"; if($cont==$row_cnt){ $data.='{"color":"'.$color.'", "id":'.$row['id'].', "idCol":'.$row['colonia'].', "coords":[{"lat": '.$row['corner1Lat'].', "lng": '.$row['corner1Lon'].' },{ "lat": '.$row['corner2Lat'].', "lng": '.$row['corner2Lon'].' },{ "lat": '.$row['corner3Lat'].', "lng": '.$row['corner3Lon'].' },{ "lat": '.$row['corner4Lat'].', "lng": '.$row['corner4Lon'].'} ] }'; // $data.='[{"lat": '.$row['corner1Lat'].', "lng": '.$row['corner1Lon'].' },{ "lat": '.$row['corner2Lat'].', "lng": '.$row['corner2Lon'].' },{ "lat": '.$row['corner3Lat'].', "lng": '.$row['corner3Lon'].' },{ "lat": '.$row['corner4Lat'].', "lng": '.$row['corner4Lon'].' }],'; }else{ $data.='{"color":"'.$color.'", "id":'.$row['id'].', "idCol":'.$row['colonia'].', "coords":[{"lat": '.$row['corner1Lat'].', "lng": '.$row['corner1Lon'].' },{ "lat": '.$row['corner2Lat'].', "lng": '.$row['corner2Lon'].' },{ "lat": '.$row['corner3Lat'].', "lng": '.$row['corner3Lon'].' },{ "lat": '.$row['corner4Lat'].', "lng": '.$row['corner4Lon'].'} ] },'; } $cont++; } $data.=']'; echo ($data); // echo '[[{"lat": 21.216400, "lng": -99.474800 },{ "lat": 21.216400, "lng": -99.474500 },{ "lat": 21.216800, "lng": -99.474500 },{ "lat": 21.216800, "lng": -99.474800 }],[{"lat": 21.216000, "lng": -99.474400 },{ "lat": 21.216000, "lng": -99.474000 },{ "lat": 21.216400, "lng": -99.474000 },{ "lat": 21.216400, "lng": -99.474400 }]]'; /* 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
|
Настройка