Dialog to feed form field

Question

Dialog to feed form field

Navigation

#1 by (1 votes)

0

In my page there are fields that are tabulated data, where the user should select an existing data in the table

For a simple case, I'm using <select><option> of html fed with a table reading via php , however I came across a case where the data in a table is many. With this the combo gets very large and the page gets heavy to load.

I would like to know how to insert a sort of button that calls a dialog that will display the table with values, where the user can click on the data and it will be sent to form .

$ (function () { $ ("#datepicker") .datepicker (); }); $ (function () { $ ("#tabs") .tabs (); });

            <?php
            require_once('../../function/funcoes.php');
            ?>
            </head>
            <title>Dober System</title>
              <body>
                 <div id="container">
                            <form action="../../function/funcoes.php"" name="inserir_C" id="inserir_C" method="POST">
                        <div id="Cliente">
                                    <fieldset id="Cliente">
                                            <legend><b>Dados Gerais: </b></legend>
                                            <label for="CODIGO">
                                            Código:<input type="text" name="CODIGO" id="CODIGO" MAXLENGTH="4" value="" onKeyUp="javascript:somente_numero(this);" required/>
                                            </label>
                                            <label for="NOME">
                                            Nome:<input name="NOME" id="NOME" MAXLENGTH="50" value="" />
                                            </label>
                                            <label for="NOMEABR">
                                            Nome Abreviado:<input name="NOMEABR" id="NOMEABR" MAXLENGTH="20" value="" />
                                            </label>
                                            <label for="GRUPO">
                                            Grupo:
                                            <?php 
                                            $rs = mysql_query("SELECT ID,DESCRICAO FROM FINANCEIRO.GRUPO ORDER BY ID"); 
                                            montaCombo('GRP_cmb', $rs, 'ID', 'DESCRICAO',null);
                                            ?>
                                            </label>
                                            <label for="REPRES">
                                            Representante:
                                            <?php 
                                            $rs = mysql_query("SELECT CODIGO,ID FROM FINANCEIRO.REPRESENTANTE ORDER BY CODIGO");    
                                            montaCombo('REPRE_cmb', $rs, 'CODIGO', 'ID',null);
                                            ?>
                                            </label>
                                            <label for="TRANSP">
                                            Transportadora:
                                            <?php 
                                            $rs = mysql_query("SELECT CODIGO,NOME FROM FINANCEIRO.TRANSPORTADORA ORDER BY CODIGO"); 
                                            montaCombo('TRANSP_cmb', $rs, 'CODIGO', 'NOME',null);
                                            ?>
                                            </label>
                                            <!--<label for="DATA">
                                            Data Implant.:<input type="text" name="DATA" id="datepicker" MAXLENGTH="10" value="" />
                                            </label>-->
                                    </fieldset>
                        </div>
                </div>
              </body>
            </html>

            function montaCombo($nome, $rs, $valor, $descricao,$cmb)
            {
            echo("<select name='$nome' class='styled-select'>");
            echo("<option selected='selected'></option>");
            while ($obj = mysql_fetch_object($rs))
            {           
            echo("t<option value='".$obj->$valor."' > ".$obj->$valor.":". $obj->$descricao." </option>");
            }
            if(!$cmb==null)
            {
            $row = mysql_fetch_array($cmb);
            $a= $row[$valor];
            $b=$row[$descricao];
            echo ("<option value=\"$a\" selected>$a:$b</option></select>");
            }else
            {
            echo ("</select>");
            }
            }

html jquery

asked by anonymous 04.09.2014 / 19:19

1 answer

Add or subtract value from a field in a database with CodeIgniter Application migration error, ANTLR and Wildfly incompatibility 8

score 1 · Answer 1

Considering 2 files table.php:

             <table>
                <tr>
                    <td>Linha1 -Valor 1</td><td>Linha1 -Valor 2</td><td>Linha1 -Valor 3</td><td>Linha1 -Valor 4</td>
                </tr>
                <tr>
                    <td>Linha2 -Valor 1</td><td>Linha2 -Valor 2</td><td>Linha2 -Valor 3</td><td>Linha2 -Valor 4</td>
                </tr>
                <tr>
                    <td>Linha3 -Valor 1</td><td>Linha3 -Valor 2</td><td>Linha3 -Valor 3</td><td>Linha3 -Valor 4</td>
                </tr>

            </table>

form.html:

        <!DOCTYPE html>
        <html>
            <head>
                <title>TODO supply a title</title>
                <meta charset="UTF-8">
                <meta name="viewport" content="width=device-width, initial-scale=1.0">
                <script src="//code.jquery.com/ui/1.11.1/jquery-ui.js"></script>
                <style>
                    #dialog table {background: #eeeeee;}
                    #dialog table tr td{padding:3px;border:1px solid #ccc;}
                    #dialog table tr td:hover{box-shadow: 0px 0px 5px #333;background:#fefefe;cursor:pointer;
                    }
                </style>
            </head>
            <body>
                <form>
                    <input type="text" id="nome" name="nome"> <span id="buscar">Buscar</span>
                </form>
                <div id="dialog" style="display: none;" title="tabela">
                    <table border="1">
                        <tr>
                            <td>Linha1 -Valor 1</td><td>Linha1 -Valor 2</td><td>Linha1 -Valor 3</td><td>Linha1 -Valor 4</td>
                        </tr>
                        <tr>
                            <td>Linha2 -Valor 1</td><td>Linha2 -Valor 2</td><td>Linha2 -Valor 3</td><td>Linha2 -Valor 4</td>
                        </tr>
                        <tr>
                            <td>Linha3 -Valor 1</td><td>Linha3 -Valor 2</td><td>Linha3 -Valor 3</td><td>Linha3 -Valor 4</td>
                        </tr>

                    </table>
                </div>

                <script src="//code.jquery.com/jquery-1.10.2.js"></script>
                <script>
                    $.ajax({
                        url: "tabela.php",
                        dataType: 'text',
                        success: function(data, textStatus, jqXHR) {
                            $("#dialog").html(data);

                        }
                    });
                    $("#nome").focus(function() {
                        $("#dialog").show();
                    });
                    $('#dialog').delegate('td', 'click', function() {
                        $("#nome").val($(this).text());
                        $("#dialog").hide();
                    });

                </script>

            </body>
        </html>