| Server IP : 184.154.167.98 / Your IP : 3.22.71.149 Web Server : Apache System : Linux pink.dnsnetservice.com 4.18.0-553.22.1.lve.1.el8.x86_64 #1 SMP Tue Oct 8 15:52:54 UTC 2024 x86_64 User : puertode ( 1767) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/puertode/www/libreria/ |
Upload File : |
<!DOCTYPE html>
<?php
require_once 'valid.php';
?>
<html lang = "eng">
<head>
<title>Sistema de Biblioteca | Platea21</title>
<meta charset = "utf-8" />
<meta name = "viewport" content = "width=device-width, initial-scale=1" />
<link rel = "stylesheet" type = "text/css" href = "css/bootstrap.css" />
<link rel = "stylesheet" type = "text/css" href = "css/jquery.dataTables.css" />
</head>
<body style = "background-color:#d3d3d3;">
<nav class = "navbar navbar-default navbar-fixed-top">
<div class = "container-fluid">
<div class = "navbar-header">
<img src = "images/logo.png" width = "50px" height = "50px" />
<h4 class = "navbar-text navbar-right">Sistema de Biblioteca | Platea21</h4>
</div>
</div>
</nav>
<div class = "container-fluid">
<div class = "col-lg-2 well" style = "margin-top:60px;">
<div class = "container-fluid" style = "word-wrap:break-word;">
<img src = "images/user.png" width = "50px" height = "50px"/>
<br />
<br />
<label class = "text-muted"><?php require'account.php'; echo $name;?></label>
</div>
<hr style = "border:1px dotted #d3d3d3;"/>
<ul id = "menu" class = "nav menu">
<li><a style = "font-size:18px; border-bottom:1px solid #d3d3d3;" href = "home.php"><i class = "glyphicon glyphicon-home"></i> Inicio</a></li>
<li><a style = "font-size:18px; border-bottom:1px solid #d3d3d3;" href = ""><i class = "glyphicon glyphicon-tasks"></i> Cuentas</a>
<ul style = "list-style-type:none;">
<li><a href = "admin.php" style = "font-size:15px;"><i class = "glyphicon glyphicon-user"></i> Administrador</a></li>
<li><a href = "student.php" style = "font-size:15px;"><i class = "glyphicon glyphicon-user"></i> Estudiante</a></li>
</ul>
</li>
<li><a style = "font-size:18px; border-bottom:1px solid #d3d3d3;" href = "book.php"><i class = "glyphicon glyphicon-book"></i> Libros</a></li>
<li><a style = "font-size:18px; border-bottom:1px solid #d3d3d3;" href = ""><i class = "glyphicon glyphicon-th"></i> Transacción</a>
<ul style = "list-style-type:none;">
<li><a href = "borrowing.php" style = "font-size:15px;"><i class = "glyphicon glyphicon-random"></i> Préstamo</a></li>
<li><a href = "returning.php" style = "font-size:15px;"><i class = "glyphicon glyphicon-random"></i> Devolución</a></li>
</ul>
</li>
<li><a style = "font-size:18px; border-bottom:1px solid #d3d3d3;" href = ""><i class = "glyphicon glyphicon-cog"></i> Configuración</a>
<ul style = "list-style-type:none;">
<li><a style = "font-size:15px;" href = "logout.php"><i class = "glyphicon glyphicon-log-out"></i> Cerrar Sesión</a></li>
</ul>
</li>
</ul>
</div>
<div class = "col-lg-1"></div>
<div class = "col-lg-9 well" style = "margin-top:60px;">
<div class = "alert alert-info">Libros</div>
<button id = "add_book" type = "button" class = "btn btn-primary"><span class = "glyphicon glyphicon-plus"></span> Agregar nuevo</button>
<button id = "show_book" type = "button" style = "display:none;" class = "btn btn-success"><span class = "glyphicon glyphicon-circle-arrow-left"></span> Volver</button>
<br />
<br />
<div id = "book_table">
<table id = "table" class = "table table-bordered">
<thead class = "alert-success">
<tr>
<th>Titulo del libro</th>
<th>Categoria</th>
<th>Autor</th>
<th>Fecha de Publicación</th>
<th>Disponible</th>
<th>Acción</th>
</tr>
</thead>
<tbody>
<?php
$qbook = $conn->query("SELECT * FROM `book`") or die(mysqli_error());
while($fbook = $qbook->fetch_array()){
?>
<tr>
<td><?php echo $fbook['book_title']?></td>
<td><?php echo $fbook['book_category']?></td>
<td><?php echo $fbook['book_author']?></td>
<td><?php echo date("m-d-Y", strtotime($fbook['date_publish']))?></td>
<td><?php echo $fbook['qty']?></td>
<td><a class = "btn btn-danger delbook_id" value = "<?php echo $fbook['book_id']?>"><span class = "glyphicon glyphicon-remove"></span> Eliminar</a> <a value = "<?php echo $fbook['book_id']?>" class = "btn btn-warning ebook_id"><span class = "glyphicon glyphicon-edit"></span> Editar</a></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<div id = "edit_form"></div>
<div id = "book_form" style = "display:none;">
<div class = "col-lg-3"></div>
<div class = "col-lg-6">
<form method = "POST" action = "save_book_query.php" enctype = "multipart/form-data">
<div class = "form-group">
<label>Titulo del libro:</label>
<input type = "text" name = "book_title" required = "required" class = "form-control" />
</div>
<div class = "form-group">
<label>Descripcion:</label>
<input type = "text" name = "book_desc" class = "form-control" />
</div>
<div class = "form-group">
<label>Categoria de libro:</label>
<input type = "text" name = "book_category" class = "form-control" required = "required"/>
</div>
<div class = "form-group">
<label>Autor:</label>
<input type = "text" name = "book_author" class = "form-control" required = "required" />
</div>
<div class = "form-group">
<label>Fecha de Publicación:</label>
<input type = "date" name = "date_publish" required = "required" class = "form-control" />
</div>
<div class = "form-group">
<label>Cantidad</label>
<input type = "number" min = "0" name = "qty" required = "required" class = "form-control" />
</div>
<div class = "form-group">
<button name = "save_book" class = "btn btn-primary"><span class = "glyphicon glyphicon-save"></span> Enviar</button>
</div>
</form>
</div>
</div>
</div>
</div>
<br />
<br />
<br />
<nav class = "navbar navbar-default navbar-fixed-bottom">
<div class = "container-fluid">
<label class = "navbar-text pull-right">Sistema de Biblioteca | Platea21 © Todos los Derechos Reservados 2018</label>
</div>
</nav>
</body>
<script src = "js/jquery.js"></script>
<script src = "js/bootstrap.js"></script>
<script src = "js/login.js"></script>
<script src = "js/sidebar.js"></script>
<script src = "js/jquery.dataTables.js"></script>
<script type = "text/javascript">
$(document).ready(function(){
$('#table').DataTable();
});
</script>
<script type = "text/javascript">
$(document).ready(function(){
$('#add_book').click(function(){
$(this).hide();
$('#show_book').show();
$('#book_table').slideUp();
$('#book_form').slideDown();
$('#show_book').click(function(){
$(this).hide();
$('#add_book').show();
$('#book_table').slideDown();
$('#book_form').slideUp();
});
});
});
</script>
<script type = "text/javascript">
$(document).ready(function(){
$result = $('<center><label>Deleting...</label></center>');
$('.delbook_id').click(function(){
$book_id = $(this).attr('value');
$(this).parents('td').empty().append($result);
$('.delbook_id').attr('disabled', 'disabled');
$('.ebook_id').attr('disabled', 'disabled');
setTimeout(function(){
window.location = 'delete_book.php?book_id=' + $book_id;
}, 1000);
});
$('.ebook_id').click(function(){
$book_id = $(this).attr('value');
$('#show_book').show();
$('#show_book').click(function(){
$(this).hide();
$('#edit_form').empty();
$('#book_table').show();
$('#book_admin').show();
});
$('#book_table').fadeOut();
$('#add_book').hide();
$('#edit_form').load('load_book.php?book_id=' + $book_id);
});
});
</script>
</html>