osea en la parte de elimianr como le hago para el button ejecute elc codigo y elimine cada elemento N elemenos sin tener que darle valores?
<?php
include ("conexion.php");
$sql = "SELECT * FROM baby_names";
$records = mysql_query($sql) or die (mysql_error());
?>
<!DOCTYPE HTML>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>employee</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="css/bootstrap.css">
<link rel="stylesheet" href="css/login.css">
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Daycare</a>
</div>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-user">Profile</span><span class="caret"></span></a>
<ul class="dropdown-menu" role="menu">
<li><a href="#"><span class="glyphicon glyphicon-cog"></span>Settings</a></li>
<li><a href="#"><span class="glyphicon glyphicon-edit"></span>Edit</a></li>
<li><a href="#"><span class="glyphicon glyphicon-repeat"></span>Change your password</a></li>
<li class="divider"></li>
<li><a href="#"><span class="glyphicon glyphicon-off">Sign out</span></a></li>
</ul>
</li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-flag">Reports</span><span class="caret"></span></a>
<ul class="dropdown-menu" role="menu">
<li><a href="#">Top seller list</a></li>
<li><a href="#">Top seller list</a></li>
</ul>
</li>
</ul>
<ul>
<ul class="nav navbar-nav navbar-right">
<li><a href="#"><span class="glyphicon glyphicon-home">Parents</span></a></li>
<li><a href="#"><span class="glyphicon glyphicon-home">Category</span></a></li>
<ul>
</nav>
<div class="container">
<div class="row">
<div class="col-md-3">
<ul class="nav nav-pills nav-stacked">
<li class="active"><a href="view.php"><span class="glyphicon glyphicon-home"></span>Home</a></li>
<li><a href="#">Presentation</a></li>
<li><a href="#">aaa</a></li>
<li><a href="#">Home</a></li>
<li><a href="#">Home</a></li>
<li><a href="#">Home</a></li>
<li><a href="#">Users</a></li>
</ul>
</div>
<div class="col-md-9 well">
<div>
<form method="POST" class="navbar-form navbar-left" action="add_kids.php">
<button type="button" class="btn btn-success" data-toggle="modal" data-target="#myModal"><span class="glyphicon glyphicon-plus"></span>Add kids</button>
<input type="text" class="form-control" placeholder="search">
<br/>
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<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" id="myModalLabel">Add kids</h4>
</div>
<div class="modal-body">
<form method="POST" action="add_kids.php" >
<div class="form-group">
<label for="baby-name">Baby name</label>
<input type="text" class="form-control" name="bby-name">
</div>
<div class="form-group">
<label for="Gender">Gender</label>
<select class="form-control" name="Gender">
<option>Select an option</option>
<option id="F">Female</option>
<option id="M">Male</option>
</select>
</div>
<div class="form-group">
<label for="phone">Phone</label>
<input type="text" class="form-control" name="phone">
</div>
<div class="form-group">
<label>Parent's name</label>
<input type="text" class="form-control" name="parents_name">
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
<button type="submit" name="submit" class="btn btn-success">Submit</button>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- Tab panes -->
<div class="container" id="name">
<ul class="nav" role="tablist">
<li class="active"><a href="#daftar" role="tab" data-toggle="tab">Data</a></li>
</ul>
<!-- Tab panes -->
<div class="tab-content" id="table2">
<div class="table-responsive">
</br>
<table class="table table-hover">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Gender</th>
<th>Age</th>
<th>Phone</th>
<th>Actions</th>
</tr>
<?php
while($row = mysql_fetch_assoc($records))
{
echo "<tr>";
echo "<td>".$row['ID_baby']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td></td>";
echo "<td><button type='submit' name='edit' class='btn btn-warning'><a href='edit.php' id='button'><span class='glyphicon glyphicon-edit'></span> Edit</a></button> <button type='submit' name='delete' class='btn btn-danger'><a href='delete.php' id='button'><span class='glyphicon glyphicon-trash'></span> Delete</a></button></td>";
echo'';
echo "<tr>";
}//endwhile
?>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
<script src="js/jquery.js"></script>
<script src="js/bootstrap.js"></script>
<script src="js/elements.js"></script>
</body>
</html>
<?php
include_once("conexion.php");
mysql_query("DELETE FROM baby_names WHERE ID_baby=46");
header("Location: index_employee.php");
?>
Hola
Para enviarlo tienes que enviarlo o bien por ajax (cosa que no te recomiento,por ahora) o poniendo un form con la petición a usar, en este caso POST y el fichero al que enviarás la petición.
quedaría de esta forma.
<form action="action_page.php" method="POST">
<button type='submit' name='action' value='delete' class='btn btn-danger'>
<button type='submit' name='action' value='edit' class='btn btn-warning'>
</form>
Con esto enviarás por POST la variable "action" con el contenido de lo que quieres realizar, en caso de editar "edit" y en caso de borrar "delete".
Ahora te quedaría recojer los datos en el fichero donde tienes el delete y en caso de que sea delete realizar la tarea, un ejemplo seria este.
Este fichero se llama "action_page.php"
<?php
include_once("conexion.php");
if( isset($_POST["action"]) ){
if( $_POST["action"] == "delete" ){
mysql_query("DELETE FROM baby_names WHERE ID_baby=46");
}
}
header("Location: index_employee.php");
?>
También hay varias cosas de seguridad en tu código para revisar, pero como supongo que estás aprendiendo mejor dejo a tu elección si quieres que te lo explique.
Suerte.
BUENO pero como le hago para que pueda borrar uno por uno y no toda la db o el elemento asginado
Ahi está en la respuesta!
DELETE FROM baby_names WHERE ID_baby=46
Obviamente el 46 sería una variable
no si pero al hacer esto no me borra nada ni el 10 ni todo
<?php
include ("conexion.php");
$sql = "SELECT * FROM baby_names";
$records = mysql_query($sql) or die (mysql_error());
?>
<!DOCTYPE HTML>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>employee</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="css/bootstrap.css">
<link rel="stylesheet" href="css/login.css">
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Daycare</a>
</div>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-user">Profile</span><span class="caret"></span></a>
<ul class="dropdown-menu" role="menu">
<li><a href="#"><span class="glyphicon glyphicon-cog"></span>Settings</a></li>
<li><a href="#"><span class="glyphicon glyphicon-edit"></span>Edit</a></li>
<li><a href="#"><span class="glyphicon glyphicon-repeat"></span>Change your password</a></li>
<li class="divider"></li>
<li><a href="#"><span class="glyphicon glyphicon-off">Sign out</span></a></li>
</ul>
</li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-flag">Reports</span><span class="caret"></span></a>
<ul class="dropdown-menu" role="menu">
<li><a href="#">Top seller list</a></li>
<li><a href="#">Top seller list</a></li>
</ul>
</li>
</ul>
<ul>
<ul class="nav navbar-nav navbar-right">
<li><a href="#"><span class="glyphicon glyphicon-home">Parents</span></a></li>
<li><a href="#"><span class="glyphicon glyphicon-home">Category</span></a></li>
<ul>
</nav>
<div class="container">
<div class="row">
<div class="col-md-3">
<ul class="nav nav-pills nav-stacked">
<li class="active"><a href="view.php"><span class="glyphicon glyphicon-home"></span>Home</a></li>
<li><a href="#">Presentation</a></li>
<li><a href="#">aaa</a></li>
<li><a href="#">Home</a></li>
<li><a href="#">Home</a></li>
<li><a href="#">Home</a></li>
<li><a href="#">Users</a></li>
</ul>
</div>
<div class="col-md-9 well">
<div>
<form method="POST" class="navbar-form navbar-left" action="add_kids.php">
<button type="button" class="btn btn-success" data-toggle="modal" data-target="#myModal"><span class="glyphicon glyphicon-plus"></span>Add kids</button>
<input type="text" class="form-control" placeholder="search">
<br/>
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<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" id="myModalLabel">Add kids</h4>
</div>
<div class="modal-body">
<form method="POST">
<div class="form-group">
<label for="baby-name">Baby name</label>
<input type="text" class="form-control" name="bby-name">
</div>
<div class="form-group">
<label for="Gender">Gender</label>
<select class="form-control" name="Gender">
<option>Select an option</option>
<option id="F">Female</option>
<option id="M">Male</option>
</select>
</div>
<div class="form-group">
<label for="phone">Phone</label>
<input type="text" class="form-control" name="phone">
</div>
<div class="form-group">
<label>Parent's name</label>
<input type="text" class="form-control" name="parents_name">
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
<button type="submit" name="submit" class="btn btn-success">Submit</button>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- Tab panes -->
<div class="container" id="name">
<ul class="nav" role="tablist">
<li class="active"><a href="#daftar" role="tab" data-toggle="tab">Data</a></li>
</ul>
<!-- Tab panes -->
<div class="tab-content" id="table2">
<div class="table-responsive">
</br>
<table class="table table-hover">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Gender</th>
<th>Age</th>
<th>Phone</th>
<th>Actions</th>
</tr>
<?php
while($row = mysql_fetch_assoc($records))
{
echo "<tr>";
echo "<td>".$row['ID_baby']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td></td>";
echo "<td>
<form method='POST' action='action_page.php'>
<button type='submit' name'action' class='btn btn-warning' value='edit'><span class='glyphicon glyphicon-edit'></span>Edit</button>
<button type='submit' name'delete' class='btn btn-danger' value='delete'><span class='glyphicon glyphicon-trash'></span>Delete</button>
</form>
</td>";
echo'';
echo "<tr>";
}//endwhile
?>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
<script src="js/jquery.js"></script>
<script src="js/bootstrap.js"></script>
<script src="js/elements.js"></script>
</body>
</html>
<?php
include_once("conexion.php");
if(isset($_POST['delete']))
{
mysql_query("DELETE FROM baby_names WHERE ID_baby=10");
}
header("Location: index_employee.php");
?>
QUIEN ME AYUDa a crear este bton con id $row[id],$row[nombre] para qu eme pueda borrar uno x uno
<button type='submit' name='delete' class='btn btn-danger' value='delete'><span class='glyphicon glyphicon-trash'></span>Delete</button>
Cita de: geshiro en 24 Junio 2015, 06:49 AM
QUIEN ME AYUDa a crear este bton con id $row[id],$row[nombre] para qu eme pueda borrar uno x uno
<button type='submit' name='delete' class='btn btn-danger' value='delete'><span class='glyphicon glyphicon-trash'></span>Delete</button>
Vale, creo que te he entendido.
Lo que quieres es que haya un botón por cada row de la tabla y que al pulsar ese botón se borre ese row en concreto,no?
Eso es fácil. Tienes que asignarle a la variable delete el id de row para eliminar. Así le pasas la key "delete" del array POST con el id de row para eliminar. Sería algo así.
<?php
while($row = mysql_fetch_assoc($records))
{
echo "<tr>";
echo "<td>".$row['ID_baby']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td></td>";
echo "<td>
<form method='POST' action='action_page.php'>
<button type='submit' name='action' class='btn btn-warning' value='".$row['ID_baby']."'><span class='glyphicon glyphicon-edit'></span>Edit</button>
<button type='submit' name='delete' class='btn btn-danger' value='".$row['ID_baby']."'><span class='glyphicon glyphicon-trash'></span>Delete</button>
</form>
</td>";
echo '';
echo "<tr>";
}//endwhile
?>
Con esto te puedes imaginar lo que llevará el fichero de "action_page.php". Ya que como dijo shell_root lo único que debes hacer es meter la key $_POST["delete"] en la query para especificar el id_row que se quiere borrar.
alguien me puede decir como puedo hacer el boton de edit pero otra ves con modal osea el agregar lo puede hacer porque no esta dentro del php pero este esta dentro del php como
seria
<?php
include ("conexion.php");
$sql = "SELECT * FROM baby_names";
$records = mysql_query($sql) or die (mysql_error());
?>
<!DOCTYPE HTML>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>employee</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="css/bootstrap.css">
<link rel="stylesheet" href="css/login.css">
</head>
<body>
<nav class="navbar navbar-default">
<div class="container-fluid">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Daycare</a>
</div>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-user">Profile</span><span class="caret"></span></a>
<ul class="dropdown-menu" role="menu">
<li><a href="#"><span class="glyphicon glyphicon-cog"></span>Settings</a></li>
<li><a href="#"><span class="glyphicon glyphicon-edit"></span>Edit</a></li>
<li><a href="#"><span class="glyphicon glyphicon-repeat"></span>Change your password</a></li>
<li class="divider"></li>
<li><a href="#"><span class="glyphicon glyphicon-off">Sign out</span></a></li>
</ul>
</li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-flag">Reports</span><span class="caret"></span></a>
<ul class="dropdown-menu" role="menu">
<li><a href="#">Top seller list</a></li>
<li><a href="#">Top seller list</a></li>
</ul>
</li>
</ul>
<ul>
<ul class="nav navbar-nav navbar-right">
<li><a href="#"><span class="glyphicon glyphicon-home">Parents</span></a></li>
<li><a href="#"><span class="glyphicon glyphicon-home">Category</span></a></li>
<ul>
</nav>
<div class="container">
<div class="row">
<div class="col-md-3">
<ul class="nav nav-pills nav-stacked">
<li class="active"><a href="view.php"><span class="glyphicon glyphicon-home"></span>Home</a></li>
<li><a href="#">Presentation</a></li>
<li><a href="#">aaa</a></li>
<li><a href="#">Home</a></li>
<li><a href="#">Home</a></li>
<li><a href="#">Home</a></li>
<li><a href="#">Users</a></li>
</ul>
</div>
<div class="col-md-9 well">
<div>
<form method="POST" class="navbar-form navbar-left" action="add_kids.php">
<button type="button" class="btn btn-success" data-toggle="modal" data-target="#myModal"><span class="glyphicon glyphicon-plus"></span>Add kids</button>
<input type="text" class="form-control" placeholder="search">
<br/>
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<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" id="myModalLabel">Add kids</h4>
</div>
<div class="modal-body">
<form method="POST">
<div class="form-group">
<label for="baby-name">Baby name</label>
<input type="text" class="form-control" name="bby-name">
</div>
<div class="form-group">
<label for="Gender">Gender</label>
<select class="form-control" name="Gender">
<option>Select an option</option>
<option id="F">Female</option>
<option id="M">Male</option>
</select>
</div>
<div class="form-group">
<label for="age">Age</label>
<input type="text" class="form-control" name="age">
</div>
<div class="form-group">
<label for="phone">Phone</label>
<input type="text" class="form-control" name="phone">
</div>
<div class="form-group">
<label>Parent's name</label>
<input type="text" class="form-control" name="parents_name">
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
<button type="submit" name="submit" class="btn btn-success">Submit</button>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- Tab panes -->
<div class="container" id="name">
<ul class="nav" role="tablist">
<li class="active"><a href="#daftar" role="tab" data-toggle="tab">Data</a></li>
</ul>
<!-- Tab panes -->
<div class="tab-content" id="table2">
<div class="table-responsive">
</br>
<table class="table table-hover">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Gender</th>
<th>Age</th>
<th>Phone</th>
<th>Actions</th>
</tr>
<?php
while($row = mysql_fetch_assoc($records))
{
echo "<tr>";
echo "<td>".$row['ID_baby']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td>".$row['Baby_name']."</td>";
echo "<td>".$row['age']."</td>";
echo "<td></td>";
echo "<td>
<form method='POST' action='action_page.php'>
<button type='submit' name='action' class='btn btn-warning' value='".$row['ID_baby']."'><span class='glyphicon glyphicon-edit'></span>Edit</button>
<button type='submit' name='delete' class='btn btn-danger' value='".$row['ID_baby']."'><span class='glyphicon glyphicon-trash'></span>Delete</button>
</form>
</td>";
echo'';
echo "</tr>";
}//endwhile
?>
</thead>
</table>
</div>
</div>
</div>
<script src="js/jquery.js"></script>
<script src="js/bootstrap.js"></script>
<script src="js/elements.js"></script>
</body>
</html>