[SOLUCIONADO] Guardar MUCHOS registros y datos en MySQL

[diegoguerrero]

Tengo el siguiente array $_GET, que contiene otros arrays (33 en este caso) y que cada uno tiene 10 ítems en este caso, siendo estas dos cantidades variables y necesito generar las consultas correspondientes y guardarlas. Tengo perfilado el código (abajo lo dejo) y, por favor, decidme qué va mal porque me genera un bucle infinito. Gracias.

Array ( [ALM1] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM2] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM3] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM4] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM5] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM6] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM7] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM8] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM9] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM10] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM11] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM12] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM13] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM14] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM15] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM16] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM17] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM18] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM19] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM20] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM21] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM22] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM23] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM24] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM25] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM26] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM27] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM28] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM29] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM30] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM31] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM32] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) [ALM33] => Array ( [0] => [1] => [2] => [3] => [4] => [5] => [6] => [7] => [8] => [9] => [10] => [11] => [12] => ) )

Código PHP:

<?php
foreach($_GET['ALM'.$a] as $Calificaciones){
    $Query = "UPDATE `CuadernoCalificaciones` ";
    $i = 0;
    while ($i <= count($_GET['ALM'.$a])) {
        $Query .= " EJEMPLO1";
    }   $Query .= " WHERE `NumeroIdentificacionAlumno` = '".$a."'";
}
echo $Query;
?>
 

[Alexis88]

El valor de $i nunca incrementa, por lo tanto, siempre se cumplirá la condición y el bucle no se detendrá.

Un saludo

[diegoguerrero]

Vale pero, ¿cómo se podría generar ese bucle para que guarde todo en MySQL?

[carlillos]

Para recorrer todos los arrays puedes hacer un bucle para las calificaciones dentro del bucle de los alumnos.

Código PHP:

  foreach($_GET as $alumno => $calificaciones) {
    
    foreach($calificaciones as $calificacion) {
    
        echo "Alumno: $alumno | Calificación: $calificacion<br>";
        
    }
    
} 
   

La variable "$alumno" tiene el id de alumno y "$calificacion" la calificación. Con esas variables puedes generar el query para insertar los datos en tu tabla.

Saludos.

[Alexis88]

Adicionalmente a lo que te han dicho, puedes armar múltiples cadenas SQL separadas por puntos y comas y ejecutarlas todas a la vez con la función mysqli_multi_query().

Sería algo similar a esto:

Código PHP:

$consultas = [];
 
foreach (/* ... */){
    $consulta = 'UPDATE [tabla] SET';
    $pares = [];
    foreach (/* ... */){
        $pares[]= '[campo] = [valor]';
    }
    $consulta .= implode(',', $pares) . ' WHERE [condición]';
    $consultas[] = $consulta;
}
 
if (mysqli_multi_query($conexion, implode(';', $consultas))){
    echo 'Las consultas se ejecutaron exitosamente';
}
 

Necesitas un array para almacenar las consultas, una variable para almacenar cada consulta que luego añadirás al array y un segundo array para almacenar los pares campo y valor a actualizar. Con la función implode() puedes unir a todos los elementos de un array mediante un carácter, convirtiéndose todo en una cadena de texto.

Un saludo