Файловый менеджер - Редактировать - /home2/cocinasdalloway/lotes.cocinasdalloway.com/Administrador/Home/import.php
Назад
<?php @session_start(); $idUsuario=$_SESSION["lt_id"]; include("../models/connection/config.php"); mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); try{ //Crear Objeto para conexion $conexion = new mysqli($host, $user, $pass, $db); } catch (Exception $e) { //echo $e->getMessage(); $arr = array('status' => 100, 'detail' => 'error', 'message' => 'Error de conexion. Contacte a TI: '.$e->getMessage()); echo json_encode($arr); exit; } $varJson=(json_decode($_POST['myData'])); $Total = count($varJson); $insert=''; $cont=0; if($Total>0){ /* Start transaction */ $conexion->begin_transaction(); try{ foreach($varJson as $mydata) { $costo=str_replace(",","",$mydata[1]); $costo=str_replace("$","",$costo); $addPanel="INSERT INTO MedidasLotes ( id, idUsuario, idCliente, nombre, estatus, costo, corner1Lat, corner1Lon, corner2Lat, corner2Lon, corner3Lat, corner3Lon, corner4Lat, corner4Lon, activo ) VALUES( '', '$idUsuario', '0', '".$mydata[0]."', 'Pendiente', '".$costo."', '".$mydata[2]."', '".$mydata[3]."', '".$mydata[4]."', '".$mydata[5]."', '".$mydata[6]."', '".$mydata[7]."', '".$mydata[8]."', '".$mydata[9]."', 'si' )"; $res_add=$conexion -> query($addPanel); $cont++; } $conexion->commit(); } catch (Exception $e) { $conexion->rollback(); //echo $e->getMessage(); $arr = array('status' => 100, 'detail' => 'error', 'message' => "Error. Contacte a TI [".$e->getMessage().$totalF."]"); echo json_encode($arr); exit; } $arr = array('status' => 200, 'detail' => 'success', 'message' => 'Se agregaron '.$cont.' registros'); echo json_encode($arr); }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => 'Error: No se encontro informacion'); echo json_encode($arr); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.22 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка