Print sql query result in 2 different selections with html and php

Question

Print sql query result in 2 different selections with html and php

Navigation

#1 by (1 votes)
#2 by (0 votes)

1

please help, the problem is that in I have 2 select tags which create the option tags with the result of the query sql, in the first select it works correctly but in the second select they do not load the results, my code:

<div id="crea" class="contenidosPestana">
                <form>
                    <div id='formCliente'class="formRegistro">
                        <h1>Registro Clientes</h1>
                        <label>Identificacion:
                            <select id="tipoId">
                                <?php 
                                    $listaIdentificacion="select *from identificaciones;";
                                    $lista= mysqli_query($conexion, $listaIdentificacion);
                                    while($resultadoI= mysqli_fetch_array($lista)){
                                        $ide=$resultadoI[0];
                                        $codSRI=$resultadoI[1];
                                        $des=$resultadoI[2];
                                        echo "<option value='$ide'>$des</option>";
                                    }
                                ?>
                            </select>

                        </label>
                        <input id="identificacion" type="text" minlength="10" maxlength="13" onkeypress="return valida(event)" required/><br>
                        <label>Razon Social:</label><br>
                        <input id="razonS" type="text" required/><br>
                        <label>Dirección:</label><br>
                        <input id="direccion" type="text" required/><br>
                        <label>Telefono:</label><br>
                        <input id="telefono" type="text" minlength="10" maxlength="13" onkeypress="return valida(event)" required/><br>
                        <label>Celular:</label><br>
                        <input id="celular" type="text" minlength="10" maxlength="13" onkeypress="return valida(event)" required/><br>
                        <label>Correo:</label><br>
                        <input id="correo" type="email" required/><br><br>
                    </div>
                    <div>
                        <input onclick="guardaCliente()" type="button" value="Guardar Cliente" class="btnRegistro"/>
                    </div>
                </form>


                <div id="modal-cliente" class="modal">
                    <div class="modal-contenido">
                        <div class="modal-header">
                            <span class="modal-header-cierre">&times;</span>
                            <h1 id="modalCodCli"></h1>
                        </div>
                        <div id="receptor" class="modal-body">
                           <div class="formRegistro">
                                <label>Identificacion:
                                    <select id="modalTipoId"> 

        <?php //AQUI ES DONDE YA NO CARGA EL RESULTADO

                                        while($resultado= mysqli_fetch_array($lista)){
                                        $ide=$resultadoI[0];
                                        $codSRI=$resultadoI[1];
                                        $des=$resultadoI[2];
                                        echo "<option value='$ide'>$des</option>";}
                                        ?>
                                    </select>

                            </div>
                        </div>
                        <div class="modal-footer">
                            <input id='btnClienteModificar' onclick="modificarCliente()" type="button" value="Modificar" class="btnRegistro"/>&nbsp;<input onclick="" type="button" value="Eliminar" class="btnRegistro"/>
                        </div>
                    </div>
                </div>
            </div>

html php

asked by Felix 30.05.2018 в 17:12

source

2 answers

1

You have to re-launch the query in the second select as the fetch_array has already exhausted the records.

