"IVeR"); $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn === false ) { echo "Could not connect.\n"; die( print_r( sqlsrv_errors(), true)); } $data = json_decode(file_get_contents('php://input'), true); if($data['type'] =='save'){ $nombre = $data['nombre']; $cuip = $data['cuip']; $lat = $data['lat']; $lng = $data['lng']; $time = new DateTime(); $id = 1; $estatus = $data['estatus']; $tsql = "EXEC savePersonal ?,?,?,?,?,?"; $stmt = sqlsrv_prepare($conn, $tsql,array(&$nombre, &$cuip, &$estatus, &$time, &$lat, &$lng)); if( sqlsrv_execute( $stmt ) === false ) { die( print_r( sqlsrv_errors(), true)); } $res['status'] = 'Guardado ok'; $res['result'] = ''; print json_encode($res); }else{ /* Set up the Transact-SQL query. */ $tsql = "SELECT per.*, es.estatus as 'EstatusTexto' FROM personal per LEFT JOIN cat_estatusPersonal es on es.id = per.estatus"; /* Execute the query. */ $stmt = sqlsrv_query($conn, $tsql); $result = array(); do { while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){ $result[] = $row; } } while (sqlsrv_next_result($stmt)); echo json_encode($result); } sqlsrv_free_stmt( $stmt); sqlsrv_close( $conn); ?>