[SOLUCIONADO] Javascript para ejecutar PHP (que guarda datos)

[diegoguerrero]

Hola!!

Tengo dos PHPs: uno para mostrar una tabla entera con información y campos y otro para guardar los cambios mediante un for php y demás. El caso, que me gustaría hacer que se guardara en el mismo PHP, es decir, que no se cambie la página. He estado leyendo que se podría hacer con JavaScript o con AJAX, pero no domino ninguno de esos temas. ¿Me podríais dar el código o pistas para poder hacerlo? Dejo el PHP de guardar los cambios y el array que me devuelve PHP que meto en la DB.
Array

Código del array:

Array ( [Items] => Array ( [0] => NC1 [1] => NC2 [2] => NC3 ) [1] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [2] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [3] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [4] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [5] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [6] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [7] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [8] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [9] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [10] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [11] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [12] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [13] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [14] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [15] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [16] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [17] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [18] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [19] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [20] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [21] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [22] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [23] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [24] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [25] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [26] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [27] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [28] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [29] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [30] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [31] => Array ( [0] => 1 [1] => 2 [2] => 3 ) [32] => Array ( [0] => 4 [1] => 5 [2] => 6 ) [33] => Array ( [0] => 7 [1] => 8 [2] => 9 ) [Tabla] => PROF2-ASIG1-EV2 [Curso] => 1 [Ev] => 2 )
 

PHP que guarda cambios

Código PHP:

<?php
require ("../../../SiempreAdjunto.php");
for ($a = 1; $a <= count($_GET) - 4; $a++){
    for ($i = 0; $i < count($_GET[$a]); $i++){
        $Query = "UPDATE `".$_GET['Tabla']."-Cuaderno` SET `".$_GET['Items'][$i]."` = '".$_GET[$a][$i]."' WHERE `NumeroLista` = '".$a."'";
        $MyQuery = $MyConnect->query($Query);
    }
}
?>
 

Gracias!!

[sanandresm]

Yo te dare codigo:

PHP:

Código PHP:

<?php
    $dats = json_decode($_REQUEST["d"], true);
    // la variable $dats queda con el array que enviamos
?>
 

JavaScript:

Código Javascript:

dats = JSON.stringify(ARRAY_A_ENVIAR);
    var xmlHttp;
    try
    {
        xmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
    }
    catch(e)
    {
        try
        {
             xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        catch(oc)
    }
    if(!xmlHttp && typeof XMLHttpRequest != "undefined")
    {
        xmlHttp = new XMLHttpRequest();
    }
    var ajaxRequest = 'script.php?d=' + dats;
    xmlHttp.open("GET", ajaxRequest, true);
    xmlHttp.send(null);
 

Obviamente script.php es el nombre del archivo en php