I am making a form where the user views several data that I already have stored in my database, and the same user can add several comments that have to be uploaded to the DB.
When I made the queries, I did them with a While
so that the table would be duplicated depending on the amount of data it had stored, it gave me many problems as with Foreach
. And I decided to do it record by record.
Here the other problem begins, when I did the queries (SELECT * FROM)
everything was fine, the data I wanted appeared in my HTML table, but when I wanted to insert the data added by the user, I got the following error:
Warning: Undefined array key "comments1"
Here is the code, if you can help me or if you know of a way to do it without using so much code:
<?php
include("conexion.php");
include("registrar.php");
?>
<!DOCTYPE html>
<html>
<head>
<title>AUDITORIA</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<form action="registrar.php" method="post">
<img src="secretariaDeSalud.jpg" height="150px" align="left">
<img src="LOGOnombre3.jpg" height="150px" align="right">
<div>
<h1><P align="center" style = "font-family: calibri"><b> Herramienta de auditoria de muestras HICPAC adaptada al INCMNSZ:
Reprocesamiento de endoscopios flexibles</b></P></h1>
<hr size="3px" color="black"/>
<div class="divmov">
<p style="font-family: calibri"><b>Persona Evaluada: </b>
<input type="text" name="evaluado" placeholder="Nombre">
<?php ?>
<p style="font-family: calibri"><b>Evaluador: </b>
<input type="text" name="evaluador1" placeholder="Auditor 1" size="30">
<input type="text" name="evaluador2" placeholder="Auditor 2" size="30">
<input type="text" name="evaluador3" placeholder="Auditor 3" size="30">
<?php
?>
</div>
<table align= "center" width="80%" border="1">
<tr>
<th width="50%"> Elementos de auditoría</th>
<th width="15%">Si/No/NA</th>
<th>Comentarios/Acción</th>
</tr>
<!---------------CONSULTAS EN LA TABLA----------------->
<tr>
<td><<?php echo $arr1['NomElementoPrinc']; ?></td>
</tr>
<tr>
<td><?php echo $array1['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si1" value="Si"> Si
<input type="radio" name="no1" value="No"> No
<input type="radio" name="na1" value="NA"> NA </td>
<td><input name="comentarios1" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array2['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si2" value="Si"> Si
<input type="radio" name="no2" value="No"> No
<input type="radio" name="na2" value="NA"> NA </td>
<td><input name="comentarios2" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array3['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si3" value="Si"> Si
<input type="radio" name="no3" value="No"> No
<input type="radio" name="na3" value="NA"> NA </td>
<td><input name="comentarios3" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array4['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si4" value="Si"> Si
<input type="radio" name="no4" value="No"> No
<input type="radio" name="na4" value="NA"> NA </td>
<td><input name="comentarios4" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array5['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si5" value="Si"> Si
<input type="radio" name="no5" value="No"> No
<input type="radio" name="na5" value="NA"> NA </td>
<td><input name="comentarios5" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array6['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si6" value="Si"> Si
<input type="radio" name="no6" value="No"> No
<input type="radio" name="na6" value="NA"> NA </td>
<td><input name="comentarios6" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array7['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si7" value="Si"> Si
<input type="radio" name="no7" value="No"> No
<input type="radio" name="na7" value="NA"> NA </td>
<td><input name="comentarios7" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array8['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si8" value="Si"> Si
<input type="radio" name="no8" value="No"> No
<input type="radio" name="na8" value="NA"> NA </td>
<td><input name="comentarios8" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array9['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si9" value="Si"> Si
<input type="radio" name="no9" value="No"> No
<input type="radio" name="na9" value="NA"> NA </td>
<td><input name="comentarios9" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array10['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si10" value="Si"> Si
<input type="radio" name="no10" value="No"> No
<input type="radio" name="na10" value="NA"> NA </td>
<td><input name="comentarios10" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array11['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si11" value="Si"> Si
<input type="radio" name="no11" value="No"> No
<input type="radio" name="na11" value="NA"> NA </td>
<td><input name="comentarios11" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array12['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si12" value="Si"> Si
<input type="radio" name="no12" value="No"> No
<input type="radio" name="na12" value="NA"> NA </td>
<td><input name="comentarios12" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array13['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si13" value="Si"> Si
<input type="radio" name="no13" value="No"> No
<input type="radio" name="na13" value="NA"> NA </td>
<td><input name="comentarios13" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array14['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si14" value="Si"> Si
<input type="radio" name="no14" value="No"> No
<input type="radio" name="na14" value="NA"> NA </td>
<td><input name="comentarios14" placeholder="Agrega Comentarios" type="text"></td>
</tr>
<tr>
<td><?php echo $array15['NombreElemento']; ?></td>
<td align ="center">
<input type="radio" name="si15" value="Si"> Si
<input type="radio" name="no15" value="No"> No
<input type="radio" name="na15" value="NA"> NA </td>
<td><input name="comentarios15" placeholder="Agrega Comentarios" type="text"></td>
</tr>
</table>
<div class="divtabla">
</div>
<div align="right">
<button class="button-43" name="boton" role="button"><b>ENVIAR</b></button>
</div>
</form>
</body>
</html>
PHP SECTION
<?php include("conexion.php");
//----------------Consultar Subelemetos--------------------------
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 1");
$array1 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 2");
$array2 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 3");
$array3 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 4");
$array4 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 5");
$array5 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 6");
$array6 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 7");
$array7 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 8");
$array8 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 9");
$array9 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 10");
$array10 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 11");
$array11 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 12");
$array12 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 13");
$array13 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 14");
$array14 = mysqli_fetch_array($query);
$query = mysqli_query($conexion, "SELECT * FROM elementos WHERE idelementos = 15");
$array15 = mysqli_fetch_array($query);
//-------------------Inserta Comentarios------------------------------------
$comentario1 = $_POST['comentarios1'];
$consulta = "INSERT INTO comentarios(comentario) VALUES ('$comentario1')";
$result = mysqli_query($conexion, $consulta);
$comentario2 = $_POST['comentarios2'];
$consulta = "INSERT INTO comentarios(comentario) VALUES ('$comentario2')";
$result = mysqli_query($conexion, $consulta);
$comentario3 = $_POST['comentarios3'];
$consulta = "INSERT INTO comentarios(comentario) VALUES ('$comentario3')";
$result = mysqli_query($conexion, $consulta);
$comentario4 = $_POST['comentarios4'];
$consulta = "INSERT INTO comentarios(comentario) VALUES ('$comentario4')";
$result = mysqli_query($conexion, $consulta);