Pregunta:
Fecha: 20-03-2019 07:53:23
(En Español)
No data available in table
Ayuda con PHP y MYSQL[Resuelta]
Hola comunidad me podrian apoyar con el siguiente problema que tengo, Agrege una fila con varios campos de forma manual en la base de datos pero no me lo muestra en una tabla en mi pagina me dice que no hay datos disponibles en la talbaNo data available in table
<?php
require_once("inc/functions.php");
if(!isset($_COOKIE["idUsuario"])) {
header("Location: login.php");
}
?>
<!DOCTYPE html>
<html>
<head><meta http-equiv="Content-Type" content="text/html; charset=gb18030">
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link rel="shortcut icon" href="favicon.ico" />
<link href="font-awesome/css/font-awesome.css" rel="stylesheet">
<link href="css/plugins/dataTables/datatables.min.css" rel="stylesheet">
<!-- Toastr style -->
<link href="css/plugins/toastr/toastr.min.css" rel="stylesheet">
<!-- Gritter -->
<link href="js/plugins/gritter/jquery.gritter.css" rel="stylesheet">
<link href="css/animate.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
</head>
<body class="fixed-sidebar skin-3">
<!-- inicia Modal eliminar-->
<form id="eliminarDatos">
<div class="modal fade" data-backdrop="static" data-keyboard="false" id="dataDelete" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<input type="hidden" id="idViaje" name="idViaje">
<h2 class="text-center text-muted">¿Decea Eliminar Viaje?</h2>
<p class="lead text-muted text-center" style="display: block;margin:10px">Esta acción eliminará de forma permanente el registro. ¿Deseas continuar?</p>
<div class="modal-footer">
<button type="button" class="btn btn-lg btn-default" data-dismiss="modal">Cancelar</button>
<button type="submit" class="btn btn-lg btn-primary">Aceptar</button>
</div>
</div>
</div>
</div>
</form>
<!--Fin Modal Eliminar-->
<div id="wrapper">
<?php require_once("inc/menu.php"); ?>
<div id="page-wrapper" class="gray-bg dashbard-1">
<div class="row border-bottom">
<nav class="navbar navbar-static-top" role="navigation" style="margin-bottom: 0">
<div class="navbar-header">
<a class="navbar-minimalize minimalize-styl-2 btn btn-success " href="#"><i class="fa fa-bars"></i> </a>
</div>
<ul class="nav navbar-top-links navbar-right">
<li>
<a href="inc/logout.php">
<i class="fa fa-sign-out"></i>Cerrar sesión
</a>
</li>
</ul>
</nav>
</div>
<div class="datos_ajax_delete"></div><!-- Datos ajax Final -->
<div class="datos_ajax_dato"></div>
<div class="row border-bottom white-bg dashboard-header">
<h1 style='font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif;font-weight: 400;color:#000;'>Mercancias</h1>
</div>
<div class="table-responsive" style="padding-top:20px;">
<a href="nuevo-certificado.php" class="btn btn-outline btn-success" style="margin-bottom:20px;">Generar Certificado</a>
<table class="table table-striped table-bordered table-hover dataTables-example" >
<thead>
<tr>
<th>FOLIO</th>
<th>FECHA</th>
<th>FACTURA</th>
<th>ASEGURADO</th>
<th>COSTO</th>
<th>IMPORTE ASEGURADO</th>
<th>ACCIONES</th>
</tr>
</thead>
<tbody>
<?php
if($_COOKIE["lvl"]==1){
$result=query("SELECT V.idCliente, V.Cliente, V.rfc, V.moneda, V.mercancia, V.importe, V.TipoOperacion, V.FechaAlta, V.detalles, V.TipoTransporte, V.FechaSalida, V.FechaLlegada, V.folio, V.porigen, V.eorigen, V.corigen, V.pdestino, V.edestino, V.cdestino, V.poliza, V.cuota, V.prima, V.gastosexp, V.iva, V.total FROM merca V LEFT JOIN clientes C ON V.idCliente=C.idCliente ORDER BY V.idViaje DESC LIMIT 0,1000");
}else{
$result=query("SELECT V.idViaje,V.Referencia,V.CartaPorte,C.RazonSocial AS Cliente,V.Destino,V.Contenedor1,V.Contenedor2,V.Contenedor3,V.FechaAlta FROM viajes V LEFT JOIN clientes C ON V.idCliente=C.idCliente WHERE V.idCliente=".$_COOKIE["idUsuario"]." ORDER BY V.idViaje DESC LIMIT 0,200");
?>
<tr class="gradeA" style="text-align:center;">
<td><?php echo $row["idViaje"]; ?></td>
<td><?php echo $row["FechaAlta"]; ?></td>
<td><?php echo $row["folio"]; ?></td>
<td><?php echo $row["Cliente"]; ?></td>
<td><?php echo $row["total"]; ?></td>
<td><?php echo $row["importe"]; ?></td>
<td style="width:16%">
<a title="Pdf" href="poliza-mercancia.php?id=<?php echo $row["idViaje"]; ?>" target="_blank" class="btn btn-info btn-bitbucket btn-sm"><i class="fa fa-file-pdf-o "></i></a>
<?php
if($_COOKIE["lvl"]==1){
?>
<a title="Editar" href="modificar-viaje.php?id=<?php echo $row["idViaje"]; ?>" class="btn btn-warning btn-bitbucket btn-sm"><i class="fa fa-pencil"></i></a>
<button title="Eliminar" type="button" class="btn btn-danger btn-sm" data-toggle="modal" data-target="#dataDelete" data-id="<?php echo $row['idViaje']?>" ><i class='glyphicon glyphicon-trash'></i></button>
<?php
}
?>
</td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr>
<th>FOLIO</th>
<th>FECHA</th>
<th>FACTURA</th>
<th>ASEGURADO</th>
<th>COSTO</th>
<th>IMPORTE ASEGURADO</th>
<th>ACCIONES</th>
</tr>
</tfoot>
</table>
</div>
</div>
</div>
<div class="modal inmodal" id="myModal" tabindex="-1" role="dialog" aria-hidden="true" style="display: none;">
<div class="modal-dialog">
<div class="modal-content animated bounceInRight">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button>
<i class="fa fa-laptop modal-icon"></i>
<h4 class="modal-title">Modal title</h4>
<small class="font-bold">Lorem Ipsum is simply dummy text of the printing and typesetting industry.</small>
</div>
<div class="modal-body">
<p><strong>Lorem Ipsum is simply dummy</strong> text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown
printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting,
remaining essentially unchanged.</p>
<div class="form-group"><label>Sample Input</label> <input type="email" placeholder="Enter your email" class="form-control"></div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-white" data-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary">Save changes</button>
</div>
</div>
</div>
</div>
<!-- Mainly scripts -->
<script src="js/jquery-3.1.1.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/plugins/metisMenu/jquery.metisMenu.js"></script>
<script src="js/plugins/slimscroll/jquery.slimscroll.min.js"></script>
<script src="js/plugins/dataTables/datatables.min.js"></script>
<!-- Custom and plugin javascript -->
<script src="js/inspinia.js"></script>
<script src="js/plugins/pace/pace.min.js"></script>
<!-- jQuery UI -->
<script src="js/plugins/jquery-ui/jquery-ui.min.js"></script>
<!-- Page-Level Scripts -->
<script>
$('#dataDelete').on('show.bs.modal', function (event) {
var button = $(event.relatedTarget) // Botón que activó el modal
var id = button.data('id') // Extraer la información de atributos de datos
var modal = $(this)
modal.find('#idViaje').val(id)
})
$( "#eliminarDatos" ).submit(function( event ) {
var parametros = $(this).serialize();
$.ajax({
type: "POST",
url: "eliminar-viaje.php",
data: parametros,
beforeSend: function(objeto){
$(".datos_ajax_delete").html("Mensaje: Cargando...");
},
success: function(datos){
$(".datos_ajax_delete").html(datos);
var url = "mercancias.php";
setTimeout(function(){
$(location).attr('href',url);},2000);
$('#dataDelete').modal('hide');
load(1);
}
});
event.preventDefault();
});
$(document).ready(function(){
$('.dataTables-example').DataTable({
pageLength: 10,
responsive: true,
"order": [[ 0, "desc" ]],
dom: '<"html5buttons"B>lTfgitp',
buttons: [
{extend: 'copy'},
{extend: 'csv'},
{extend: 'excel', title: 'ExampleFile'},
{extend: 'pdf', title: 'ExampleFile'},
{extend: 'print',
customize: function (win){
$(win.document.body).addClass('white-bg');
$(win.document.body).css('font-size', '10px');
$(win.document.body).find('table')
.addClass('compact')
.css('font-size', 'inherit');
}
}
]
});
});
</script>
</body>
</html>
Votos: 0 -
Respuestas: 2 -
Vistas: 8
Compartir en: Google
Facebook
Twitter
LinkedIn
Link
Respuestas:
-
-
Fecha: 20-03-2019 08:15:13 Si existe, la utilizo para identificar si eres administrador o usuario Votos: 0 - Link respuesta
Para participar activamente de la comunidad primero debes autenticarte, ingresa al sistema.Iniciar Sesión
