I have a web page that contain a table. Every rows has a checkbox. When the user select the rows, using checkbox, and push a button(I save the codes in array) It show a window-modal with four buttons(input). When click one of this buttons it launch a PHP page to update database.

Now when it showed the window modal I get an array with the codes of the selections rows and I do not know how to send this array(jquery code) to PHP page using POST method.

HTML code of window-modal:

<!-- CHANGE STATUS MODAL MENU -->

<div class="modal fade" id="change" tabindex="-1" role="dialog" aria-labelledby="change" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">

            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true"><span class="glyphicon glyphicon-remove" aria-hidden="true"></span></button>
                <h4 class="modal-title custom_align" id="Heading">CANVIAR ESTAT</h3>    
            </div>

            <form action="updateEstado.php" method="post">  
                <div class="modal-body">
                    <div class=" text-center">

                                <div class="container-fluid">   
                                    <div class="row">
                                        <div class="col-md-12 text-center">
                                            <input type="submit" class="btn btn-modal-estado" style="background-color:YellowGreen; color:white;" value="ACTIVAT">
                                        </div>
                                    </div>

                                    <div class="row">
                                        <div class="col-md-12 text-center">
                                            <input type="submit" class="btn btn-modal-estado" style="background-color:Tomato; color:white;" value="PENDENT MIQUEL ALIMENTACIÓ">         
                                        </div>
                                    </div>

                                    <div class="row ">
                                        <div class="col-md-12 text center">
                                            <input type="submit" class="btn btn-modal-estado" style="background-color:SkyBlue; color:white;" value="PENDENT ADDCOM">
                                        </div>  
                                    </div>

                                    <div class="row">
                                        <div class="col-md-12 text center">
                                            <input type="submit" class="btn btn-modal-estado" style="background-color:Gray; color:white;" value="DESACTIVAT">
                                        </div>
                                    </div>

                                    <div class="row">
                                        <h5 id='codigosSeleccionados'></h5>
                                    </div>
                                </div>    

                        </div>   
                    </div>
                </form>
            </div>
        </div>
    </div> 
</div>

Jquery code:

/* CHANGE MODAL WINDOW */

    $('#change').on('show.bs.modal', function (event) {

        var arrayCod = new Array();

        $('#tableprod').find('tbody tr').each(function () {

                var $button = $(event.relatedTarget) // Button that triggered the modal
                var row = $(this);

                if (row.find('input[type="checkbox"]').is(':checked')) {

                    var field = $(this).data("field");
                    var cod;

                    $tds = row.find("td"); // get all table cells in that row

                    $.each($tds, function(index,value) {

                        var field = $(this).data("field");

                        if (field == 'codigo'){
                            cod = $(this).text();
                            console.log(cod);
                            arrayCod.push(cod);
                            return false;   
                        }
                    });

                }

                if (arrayCod.length != 0){
                    $('input[type="submit"]').prop('disabled', false);
                    $('#codigosSeleccionados').text(arrayCod.length + " codis seleccionats");




                } else {
                    $('input[type="submit"]').prop('disabled', true);
                    $('#codigosSeleccionados').text("Cap codi seleccionat");    
                }

            });

            //$('#codigosSeleccionados').text("CODIS SELECCIONATS: " + strCods);
            console.log(arrayCod.length);  
    });

And PHP page:

        $conn = dbConnect("localhost", "5432", "dbname", "dbuser", "dbpass");  

            $codigo = $_POST['codigo'];

            $query = "UPDATE produccion.ma_producto SET estado={$estado} WHERE codigo={$codigo}"; 

            $result = pg_query($conn, $query);

I'm not sure to how do it, Could I save in global php variable from jquery? Or Could I send the array with method post when it click on button? :(

zhangshaoxiong0221

codis部署关于slots初始化报错

1条回答

为你推荐