Файловый менеджер - Редактировать - /home2/cocinasdalloway/lotes.cocinasdalloway.com/components/colonias/addCoordenadas.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'] === 'POST') { 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 TI'); echo json_encode($arr); exit; } // Get POST data $idColonia=$_GET['id']; $data = json_decode(file_get_contents("php://input"),true); // Prepare and execute SQL statements to save the data $sql=''; if ($data && is_array($data)) { foreach ($data as $item) { $latitud = $item['name']; $longitud = $item['value']; $sql = "INSERT INTO ColoniasCoordenadas (id,idColonia,latitud,longitud,activo) VALUES ('','$idColonia','$latitud', '$longitud','si')"; if ($conn->query($sql) !== true) { $arr = array('status' => 100, 'detail' => 'error', 'message' => 'Error al insertar datos, detalle: '.$conn->error); echo json_encode($arr); break; // If an error occurs, you can choose to handle it as needed } } //$sql = "INSERT INTO ColoniasCoordenadas (id,idColonia,latitud,longitud,activo) VALUES ('','$idColonia','$latitud', '$longitud','si')"; $arr = array('status' => 200, 'detail' => 'success', 'message' => 'Se agrego correctamente'); echo json_encode($arr); $conn->close(); }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => 'Datos invalidos'); 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
|
Настройка