<div id="crea" class="contenidosPestana">
            <form>
                <div id='formCliente'class="formRegistro">
                    <h1>Registro Clientes</h1>
                    <label>Identificacion:
                        <select id="tipoId">
                            <?php 
                                $listaIdentificacion="select *from identificaciones;";
                                $lista= mysqli_query($conexion, $listaIdentificacion);
                                while($resultadoI= mysqli_fetch_array($lista)){
                                    $ide=$resultadoI[0];
                                    $codSRI=$resultadoI[1];
                                    $des=$resultadoI[2];
                                    echo "<option value='$ide'>$des</option>";
                                }
                            ?>
                        </select>

                    </label>
                    <input id="identificacion" type="text" minlength="10" maxlength="13" onkeypress="return valida(event)" required/><br>
                    <label>Razon Social:</label><br>
                    <input id="razonS" type="text" required/><br>
                    <label>Dirección:</label><br>
                    <input id="direccion" type="text" required/><br>
                    <label>Telefono:</label><br>
                    <input id="telefono" type="text" minlength="10" maxlength="13" onkeypress="return valida(event)" required/><br>
                    <label>Celular:</label><br>
                    <input id="celular" type="text" minlength="10" maxlength="13" onkeypress="return valida(event)" required/><br>
                    <label>Correo:</label><br>
                    <input id="correo" type="email" required/><br><br>
                </div>
                <div>
                    <input onclick="guardaCliente()" type="button" value="Guardar Cliente" class="btnRegistro"/>
                </div>
            </form>


            <div id="modal-cliente" class="modal">
                <div class="modal-contenido">
                    <div class="modal-header">
                        <span class="modal-header-cierre">&times;</span>
                        <h1 id="modalCodCli"></h1>
                    </div>
                    <div id="receptor" class="modal-body">
                       <div class="formRegistro">
                            <label>Identificacion:
                                <select id="modalTipoId"> 

    <?php 
                                    //Aquí se tiene que volver a hacer la query
                                    $listaIdentificacion="select *from identificaciones;";
                                    $lista= mysqli_query($conexion, $listaIdentificacion);
                                    while($resultado= mysqli_fetch_array($lista)){
                                    $ide=$resultadoI[0];
                                    $codSRI=$resultadoI[1];
                                    $des=$resultadoI[2];
                                    echo "<option value='$ide'>$des</option>";}
                                    ?>
                                </select>

                        </div>
                    </div>
                    <div class="modal-footer">
                        <input id='btnClienteModificar' onclick="modificarCliente()" type="button" value="Modificar" class="btnRegistro"/>&nbsp;<input onclick="" type="button" value="Eliminar" class="btnRegistro"/>
                    </div>
                </div>
            </div>
        </div>

answered by 30.05.2018 в 17:15

Can you relate 2 tables of different databases by means of a foreign key? Insert all CheckedBox into an ingredients database table

score 0 · Accepted Answer

It is not necessary to do the query again, you can reset the array like this:

<div id="crea" class="contenidosPestana">
                <form>
                    <div id='formCliente'class="formRegistro">
                        <h1>Registro Clientes</h1>
                        <label>Identificacion:
                            <select id="tipoId">
                                <?php 
                                    $listaIdentificacion="select *from identificaciones;";
                                    $lista= mysqli_query($conexion, $listaIdentificacion);
                                    while($resultadoI= mysqli_fetch_array($lista)){
                                        $ide=$resultadoI[0];
                                        $codSRI=$resultadoI[1];
                                        $des=$resultadoI[2];
                                        echo "<option value='$ide'>$des</option>";
                                    }
                                ?>
                            </select>

                        </label>
                        <input id="identificacion" type="text" minlength="10" maxlength="13" onkeypress="return valida(event)" required/><br>
                        <label>Razon Social:</label><br>
                        <input id="razonS" type="text" required/><br>
                        <label>Dirección:</label><br>
                        <input id="direccion" type="text" required/><br>
                        <label>Telefono:</label><br>
                        <input id="telefono" type="text" minlength="10" maxlength="13" onkeypress="return valida(event)" required/><br>
                        <label>Celular:</label><br>
                        <input id="celular" type="text" minlength="10" maxlength="13" onkeypress="return valida(event)" required/><br>
                        <label>Correo:</label><br>
                        <input id="correo" type="email" required/><br><br>
                    </div>
                    <div>
                        <input onclick="guardaCliente()" type="button" value="Guardar Cliente" class="btnRegistro"/>
                    </div>
                </form>


                <div id="modal-cliente" class="modal">
                    <div class="modal-contenido">
                        <div class="modal-header">
                            <span class="modal-header-cierre">&times;</span>
                            <h1 id="modalCodCli"></h1>
                        </div>
                        <div id="receptor" class="modal-body">
                           <div class="formRegistro">
                                <label>Identificacion:
                                    <select id="modalTipoId"> 

        <?php //AQUI ES DONDE YA NO CARGA EL RESULTADO
                                        mysqli_data_seek($lista, 0);
                                        while($resultadoI= mysqli_fetch_array($lista)){
                                        $ide=$resultadoI[0];
                                        $codSRI=$resultadoI[1];
                                        $des=$resultadoI[2];
                                        echo "<option value='$ide'>$des</option>";}
                                        ?>
                                    </select>

                            </div>
                        </div>
                        <div class="modal-footer">
                            <input id='btnClienteModificar' onclick="modificarCliente()" type="button" value="Modificar" class="btnRegistro"/>&nbsp;<input onclick="" type="button" value="Eliminar" class="btnRegistro"/>
                        </div>
                    </div>
                </div>
            </div>