Actualizar registros

[famjaes]

Código PHP:

Archivo formulario.php
 
 
<?php
 
include 'conexion.php';
 
 
$con = mysql_connect($dbhost, $dbusername, $dbuserpass); 
mysql_select_db($dbname, $con);
 
 
$periodo=$_GET['periodo'];
$bloque=$_GET['bloque'];
$grado=$_GET['grado'];
$grupo=$_GET['grupo'];
 
 
 
$con = mysqli_connect($dbhost, $dbusername, $dbuserpass,$dbname);
 
//// solo mostrara el alumno en cuestion 
$aal= mysqli_query($con,"SELECT * FROM calf WHERE periodo='$periodo' AND grado='$grado' AND grupo='$grupo' AND bloque='$bloque'")or die("Error: ".mysqli_error($con));
$al = mysqli_fetch_array($aal);
 
 
$cc1= mysqli_query($con,"SELECT materia FROM materia WHERE grado='$grado' AND ca='c1'")or die("Error: ".mysqli_error($con));
$c1 = mysqli_fetch_array($cc1);
 
$cc2= mysqli_query($con,"SELECT materia FROM materia WHERE grado='$grado' AND ca='c2'");
$c2 = mysqli_fetch_array($cc2);
 
$cc3= mysqli_query($con,"SELECT materia FROM materia WHERE grado='$grado' AND ca='c3'");
$c3 = mysqli_fetch_array($cc3);
 
$cc4= mysqli_query($con,"SELECT materia FROM materia WHERE grado='$grado' AND ca='c4'");
$c4 = mysqli_fetch_array($cc4);
 
$cc5= mysqli_query($con,"SELECT materia FROM materia WHERE grado='$grado' AND ca='c5'");
$c5 = mysqli_fetch_array($cc5);
 
$cc6= mysqli_query($con,"SELECT materia FROM materia WHERE grado='$grado' AND ca='c6'");
$c6 = mysqli_fetch_array($cc6);
 
$cc7= mysqli_query($con,"SELECT materia FROM materia WHERE grado='$grado' AND ca='c7'");
$c7 = mysqli_fetch_array($cc7);
 
$cc8= mysqli_query($con,"SELECT materia FROM materia WHERE grado='$grado' AND ca='c8'");
$c8 = mysqli_fetch_array($cc8);
 
$cc9= mysqli_query($con,"SELECT materia FROM materia WHERE grado='$grado' AND ca='c9'");
$c9 = mysqli_fetch_array($cc9);
 
 
?>
<form name="actualizar" method="post" action="proceso/actualizar.php" enctype="multipart/form-data" >
<table style="border:1px solid #00000; color:#FFFFFF;width:800px;">
<tr style="background:#5A5A5A;">
<td>No. Lista</td>
<td>Apellido Paterno</td>
<td>Apellido Materno</td>
<td>Nombres</td>
<td><?php echo $c1['materia'];?></td>
<td><?php echo $c2['materia']; ?></td>
<td><?php echo $c3['materia']; ?></td>
<td><?php echo $c4['materia']; ?></td>
<td><?php echo $c5['materia']; ?></td>
<td><?php echo $c6['materia']; ?></td>
<td><?php echo $c7['materia']; ?></td>
<td><?php echo $c8['materia']; ?></td>
<td><?php echo $c9['materia']; ?></td>
<?php
 
$con = mysqli_connect($dbhost, $dbusername, $dbuserpass,$dbname);
$checkmat = mysqli_query($con, "SELECT * FROM calf WHERE periodo='$periodo' AND grado='$grado' AND grupo='$grupo' AND bloque='$bloque'")or die("Error: ".mysqli_error($con));
while($mts = mysqli_fetch_assoc($checkmat)) { ?>
 
<input type="hidden" name="periodo" id="periodo" value="<?php echo $mts['periodo']; ?>"/>
<input type="hidden" name="bloque" id="bloque" value="<?php echo $mts['bloque']; ?>"/>
<input type="hidden" name="grado" id="grado" value="<?php echo $mts['grado']; ?>"/>
<input type="hidden" name="grupo" id="grupo" value="<?php echo $mts['grupo']; ?>"/>
<input type="hidden" name="id" id="id" value="<?php echo $mts['id']; ?>"/>
<tr style="background:#262626;">
<td><input type="text" size="3" name="no_lista" id="no_lista" value="<?php echo $mts['no_lista']; ?>"/></td>
<td><input type="text" name="apellidopaterno" id="no_lista" value="<?php echo $mts['apellidopaterno']; ?>"/></td>
<td><input type="text" name="apellidomaterno" id="apellidomaterno" value="<?php echo $mts['apellidomaterno']; ?>"/></td>
<td><input type="text" name="nombres" id="nombres" value="<?php echo $mts['nombres']; ?>"/></td>
<td><input type="text" size="2" name="c1" id="c1" value="<?php echo $mts['c1']; ?>"/></td>
<td><input type="text" size="2" name="c2" id="c2" value="<?php echo $mts['c2']; ?>"/></td>
<td><input type="text" size="2" name="c3" id="c3" value="<?php echo $mts['c3']; ?>"/></td>
<td><input type="text" size="2" name="c4" id="c4" value="<?php echo $mts['c4']; ?>"/></td>
<td><input type="text" size="2" name="c5" id="c5" value="<?php echo $mts['c5']; ?>"/></td>
<td><input type="text" size="2" name="c6" id="c6" value="<?php echo $mts['c6']; ?>"/></td>
<td><input type="text" size="2" name="c7" id="c7" value="<?php echo $mts['c7']; ?>"/></td>
<td><input type="text" size="2" name="c8" id="c8" value="<?php echo $mts['c8']; ?>"/></td>
<td><input type="text" size="2" name="c9" id="c9" value="<?php echo $mts['c9']; ?>"/></td>
 
</tr>
 
<?php
 
}
 
?>
<input type='submit' id="actualizar" name='Actualizar' value="Actualizar"/>
</form>
 
 
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
 
 
 
 
Archivo actualizar.php
 
<?php
 
include '../conexion.php';
mysqli_connect ($dbhost, $dbusername, $dbuserpass); 
mysqli_select_db($cn,$dbname) or die("Cannot select database");
 
 
 
if(isset($_POST["periodo"])) {
$periodo=$_POST['periodo'];
$bloque=$_POST['bloque'];
$grado=$_POST['grado'];
$grupo=$_POST['grupo'];
$no_lista=$_POST['no_lista'];
$id=$_POST['id'];
 
 
 
 
$c = count($_POST["id"]);
if ($c > 0) {
for ($i=0; $i<$c; $i++) {
$id = $_POST["id"][$i];
$no_lista= $_POST["no_lista"][$i];
echo "update calf set no_lista='$no_lista' WHERE id='$id'"; 
$query=mysqli_query($cn,"update calf set no_lista='$no_lista' WHERE id='$id'")or die("Error: ".mysqli_error($cn));
}
}
 
//header("Location: ../mostrargrupos.php?periodo=$periodo&bloque=$bloque& grado=$grado&grupo=$grupo"); 
 
 
exit; 
}
?> /// lo que pasa es que necesito actualizar cada dato