Tema: Problema con checkbox en dreamweaver y php/mysql
Ver Mensaje Individual
  #1 (permalink)  
Antiguo 21/02/2010, 21:14
Tuchi
 
Fecha de Ingreso: febrero-2010
Mensajes: 2
Antigüedad: 14 años, 10 meses
Puntos: 0
Problema con checkbox en dreamweaver y php/mysql
hola esta es mi primera participacion si bien he leido y aprendido un monton de cosas en este foro, pero ahore me ha surgido un problema q no puedo solucionar

Tengo q grabar en un BD el contenido de lo marcado en los checkbox y no se como recibir los datos pasados
Aqui de dejo el codigo donde se cargan los juegos de registros y se arma una tabla dinamica con un campo para los checkbox

Código PHP: 
Ver original
  1. <?php require_once('../Connections/actualiza.php'); ?><?php
  2. if (!isset($_SESSION)) {
  3.   session_start();
  4. }
  5. $MM_authorizedUsers = "2";
  6. $MM_donotCheckaccess = "false";
  7.  
  8. // *** Restrict Access To Page: Grant or deny access to this page
  9. function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  10.   // For security, start by assuming the visitor is NOT authorized. 
  11.   $isValid = False; 
  12.  
  13.   // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  14.   // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  15.   if (!empty($UserName)) { 
  16.     // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
  17.     // Parse the strings into arrays. 
  18.     $arrUsers = Explode(",", $strUsers); 
  19.     $arrGroups = Explode(",", $strGroups); 
  20.     if (in_array($UserName, $arrUsers)) { 
  21.       $isValid = true; 
  22.     } 
  23.     // Or, you may restrict access to only certain users based on their username. 
  24.     if (in_array($UserGroup, $arrGroups)) { 
  25.       $isValid = true; 
  26.     } 
  27.     if (($strUsers == "") && false) { 
  28.       $isValid = true; 
  29.     } 
  30.   } 
  31.   return $isValid; 
  32. }
  33.  
  34. $MM_restrictGoTo = "../errorlog.php";
  35. if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  36.   $MM_qsChar = "?";
  37.   $MM_referrer = $_SERVER['PHP_SELF'];
  38.   if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  39.   if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
  40.   $MM_referrer .= "?" . $QUERY_STRING;
  41.   $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  42.   header("Location: ". $MM_restrictGoTo); 
  43.   exit;
  44. }
  45. ?>
  46. <?php
  47. $maxRows_Recordset1 = 40;
  48. $pageNum_Recordset1 = 0;
  49. if (isset($_GET['pageNum_Recordset1'])) {
  50.   $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
  51. }
  52. $startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
  53.  
  54. $colname_Recordset1 = "-1";
  55. if (isset($_SESSION['MM_Username'])) {
  56.   $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
  57. }
  58. mysql_select_db($database_actualiza, $actualiza);
  59. $query_Recordset1 = sprintf("SELECT alumnos.Nro_legajo, alumnos.Carrera, materia.Cod_carrera, materia.cod_carrera1, materia.Nombre_materia FROM alumnos, materia WHERE Nro_legajo = '%s' and alumnos.Carrera=materia.cod_carrera1", $colname_Recordset1);
  60. $query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
  61. $Recordset1 = mysql_query($query_limit_Recordset1, $actualiza) or die(mysql_error());
  62. $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  63.  
  64. if (isset($_GET['totalRows_Recordset1'])) {
  65.   $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
  66. } else {
  67.   $all_Recordset1 = mysql_query($query_Recordset1);
  68.   $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
  69. }
  70. $totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
  71.  
  72. $maxRows_Recordset2 = 10;
  73. $pageNum_Recordset2 = 0;
  74. if (isset($_GET['pageNum_Recordset2'])) {
  75.   $pageNum_Recordset2 = $_GET['pageNum_Recordset2'];
  76. }
  77. $startRow_Recordset2 = $pageNum_Recordset2 * $maxRows_Recordset2;
  78.  
  79. $colname_Recordset2 = "-1";
  80. if (isset($_SESSION['MM_Username'])) {
  81.   $colname_Recordset2 = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
  82. }
  83. mysql_select_db($database_actualiza, $actualiza);
  84. $query_Recordset2 = sprintf("SELECT Nro_legajo, Apellido, Nombre, Carrera, tipo_doc, Nro_doc FROM alumnos WHERE Nro_legajo = '%s'", $colname_Recordset2);
  85. $query_limit_Recordset2 = sprintf("%s LIMIT %d, %d", $query_Recordset2, $startRow_Recordset2, $maxRows_Recordset2);
  86. $Recordset2 = mysql_query($query_limit_Recordset2, $actualiza) or die(mysql_error());
  87. $row_Recordset2 = mysql_fetch_assoc($Recordset2);
  88.  
  89. if (isset($_GET['totalRows_Recordset2'])) {
  90.   $totalRows_Recordset2 = $_GET['totalRows_Recordset2'];
  91. } else {
  92.   $all_Recordset2 = mysql_query($query_Recordset2);
  93.   $totalRows_Recordset2 = mysql_num_rows($all_Recordset2);
  94. }
  95. $totalPages_Recordset2 = ceil($totalRows_Recordset2/$maxRows_Recordset2)-1;
  96.  
  97. $queryString_Recordset2 = "";
  98. if (!empty($_SERVER['QUERY_STRING'])) {
  99.   $params = explode("&", $_SERVER['QUERY_STRING']);
  100.   $newParams = array();
  101.   foreach ($params as $param) {
  102.     if (stristr($param, "pageNum_Recordset2") == false && 
  103.         stristr($param, "totalRows_Recordset2") == false) {
  104.       array_push($newParams, $param);
  105.     }
  106.   }
  107.   if (count($newParams) != 0) {
  108.     $queryString_Recordset2 = "&" . htmlentities(implode("&", $newParams));
  109.   }
  110. }
  111. $queryString_Recordset2 = sprintf("&totalRows_Recordset2=%d%s", $totalRows_Recordset2, $queryString_Recordset2);
  112. ?>
  113. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  114. <html xmlns="http://www.w3.org/1999/xhtml">
  115. <head>
  116. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  117. <title>A cursar</title>
  118. <style type="text/css">
  119. <!--
  120. .Estilo1 {font-size: 14px}
  121. .Estilo2 {font-size: 12px}
  122. -->
  123. </style>
  124. </head>
  125.  
  126. <body>
  127. <h2 align="center">Nombre p&aacute;gina </h2>
  128. <h3 align="center">Inscripci&oacute;n materias a cursar</h3>
  129. <table border="3" align="center">
  130.   <tr>
  131.     <td><div align="center" class="Estilo1">
  132.       <h4>Nro legajo</h4>
  133.     </div></td>
  134.     <td><div align="center" class="Estilo1">
  135.       <h4>Apellido</h4>
  136.     </div></td>
  137.     <td><div align="center" class="Estilo1">
  138.       <h4>Nombre</h4>
  139.     </div></td>
  140.     <td><div align="center" class="Estilo1">
  141.       <h4>Carrera</h4>
  142.     </div></td>
  143.     <td><div align="center" class="Estilo1">
  144.       <h4>Tipo doc</h4>
  145.     </div></td>
  146.     <td><div align="center" class="Estilo1">
  147.       <h4>Nro doc</h4>
  148.     </div></td>
  149.   </tr>
  150.   <?php do { ?>
  151.     <tr>
  152.       <td><h5 align="center" class="Estilo2"><?php echo $row_Recordset2['Nro_legajo']; ?></h5></td>
  153.       <td><h5 align="center" class="Estilo2"><?php echo $row_Recordset2['Apellido']; ?></h5></td>
  154.       <td><h5 align="center" class="Estilo2"><?php echo $row_Recordset2['Nombre']; ?></h5></td>
  155.       <td><h5 align="center" class="Estilo2"><?php echo $row_Recordset2['Carrera']; ?></h5></td>
  156.       <td><h5 align="center" class="Estilo2"><?php echo $row_Recordset2['tipo_doc']; ?></h5></td>
  157.       <td><h5 align="center" class="Estilo2"><?php echo $row_Recordset2['Nro_doc']; ?></h5></td>
  158.     </tr>
  159.     <?php } while ($row_Recordset2 = mysql_fetch_assoc($Recordset2)); ?>
  160. </table>
  161. <form id="form2" name="form2" method="post" action="procesar.php">
  162.   <table width="392" border="3" align="center">
  163.     <tr>
  164.       <td width="280"><div align="center"><strong>Materia</strong></div></td>
  165.       <td width="92"><div align="center"><strong>Inscripci&oacute;n</strong></div></td>
  166.     </tr>
  167.     <?php do { ?>
  168.     <tr>
  169.       <td><div align="left"><?php echo $row_Recordset1['Nombre_materia']; ?></div></td>
  170.       <td><label></label>
  171.           <div align="center">
  172.             <label>
  173.            [B][COLOR="Red"] <input <?php if (!(strcmp($row_Recordset1['Nombre_materia'],"Si"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="checkbox2" value="checkbox" />[/COLOR][/B]
  174.             </label>
  175.         </div></td>
  176.     </tr>
  177.     <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
  178.   </table>
  179.   <p align="center">
  180.     <label>
  181.     <input type="submit" name="Submit" value="Inscribir" />
  182.     </label>
  183.   </p>
  184.   <p align="center">&nbsp;</p>
  185. </form>
  186. <p align="right"><strong>Firma del alumno </strong></p>
  187. <table width="200" border="0">
  188.   <tr>
  189.     <th scope="col"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="100" height="22">
  190.       <param name="movie" value="button7.swf" />
  191.       <param name="quality" value="high" />
  192.       <embed src="button7.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="100" height="22" ></embed>
  193.     </object></th>
  194.     <th scope="col"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="100" height="22">
  195.       <param name="movie" value="button5.swf" />
  196.       <param name="quality" value="high" />
  197.       <embed src="button5.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="100" height="22" ></embed>
  198.     </object></th>
  199.   </tr>
  200. </table>
  201. <p align="left">&nbsp;</p>
  202. <p>&nbsp;</p>
  203. <p>&nbsp;</p>
  204. <p>&nbsp;</p>
  205. <p>&nbsp;</p>
  206. <p>
  207. </p>
  208. <p>
  209. </body>
  210. </html>
  211. <?php
  212. mysql_free_result($Recordset1);
  213.  
  214. mysql_free_result($Recordset2);
  215. ?>

desde ya muchas gracias
Última edición por Tuchi; 22/02/2010 a las 12:52