
<button></button> no conecta la funcion remove
Publicado por Juan (1 intervención) el 24/06/2023 21:59:41
funcion js
function eliminarRegistro (id_user) {
const connection= msqli.createConnection({
host: 'localhost',
database: 'store',
user: 'root',
password: '',
});
const query = 'DELETE FROM user WHERE id_user = 1';
const modalId = '#removeUserModal';
const btnId = '#removeUserBtn';
connection.query(query, [id_user], (error, results) => {
if (error) {
console.error('Error al eliminar el registro:', error);
} else {
console.log('Registro eliminado correctamente.');
}
});
const id_user = 1;
eliminarRegistro(id_user);
}
<?php
// Archivo de consulta fecthUser
<?php
require_once 'core.php';
$sql = "SELECT * FROM user WHERE 1 ";
$result = $connect->query($sql);
$output = array('data' => array());
if($result->num_rows > 0) {
$rol = "";
while($row = $result->fetch_array()) {
$userId = $row[0];
if($row[4] == 1) {
// activate member
$rol = "<label class='label label-success'>Administrador</label>";
} else {
// deactivate member
$rol = "<label class='label label-primary'>Estandar</label>";
} // /else
$button = '<!-- Single button -->
<div class="btn-group">
<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
Acción <span class="caret"></span>
</button>
<ul class="dropdown-menu">
<li><a type="button" data-toggle="modal" id="editUserModalBtn" data-target="#editUserModal"onclick="editUser('.$userId.')"> <i class="glyphicon glyphicon-edit"></i> Editar</a></li>
<li> <a type="button" data-toggle="modal" data-target="#removeUserModal" id="#removeUserBtn" onclick="eliminarRegistro(1)"><i class="glyphicon glyphicon-trash"></i>Eliminar</a></li>
</ul>
</div>';
$output['data'][] = array(
//Codigo
$userId,
// Nombre
$row[1],
// Usuario
$row[2],
// Password
$row[3],
// Rol
$rol,
// button
$button
);
} // /while
}// if num_rows
$connect->close();
echo json_encode($output);
?>
// Modal setting.php
?php
<div class="modal fade" tabindex="-1" role="dialog" id="removeUserModal" data-backdrop="static" data-keyboard="false">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title"><i class="glyphicon glyphicon-trash"></i> Eliminar Usuario</h4>
</div>
<div class="modal-body">
<!-- #region -->
<div class="removeUserMessages"></div>
<p>Realmente deseas eliminar el Usuario?</p>
</div>
<div class="modal-footer removeProductFooter">
<button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Cancelar</button>
<button type="button" class="btn btn-danger" id="#removeUserBtn" data-loading-text="loading..."><i class="glyphicon glyphicon-ok-sign"></i>Eliminar</button>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
?>
function eliminarRegistro (id_user) {
const connection= msqli.createConnection({
host: 'localhost',
database: 'store',
user: 'root',
password: '',
});
const query = 'DELETE FROM user WHERE id_user = 1';
const modalId = '#removeUserModal';
const btnId = '#removeUserBtn';
connection.query(query, [id_user], (error, results) => {
if (error) {
console.error('Error al eliminar el registro:', error);
} else {
console.log('Registro eliminado correctamente.');
}
});
const id_user = 1;
eliminarRegistro(id_user);
}
<?php
// Archivo de consulta fecthUser
<?php
require_once 'core.php';
$sql = "SELECT * FROM user WHERE 1 ";
$result = $connect->query($sql);
$output = array('data' => array());
if($result->num_rows > 0) {
$rol = "";
while($row = $result->fetch_array()) {
$userId = $row[0];
if($row[4] == 1) {
// activate member
$rol = "<label class='label label-success'>Administrador</label>";
} else {
// deactivate member
$rol = "<label class='label label-primary'>Estandar</label>";
} // /else
$button = '<!-- Single button -->
<div class="btn-group">
<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
Acción <span class="caret"></span>
</button>
<ul class="dropdown-menu">
<li><a type="button" data-toggle="modal" id="editUserModalBtn" data-target="#editUserModal"onclick="editUser('.$userId.')"> <i class="glyphicon glyphicon-edit"></i> Editar</a></li>
<li> <a type="button" data-toggle="modal" data-target="#removeUserModal" id="#removeUserBtn" onclick="eliminarRegistro(1)"><i class="glyphicon glyphicon-trash"></i>Eliminar</a></li>
</ul>
</div>';
$output['data'][] = array(
//Codigo
$userId,
// Nombre
$row[1],
// Usuario
$row[2],
// Password
$row[3],
// Rol
$rol,
// button
$button
);
} // /while
}// if num_rows
$connect->close();
echo json_encode($output);
?>
// Modal setting.php
?php
<div class="modal fade" tabindex="-1" role="dialog" id="removeUserModal" data-backdrop="static" data-keyboard="false">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title"><i class="glyphicon glyphicon-trash"></i> Eliminar Usuario</h4>
</div>
<div class="modal-body">
<!-- #region -->
<div class="removeUserMessages"></div>
<p>Realmente deseas eliminar el Usuario?</p>
</div>
<div class="modal-footer removeProductFooter">
<button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Cancelar</button>
<button type="button" class="btn btn-danger" id="#removeUserBtn" data-loading-text="loading..."><i class="glyphicon glyphicon-ok-sign"></i>Eliminar</button>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
?>
Valora esta pregunta


0