Yo inserto solo los checkbox que aparecen en la tabla dinamica..Por ejemplo se hay tres checkbox yo puedo seleccionar solo los tres, pero como en la base de datos hay hasta 14 filas de checkbox, el codigo de insercion me los inserta todos (lo que no seleciono me pone la letra "D" justamente. todo el codigo es:
Código PHP:
<?php header("Content-type:text/html;charset=ISO-8859-1");
//***************************************************************************
/* Realizamos la consulta SQL */
$sql= "SELECT e_nombre FROM estudiantes WHERE (id=19) ";
$result= mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result)==0) die("No hay registros para mostrar");
//**********************************************************************
$sql2= "SELECT ob1, ob2, ob3, ob4, ob5, ob6, ob7, ob8, ob9, ob10, ob11, ob12, ob13, ob14 FROM objetivos WHERE id=6 ";
$result2= mysql_query($sql2) or die(mysql_error());
if(mysql_num_rows($result2)==0) die("No hay registros para mostrar");
//*************************************************************************
echo "<table border=1 cellpadding=1 cellspacing=0>";
echo "<tr><th colspan=18><center> GRUPO SEXTO A 'MATEMATICAS'</th><tr>";
# construyendo los encabezados de la tabla
echo " <th bgcolor=silver><font size=1 ><center>___________ESTUDIANTE___________</font></th>
<th bgcolor=silver><font size=1 ><center>01</font></th>
<th bgcolor=silver><font size=1 ><center>02</font></th>
<th bgcolor=silver><font size=1 ><center>03</font></th>
<th bgcolor=silver><font size=1 ><center>04</font></th>
<th bgcolor=silver><font size=1 ><center>05</font></th>
<th bgcolor=silver><font size=1 ><center>06</font></th>
<th bgcolor=silver><font size=1 ><center>07</font></th>
<th bgcolor=silver><font size=1 ><center>08</font></th>
<th bgcolor=silver><font size=1 ><center>09</font></th>
<th bgcolor=silver><font size=1 ><center>10</font></th>
<th bgcolor=silver><font size=1 ><center>11</font></th>
<th bgcolor=silver><font size=1 ><center>12</font></th>
<th bgcolor=silver><font size=1 ><center>13</font></th>
<th bgcolor=silver><font size=1 ><center>14</font></th>
<th bgcolor=silver><font size=1 ><center>Nota</font></th>
<th bgcolor=silver><font size=1 ><center>Juicio Valorativo</font></th>
<th bgcolor=silver><font size=1 ><center></font></th></TR>";
//*************************************************************************
/*Y ahora todos los registros */
while($row2=mysql_fetch_array($result2))
while($row=mysql_fetch_array($result))
//*****************************************************
{
echo "<tr>
<td> $row[e_nombre] </td>
<td>"; if($row2['ob1'] != ""){ echo "<input type='checkbox' name=c1 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob2'] != ""){ echo "<input type='checkbox' name=c2 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob3'] != ""){ echo "<input type='checkbox' name=c3 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob4'] != ""){ echo "<input type='checkbox' name=c4 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob5'] != ""){ echo "<input type='checkbox' name=c5 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob6'] != ""){ echo "<input type='checkbox' name=c6 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob7'] != ""){ echo "<input type='checkbox' name=c7 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob8'] != ""){ echo "<input type='checkbox' name=c8 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob9'] != ""){ echo "<input type='checkbox' name=c9 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob10'] != ""){ echo "<input type='checkbox' name=c10 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob11'] != ""){ echo "<input type='checkbox' name=c11 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob12'] != ""){ echo "<input type='checkbox' name=c12 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob13'] != ""){ echo "<input type='checkbox' name=c13 value=1 >"; } else{ echo ""; } echo "</td>
<td>"; if($row2['ob14'] != ""){ echo "<input type='checkbox' name=c14 value=1 >"; } else{ echo ""; } echo "</td>
<td> <input name='nota3' type='text' id='nota3' size='10' maxlength='10' /> </td>
<td> <input name='juicio' type='text' id='juicio' size='40' maxlength='150' /> </td>
<td> <input type='submit' name='button' id='button' value='Enviar' /> </td>
</tr>";
}
echo "</table>";
?>
Con esto obtengo los checkbox.
Este otro codigo inserta los resultados de los checkbox:
Código PHP:
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
# chechkbox
if( $c1 != "") {
if( $c1 == "1" ) {
$c1 = "F";
} else {
$c1 = "D";
}
}
if( $c2 != "") {
if( $c2 == "1" ) {
$c2 = "F";
} else {
$c2 = "D";
}
}
if( $c3 != "") {
if( $c3 == "1" ) {
$c3 = "F";
} else {
$c3 = "D";
}
}
if( $c4 != "") {
if( $c4 == "1" ) {
$c4 = "F";
} else {
$c4 = "D";
}
}
if( $c5 != "") {
if( $c5 == "1" ) {
$c5 = "F";
} else {
$c5 = "D";
}
}
if( $c6 != "") {
if( $c6 == "1" ) {
$c6 = "F";
} else {
$c6 = "D";
}
}
if( $c7 != "") {
if( $c7 == "1" ) {
$c7 = "F";
} else {
$c7 = "D";
}
}
if( $c8 != "") {
if( $c8 == "1" ) {
$c8 = "F";
} else {
$c8 = "D";
}
}
if( $c9 != "") {
if( $c9 == "1" ) {
$c9 = "F";
} else {
$c9 = "D";
}
}
if( $c10 != "") {
if( $c10 == "1" ) {
$c10 = "F";
} else {
$c10 = "D";
}
}
if( $c11 != "") {
if( $c11 == "1" ) {
$c11 = "F";
} else {
$c11 = "D";
}
}
if( $c12 != "") {
if( $c12 == "1" ) {
$c12 = "F";
} else {
$c12 = "D";
}
}
if( $c13 != "") {
if( $c13 == "1" ) {
$c13 = "F";
} else {
$c13 = "D";
}
}
if( $c14 != "") {
if( $c14 == "1" ) {
$c14 = "F";
} else {
$c14 = "D";
}
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////
# valoracion
if( $nota3 != "")
if($nota3<3.0){
$val="bajo";
}
if($nota3>=3.0 && $nota3<=3.6){
$val="basico";
}
if($nota3>=3.7 && $nota3<=4.3){
$val="alto";
}
if($nota3>=4.4){
$val="superior";
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Esta version la modifiqué y consigo a obtener que me inserte solo los checkbox que aparecen en la tabla pero me inserta si un checkbox no es vacio...letra"F"
Lo que quiero es que me inserte también la letra "D" no seleccionando nada
Espero que pueda entender.
Gracias por la preciosa ayuda.