Tema: Varios registros pero con condición
Ver Mensaje Individual
  #9 (permalink)  
Antiguo 14/05/2012, 13:37
Avatar de mexbale
mexbale
 
Fecha de Ingreso: septiembre-2010
Ubicación: Iztapalapa
Mensajes: 146
Antigüedad: 13 años, 7 meses
Puntos: 1
Respuesta: Varios registros pero con condición
Ok espero que asi si me explique bien tengo todo este codigo:


Código PHP: 
Ver original
  1. <?PHP  //primera Tabla
  2. if(isset($_POST["Guardar"]))
  3. {
  4.  
  5. $P01_01 = $_POST['P01_01'] = trim($_POST['P01_01']); 
  6. $P01_02 = $_POST['P01_02'] = trim($_POST['P01_02']); 
  7. $P01_03 = $_POST['P01_03'] = trim($_POST['P01_03']); 
  8. $P01_04 = $_POST['P01_04'] = trim($_POST['P01_04']); 
  9. $P01_05 = $_POST['P01_05'] = trim($_POST['P01_05']); 
  10. $P01_06 = $_POST['P01_06'] = trim($_POST['P01_06']); 
  11. $P01_07 = $_POST['P01_07'] = trim($_POST['P01_07']); 
  12. $P01_08 = $_POST['P01_08'] = trim($_POST['P01_08']); 
  13. $P01_09 = $_POST['P01_09'] = trim($_POST['P01_09']); 
  14. $P01_10 = $_POST['P01_10'] = trim($_POST['P01_10']); 
  15. $P02_01 = trim($_POST['P02_01']); 
  16. if (empty($P02_01)){$P02_01='NULL';}
  17. $P02_02 = trim($_POST['P02_02']); 
  18. if (empty($P02_02)){$P02_02='NULL';}
  19. $P02_03 = trim($_POST['P02_03']); 
  20. if (empty($P02_03)){$P02_03='NULL';}
  21. $P02_04 = trim($_POST['P02_04']); 
  22. if (empty($P02_04)){$P02_04='NULL';}
  23. $P02_05 = trim($_POST['P02_05']); 
  24. if (empty($P02_05)){$P02_05='NULL';}
  25. $P02_06 = trim($_POST['P02_06']); 
  26. if (empty($P02_06)){$P02_06='NULL';}
  27. $P02_07 = trim($_POST['P02_07']); 
  28. if (empty($P02_07)){$P02_07='NULL';}
  29. $P02_08 = trim($_POST['P02_08']); 
  30. if (empty($P02_08)){$P02_08='NULL';}
  31. $P02_09 = trim($_POST['P02_09']); 
  32. if (empty($P02_09)){$P02_09='NULL';}
  33. $P02_10 = trim($_POST['P02_10']); 
  34. if (empty($P02_10)){$P02_10='NULL';}
  35. $P03_01 = trim($_POST['P03_01']); 
  36. if (empty($P03_01)){$P03_01='NULL';}
  37. $P03_02 = trim($_POST['P03_02']); 
  38. if (empty($P03_02)){$P03_02='NULL';}
  39. $P03_03 = trim($_POST['P03_03']); 
  40. if (empty($P03_03)){$P03_03='NULL';}
  41. $P03_04 = trim($_POST['P03_04']); 
  42. if (empty($P03_04)){$P03_04='NULL';}
  43. $P03_05 = trim($_POST['P03_05']); 
  44. if (empty($P03_05)){$P03_05='NULL';}
  45. $P03_06 = trim($_POST['P03_06']); 
  46. if (empty($P03_06)){$P03_06='NULL';}
  47. $P03_07 = trim($_POST['P03_07']); 
  48. if (empty($P03_07)){$P03_07='NULL';}
  49. $P03_08 = trim($_POST['P03_08']); 
  50. if (empty($P03_08)){$P03_08='NULL';}
  51. $P03_09 = trim($_POST['P03_09']); 
  52. if (empty($P03_09)){$P03_09='NULL';}
  53. $P03_10 = trim($_POST['P03_10']); 
  54. if (empty($P03_10)){$P03_10='NULL';}
  55.  
  56. // Paso 1: Recibimos el formulario:
  57. $FOLIO = $_POST['FOLIO'] = trim($_POST['FOLIO']);
  58. $link = mysql_connect('localhost', 'root', '********');
  59. if (!$link) {
  60.   die('No pudo conectarse: ' . mysql_error());
  61. }
  62. mysql_select_db('REPUBLICA');
  63.  
  64. $qry="INSERT INTO DATO1 (ID, P01_01, P02_01, P03_01, FECHA)
  65. VALUES
  66. ('01', '$P01_01', $P02_01, $P03_01, NOW()), 
  67. ('02', '$P01_02', $P02_02, $P03_02, NOW()), 
  68. ('03', '$P01_03', $P02_03, $P03_03, NOW()), 
  69. ('04', '$P01_04', $P02_04, $P03_04, NOW()), 
  70. ('05', '$P01_05', $P02_05, $P03_05, NOW()), 
  71. ('06', '$P01_06', $P02_06, $P03_06, NOW()), 
  72. ('07', '$P01_07', $P02_07, $P03_07, NOW()), 
  73. ('08', '$P01_08', $P02_08, $P03_08, NOW()), 
  74. ('09', '$P01_09', $P02_09, $P03_09, NOW()), 
  75. ('10', '$P01_10', $P02_10, $P03_10, NOW());";
  76.  
  77. mysql_query ($qry);
  78.  
  79. }
