| Server IP : 74.208.127.88 / Your IP : 216.73.216.71 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/muebles/application/otro/ |
Upload File : |
<?php include('BDconect.php');?>
<!doctype html>
<html lang="es">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="">
<meta name="author" content="">
<title>Actualizar información PDO PHP y MySQL | BaulPHP</title>
<!-- Bootstrap core CSS -->
<link href="dist/css/bootstrap.min.css" rel="stylesheet">
<!-- Custom styles for this template -->
<link href="assets/sticky-footer-navbar.css" rel="stylesheet">
<script type="text/javascript" src="js/jquery-3.2.1.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
setTimeout(function() {
$(".content").fadeOut(1500);
},3000);
});
</script>
</head>
<body>
<header>
<!-- Fixed navbar -->
<nav class="navbar navbar-expand-md navbar-dark fixed-top bg-dark"> <a class="navbar-brand" href="#">BaulPHP</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarCollapse" aria-controls="navbarCollapse" aria-expanded="false" aria-label="Toggle navigation"> <span class="navbar-toggler-icon"></span> </button>
<div class="collapse navbar-collapse" id="navbarCollapse">
<ul class="navbar-nav mr-auto">
<li class="nav-item active"> <a class="nav-link" href="index.php">Inicio <span class="sr-only">(current)</span></a> </li>
</ul>
<form class="form-inline mt-2 mt-md-0">
<input class="form-control mr-sm-2" type="text" placeholder="Buscar" aria-label="Search">
<button class="btn btn-outline-success my-2 my-sm-0" type="submit">Busqueda</button>
</form>
</div>
</nav>
</header>
<!-- Begin page content -->
<div class="container">
<?php
if(isset($_POST['eliminar'])){
////////////// Actualizar la tabla /////////
$consulta = "DELETE FROM `tbl_personal` WHERE `id`=:id";
$sql = $connect-> prepare($consulta);
$sql -> bindParam(':id', $id, PDO::PARAM_INT);
$id=trim($_POST['id']);
$sql->execute();
if($sql->rowCount() > 0)
{
$count = $sql -> rowCount();
echo "<div class='content alert alert-primary' >
Gracias: $count registro ha sido eliminado </div>";
}
else{
echo "<div class='content alert alert-danger'> No se pudo eliminar el registro </div>";
print_r($sql->errorInfo());
}
}// Cierra envio de guardado
?>
<?php
if(isset($_POST['insertar'])){
///////////// Informacion enviada por el formulario /////////////
$nombres=$_POST['nombres'];
$apellidos=$_POST['apellidos'];
$profesion=$_POST['profesion'];
$estado=$_POST['estado'];
$fregis = date('Y-m-d');
///////// Fin informacion enviada por el formulario ///
////////////// Insertar a la tabla la informacion generada /////////
$sql="insert into tbl_personal(nombres,apellidos,profesion,estado,fregis) values(:nombres,:apellidos,:profesion,:estado,:fregis)";
$sql = $connect->prepare($sql);
$sql->bindParam(':nombres',$nombres,PDO::PARAM_STR, 25);
$sql->bindParam(':apellidos',$apellidos,PDO::PARAM_STR, 25);
$sql->bindParam(':profesion',$profesion,PDO::PARAM_STR,25);
$sql->bindParam(':estado',$estado,PDO::PARAM_STR,25);
$sql->bindParam(':fregis',$fregis,PDO::PARAM_STR);
$sql->execute();
$lastInsertId = $connect->lastInsertId();
if($lastInsertId>0){
echo "<div class='content alert alert-primary' > Gracias .. Tu Nombre es : $nombres </div>";
}
else{
echo "<div class='content alert alert-danger'> No se pueden agregar datos, comuníquese con el administrador </div>";
print_r($sql->errorInfo());
}
}// Cierra envio de guardado
?>
<?php
if(isset($_POST['actualizar'])){
///////////// Informacion enviada por el formulario /////////////
$id=trim($_POST['id']);
$nombres=trim($_POST['nombres']);
$apellidos=trim($_POST['apellidos']);
$profesion=trim($_POST['profesion']);
$estado=trim($_POST['estado']);
$fregis = date('Y-m-d');
///////// Fin informacion enviada por el formulario ///
////////////// Actualizar la tabla /////////
$consulta = "UPDATE tbl_personal
SET `nombres`= :nombres, `apellidos` = :apellidos, `profesion` = :profesion, `estado` = :estado, `fregis` = :fregis
WHERE `id` = :id";
$sql = $connect->prepare($consulta);
$sql->bindParam(':nombres',$nombres,PDO::PARAM_STR, 25);
$sql->bindParam(':apellidos',$apellidos,PDO::PARAM_STR, 25);
$sql->bindParam(':profesion',$profesion,PDO::PARAM_STR,25);
$sql->bindParam(':estado',$estado,PDO::PARAM_STR,25);
$sql->bindParam(':fregis',$fregis,PDO::PARAM_STR);
$sql->bindParam(':id',$id,PDO::PARAM_INT);
$sql->execute();
if($sql->rowCount() > 0)
{
$count = $sql -> rowCount();
echo "<div class='content alert alert-primary' >
Gracias: $count registro ha sido actualizado </div>";
}
else{
echo "<div class='content alert alert-danger'> No se pudo actulizar el registro </div>";
print_r($sql->errorInfo());
}
}// Cierra envio de guardado
?>
<h3 class="mt-5">CRUD PDO PHP y MySQL</h3>
<hr>
<div class="row">
<!-- Insertar Registros-->
<?php
if (isset($_POST['formInsertar'])){?>
<div class="col-12 col-md-12">
<form action="" method="POST">
<div class="form-row">
<div class="form-group col-md-6">
<label for="nombres">Nombres</label>
<input name="nombres" type="text" class="form-control" placeholder="Nombres">
</div>
<div class="form-group col-md-6">
<label for="edad">Apellidos</label>
<input name="apellidos" type="text" class="form-control" id="edad" placeholder="Apellidos">
</div>
</div>
<div class="form-row">
<div class="form-group col-md-6">
<label for="profesion">Profesión</label>
<input name="profesion" type="text" class="form-control" id="profesion" placeholder="Profesion">
</div>
<div class="form-group col-md-6">
<label for="Estado">Estado</label>
<select required name="estado" class="form-control" id="Estado">
<option value=""><< >></option>
<option value="Colombia">Colombia</option>
<option value="Argentina">Argentina</option>
<option value="Ecuador">Ecuador</option>
<option value="Peru">Peru</option>
<option value="Brasil">Brasil</option>
<option value="Bolivia">Bolivia</option>
<option value="Chile">Chile</option>
</select>
</div>
</div>
<div class="form-group">
<button name="insertar" type="submit" class="btn btn-primary btn-block">Guardar</button>
</div>
</form>
</div>
<?php } ?>
<!-- Fin Insertar Registros-->
<?php
if (isset($_POST['editar'])){
$id = $_POST['id'];
$sql= "SELECT * FROM tbl_personal WHERE id = :id";
$stmt = $connect->prepare($sql);
$stmt->bindParam(':id', $id, PDO::PARAM_INT);
$stmt->execute();
$obj = $stmt->fetchObject();
?>
<div class="col-12 col-md-12">
<form role="form" method="POST" action="<?php echo $_SERVER['PHP_SELF'] ?>">
<input value="<?php echo $obj->id;?>" name="id" type="hidden">
<div class="form-row">
<div class="form-group col-md-6">
<label for="nombres">Nombres</label>
<input value="<?php echo $obj->nombres;?>" name="nombres" type="text" class="form-control" placeholder="Nombres">
</div>
<div class="form-group col-md-6">
<label for="edad">Apellidos</label>
<input value="<?php echo $obj->apellidos;?>" name="apellidos" type="text" class="form-control" id="edad" placeholder="Apellidos">
</div>
</div>
<div class="form-row">
<div class="form-group col-md-6">
<label for="profesion">Profesión</label>
<input value="<?php echo $obj->profesion;?>" name="profesion" type="text" class="form-control" id="profesion" placeholder="Profesion">
</div>
<div class="form-group col-md-6">
<label for="Estado">Estado</label>
<select required name="estado" class="form-control" id="Estado">
<option value="<?php echo $obj->estado;?>"><?php echo $obj->estado;?></option>
<option value=""><< >></option>
<option value="Colombia">Colombia</option>
<option value="Argentina">Argentina</option>
<option value="Ecuador">Ecuador</option>
<option value="Peru">Peru</option>
<option value="Brasil">Brasil</option>
<option value="Bolivia">Bolivia</option>
<option value="Chile">Chile</option>
</select>
</div>
</div>
<div class="form-group">
<button name="actualizar" type="submit" class="btn btn-primary btn-block">Actualizar Registro</button>
</div>
</form>
</div>
<?php }?>
<div class="col-12 col-md-12">
<!-- Contenido -->
<div style="float:right; margin-bottom:5px;">
<form action="" method="post"><button class="btn btn-primary" name="formInsertar">Nuevo registro</button> <a href="index.php"><button type="button" class="btn btn-primary">Cancelar</button></a></form></div>
<div class="table-responsive">
<table class="table table-bordered table-striped">
<thead class="thead-dark">
<th width="18%">Nombres</th>
<th width="22%">Apellidos</th>
<th width="22%">Profesión</th>
<th width="14%">Estado</th>
<th width="13%">Fecha registro</th>
<th width="13%" colspan="2"></th>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM tbl_personal";
$query = $connect -> prepare($sql);
$query -> execute();
$results = $query -> fetchAll(PDO::FETCH_OBJ);
if($query -> rowCount() > 0) {
foreach($results as $result) {
echo "<tr>
<td>".$result -> nombres."</td>
<td>".$result -> apellidos."</td>
<td>".$result -> profesion."</td>
<td>".$result -> estado."</td>
<td>".$result -> fregis."</td>
<td>
<form method='POST' action='".$_SERVER['PHP_SELF']."'>
<input type='hidden' name='id' value='".$result -> id."'>
<button name='editar'>Editar</button>
</form>
</td>
<td>
<form onsubmit=\"return confirm('Realmente desea eliminar el registro?');\" method='POST' action='".$_SERVER['PHP_SELF']."'>
<input type='hidden' name='id' value='".$result -> id."'>
<button name='eliminar'>Eliminar</button>
</form>
</td>
</tr>";
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
<!-- Fin Contenido -->
</div>
</div>
<!-- Fin row -->
</div>
<!-- Fin container -->
<footer class="footer">
<div class="container"> <span class="text-muted">
<p>Códigos <a href="https://www.baulphp.com/" target="_blank">BaulPHP</a></p>
</span> </div>
</footer>
<!-- Bootstrap core JavaScript
================================================== -->
<script src="dist/js/bootstrap.min.js"></script>
<!-- Placed at the end of the document so the pages load faster -->
</body>
</html>