Foros del Web - Ver Mensaje Individual - Como actualizar campos de múltiples filas de una tabla según checkbox seleccionados

yebert · #2 (**permalink**) 24/06/2012, 01:32

Estoy tratando de adaptar el siguiente script..

Código HTML:

Ver original<?php 
// Connection to the database 
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password=""; // Mysql password 
$db_name="empleados"; // Database name 
$tbl_name="empleados"; // Table name 
 
// Connect to server and select databse. 
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB"); 
$nombre=$_POST['bv'];
if(isset($_POST['checkbox'])){$checkbox = $_POST['checkbox'];
 
 
if(isset($_POST['bv']) && isset($_POST['activate'])?
 
$activate = $_POST["activate"]:
$deactivate = $_POST["deactivate"]) 
 
$id = "('" . implode("','", $checkbox ) . "');" ; 
 
 
$sql="UPDATE empleados SET  nombre = '".$nombre."', status = '".(isset($activate)?'Y':'N')."' WHERE id IN $id" ; 
 
$result = mysql_query($sql) or die(mysql_error()); 
} 
 
$sql="SELECT * FROM $tbl_name"; 
$result=mysql_query($sql); 
 
$count=mysql_num_rows($result); 
?> 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd "> 
<html xmlns=" http://www.w3.org/1999/xhtml "> 
<head> 
 
<meta http-equiv="Content-Type" content="text/html; charset="utf-8"" /> 
<title>Update multiple rows in mysql with checkbox</title> 
 
<script type="text/javascript"> 
<!-- 
function un_check(){ 
for (var i = 0; i < document.frmactive.elements.length; i++) { 
var e = document.frmactive.elements[i]; 
if ((e.name != 'allbox') && (e.type == 'checkbox')) { 
e.checked = document.frmactive.allbox.checked; 
}}} 
//--> 
</script> 
 
</head> 
<body> 
 
<p>&nbsp;</p>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1"> 
<tr> 
<td><form name="frmactive" method="post" action=""> 
<table width="400" border="1" cellpadding="3" cellspacing="0" bordercolor="#996633"> 
<tr> 
<td colspan="6" bgcolor="#8BC0FF"><input name="activate" type="submit" id="activate" value="Activate" /> 
<input name="deactivate" type="submit" id="deactivate" value="Deactivate" /></td> 
</tr> 
<tr> 
<td colspan="6" bgcolor="#7895B0"><div align="center"><strong>Update multiple rows in mysql with checkbox</strong> </div></td> 
</tr><tr> 
<td align="center"><input type="checkbox" name="allbox" onchange="un_check()" title="Select or Deselct ALL" style="background-color:#ccc;"/></td> 
<td align="center" bgcolor="#ECE9D8"><strong>Id</strong></td> 
<td align="center" bgcolor="#ECE9D8"><strong>Firstname</strong></td> 
<td align="center" bgcolor="#ECE9D8"><strong>Lastname</strong></td>
<td align="center" bgcolor="#ECE9D8"><strong>Status</strong></td> 
</tr> 
<?php 
while($rows=mysql_fetch_array($result)){ 
?> 
<tr> 
<td align="center" bgcolor="#C5D5FC"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php  echo $rows['id']; ?>"></td> 
<td bgcolor="#C5D5FC"><?php  echo $rows['id']; ?></td> 
<td bgcolor="#C5D5FC"><input name="bv" type="text" id="bv" value="<?php  echo $rows['nombre']; ?>" size="5" maxlength="4" /></td> 
<td bgcolor="#C5D5FC"><?php  echo $rows['apellido']; ?></td>
<td bgcolor="#C5D5FC"><?php  echo $rows['status']; ?></td> 
</tr> 
<?php 
} 
?> 
<tr> 
<td colspan="6" align="center">&nbsp;</td> 
</tr> 
</table> 
</form> 
</td> 
</tr> 
</table> 
</body> 
</html>

Pero no actualiza por la fila seleccionada..