?>
Código HTML: 
Ver original
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  5. <title>PRUEBA</title>
  6. </head>
  7.  
  8. <body>
  9. <form name="formulario" id="formulario" action="<?=$_SERVER['PHP_SELF']?>" method="post" >
  10. <table>
  11.   <tr>
  12.     <td>RENGLONES PARA CAPTURAR</td>
  13.     <td><input type="text" name="NC" id="NC" size="2" maxlength="2" /></td>
  14.   </tr>
  15. </table>
  16. <table>
  17.   <tr>
  18.     <td><div align="center">ID</div></td>
  19.     <td><div align="center">NOMBRE</div></td>
  20.     <td><div align="center">SEXO</div></td>
  21.     <td><div align="center">EDAD</div></td>
  22.   </tr>
  23.   <tr>
  24.     <td><div align="center">01</div></td>
  25.     <td><div align="center">
  26.       <input type="text" name="P01_01" id="P01_01" />
  27.     </div></td>
  28.     <td><div align="center">
  29.       <input type="text" name="P02_01" id="P02_01" size="1" maxlength="1" />
  30.     </div></td>
  31.     <td><div align="center">
  32.       <input type="text" name="P03_01" id="P03_01" size="3" maxlength="3" />
  33.     </div></td>
  34.   </tr>
  35.   <tr>
  36.     <td><div align="center">02</div></td>
  37.     <td><div align="center">
  38.       <input type="text" name="P01_02" id="P01_02" />
  39.     </div></td>
  40.     <td><div align="center">
  41.       <input type="text" name="P02_02" id="P02_02" size="1" maxlength="1" />
  42.     </div></td>
  43.     <td><div align="center">
  44.       <input type="text" name="P03_02" id="P03_02" size="3" maxlength="3" />
  45.     </div></td>
  46.   </tr>
  47.   <tr>
  48.     <td><div align="center">03</div></td>
  49.     <td><div align="center">
  50.       <input type="text" name="P01_03" id="P01_03" />
  51.     </div></td>
  52.     <td><div align="center">
  53.       <input type="text" name="P02_03" id="P02_03" size="1" maxlength="1" />
  54.     </div></td>
  55.     <td><div align="center">
  56.       <input type="text" name="P03_03" id="P03_03" size="3" maxlength="3" />
  57.     </div></td>
  58.   </tr>
  59.   <tr>
  60.     <td><div align="center">04</div></td>
  61.     <td><div align="center">
  62.       <input type="text" name="P01_04" id="P01_04" />
  63.     </div></td>
  64.     <td><div align="center">
  65.       <input type="text" name="P02_04" id="P02_04" size="1" maxlength="1" />
  66.     </div></td>
  67.     <td><div align="center">
  68.       <input type="text" name="P03_04" id="P03_04" size="3" maxlength="3" />
  69.     </div></td>
  70.   </tr>
  71.   <tr>
  72.     <td><div align="center">05</div></td>
  73.     <td><div align="center">
  74.       <input type="text" name="P01_05" id="P01_05" />
  75.     </div></td>
  76.     <td><div align="center">
  77.       <input type="text" name="P02_05" id="P02_05" size="1" maxlength="1" />
  78.     </div></td>
  79.     <td><div align="center">
  80.       <input type="text" name="P03_05" id="P03_05" size="3" maxlength="3" />
  81.     </div></td>
  82.   </tr>
  83.   <tr>
  84.     <td><div align="center">06</div></td>
  85.     <td><div align="center">
  86.       <input type="text" name="P01_06" id="P01_06" />
  87.     </div></td>
  88.     <td><div align="center">
  89.       <input type="text" name="P02_06" id="P02_06" size="1" maxlength="1" />
  90.     </div></td>
  91.     <td><div align="center">
  92.       <input type="text" name="P03_06" id="P03_06" size="3" maxlength="3" />
  93.     </div></td>
  94.   </tr>
  95.   <tr>
  96.     <td><div align="center">07</div></td>
  97.     <td><div align="center">
  98.       <input type="text" name="P01_07" id="P01_07" />
  99.     </div></td>
  100.     <td><div align="center">
  101.       <input type="text" name="P02_07" id="P02_07" size="1" maxlength="1" />
  102.     </div></td>
  103.     <td><div align="center">
  104.       <input type="text" name="P03_07" id="P03_07" size="3" maxlength="3" />
  105.     </div></td>
  106.   </tr>
  107.   <tr>
  108.     <td><div align="center">08</div></td>
  109.     <td><div align="center">
  110.       <input type="text" name="P01_08" id="P01_08" />
  111.     </div></td>
  112.     <td><div align="center">
  113.       <input type="text" name="P02_08" id="P02_08" size="1" maxlength="1" />
  114.     </div></td>
  115.     <td><div align="center">
  116.       <input type="text" name="P03_08" id="P03_08" size="3" maxlength="3" />
  117.     </div></td>
  118.   </tr>
  119.   <tr>
  120.     <td><div align="center">09</div></td>
  121.     <td><div align="center">
  122.       <input type="text" name="P01_09" id="P01_09" />
  123.     </div></td>
  124.     <td><div align="center">
  125.       <input type="text" name="P02_09" id="P02_09" size="1" maxlength="1" />
  126.     </div></td>
  127.     <td><div align="center">
  128.       <input type="text" name="P03_09" id="P03_09" size="3" maxlength="3" />
  129.     </div></td>
  130.   </tr>
  131.   <tr>
  132.     <td><div align="center">10</div></td>
  133.     <td><div align="center">
  134.       <input type="text" name="P01_10" id="P01_10" />
  135.     </div></td>
  136.     <td><div align="center">
  137.       <input type="text" name="P02_10" id="P02_10" size="1" maxlength="1" />
  138.     </div></td>
  139.     <td><div align="center">
  140.       <input type="text" name="P03_10" id="P03_10" size="3" maxlength="3" />
  141.     </div></td>
  142.   </tr>
  143.   <tr>
  144.     <td colspan="4"><div align="center">
  145.       <input type="submit" name="Guardar" value="Guardar" />
  146.     </div></td>
  147.     </tr>
  148. </table>
  149. </form>
  150. </body>
  151. </html>

Lo que quiero hacer es que con el campo de tengo llamado "NC" insertar el numero que tecleen ahí

por ejemplo: si teclean 03 en ese campo que nada mas inserte 3 renglones en la base de datos de los diez que tengo por defecto.

de antemano les doy las gracias y espero que con esto quede claro lo que quiero hacer (soy novato quisiera que me lo detallaran el procedimiento)

buena tarde tengan