Recover variable via ajax requests

Question

Recover variable via ajax requests

Asked 6 years, 5 months ago

Viewed 62 times

0

I have the following fields:

<div class="container">
   <div class="form-group">
        <label for="nomefiltrar" style="color:#E4CDAC; font-size: 17px; font-
        family:Arial">Nome</label>
   <p>

   <input type="text" class="teste" id="nomefiltrar" name="nomefiltrar" />


   </div>

  <button type="submit" class="btn btn-custom btn-roxo btn_carrega_conteudo" id="teste">Filtrar</button>
</div>

I need to recover the value of the "name filter" field and send it through the post method to the "pdf_clients.php page".

I tried something like:

<script type="text/javascript">
        $(document).ready(function(){
                $('.btn_carrega_conteudo').click(function(){
                    if($('#nomefiltrar').val().length > 0){
                        $.ajax({
                            url: 'pdf_clientes.php',
                            method: 'post',
                            data: { nomefiltrar: $('#nomefiltrar').val() },
                            success: function(data){
                                alert('Teste');
                            }
                        });
                    }
            });
        });

</script>

I’m even receiving Alert that the request has been completed, but when I give the post on the page pdf_clients.php, I can’t recover the value of the field nameplower.

pdf_clients.php:

$nome_filtrar = $_POST['nomefiltrar'];
<h1>{$nome_filtrar}</h1>

Follow my complete code:

query.php clients.:

<?php include_once("registra_pessoa.php");
    $grupo = filtraPessoas();



    if(!$_SESSION['usuario']){
        header('Location: index.php?erro=1');
    }

?>

<!DOCTYPE HTML>
<html lang="pt-br">
    <head>



        <script type="text/javascript">
            function ocultaForm(tag){
                $(tag).show();
            }
        </script>

        <meta charset="UTF-8">

        <title>Despesas</title>

        <!-- jquery - link cdn -->

          <script src="https://code.jquery.com/jquery-3.2.1.min.js"
          integrity="sha256-hwg4gsxgFZhOsEEamdOYGBf13FyQuiTwlAQgxVSNgt4="
          crossorigin="anonymous"></script>

          <script type="text/javascript" src="js/jquery.mask.min.js"/></script>


        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>

        <!-- bootstrap - link cdn -->
        <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
        <link href="estilo.css" rel="stylesheet">
        <script type="text/javascript">
        $(document).ready(function(){
                $('.btn_carrega_conteudo').click(function(){
                    if($('#nomefiltrar').val().length > 0){
                        $.ajax({
                            url: 'pdf_clientes.php',
                            method: 'post',
                            data: { nomefiltrar: $('#nomefiltrar').val() },
                            success: function(data){
                                alert('Teste');
                            }
                        });
                    }
            });
        });


        </script>


    </head>

    <body>

<!-- Static navbar -->
        <nav class="navbar navbar-fixed-top navbar-inverse navbar-transparente">
            <div class="container">
                <div class="navbar-header">
                    <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#barranavegacao">
                        <span class="sr-only">Alternar navegação</span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                    </button>

                    <a href="home.php" class="navbar-brand">
                       <span class="img-logo">Despesas</span>
                    </a>
                </div>

                <div class="collapse navbar-collapse" id="barranavegacao">
                    <ul class="nav navbar-nav">
                      <li><a href="home.php">Home</a></li>
                      <li class="dropdown">
                        <a class="dropdown-toggle" data-toggle="dropdown" href="#">Cadastro
                        <span class="caret"></span></a>
                        <ul class="dropdown-menu">
                          <li><a href="inserir_pessoa.php">Cadastro de Clientes</a></li>
                          <li><a href="inserir_produto.php">Cadastro de Produtos</a></li>
                        </ul>
                      </li>
                      <li class="dropdown active">
                        <a class="dropdown-toggle" data-toggle="dropdown" href="#">Consultas
                        <span class="caret"></span></a>
                        <ul class="dropdown-menu">
                          <li><a href="consulta_clientes.php">Consulta de Clientes</a></li>
                          <li><a href="consulta_produtos.php">Consulta de Produtos</a></li>
                          <li role="separator" class="divider"></li>
                          <li><a href="consulta_contas.php">Consulta de Contas a Pagar</a></li>
                          <li><a href="consulta_contas_receber.php">Consulta de Contas a Receber</a></li>
                      </ul>
                      <li class="dropdown">
                        <a class="dropdown-toggle" data-toggle="dropdown" href="#">Financeiro
                        <span class="caret"></span></a>
                        <ul class="dropdown-menu">
                          <li><a href="inserir_conta.php">Contas a Pagar</a></li>
                          <li><a href="inserir_recebimento.php">Contas a Receber</a></li>
                        </ul>
                      </li>


                    </ul>

                      <ul class="nav navbar-nav navbar-right">
        <li>
          <a href="">Ajuda</a>
        </li>
        <li class="divisor" role="separator">
        </li>
        <li>
          <a href="sair.php">Sair</a>
        </li>
    </ul>
</div>



            </div>
        </nav>
        <br><br><br><br><br>


        <div class="container">
        <div class="thumb">
        <a href="pdf_clientes.php" target="_blank">
        <img src="imagens/printer.png">
        </a>
        <div class="desc"><span style="color:white">Imprimir Relatório</span></div>
        </div>

        <div class="thumb">
            <img id="filtraresultados" name="filtraresultados" src="imagens/search.png" style="cursor:pointer" "/>
        <div class="desc"><span style="color:white">Filtrar Resultados</span></div>
        </div>


        </div>


        <br>

        <div class="container">


            <div class="form-group">
                <label for="nomefiltrar" style="color:#E4CDAC; font-size: 17px; font-family:Arial">Nome</label>
                <p>

                <input type="text" class="teste" id="nomefiltrar" name="nomefiltrar" />


            </div>

            <button class="btn btn-custom btn-roxo btn_carrega_conteudo" id="teste">Filtrar</button>
        </div>



<br>



        <script>
            filtraresultados.addEventListener("click", function() {
                ocultaForm('form');
            }, false);
        </script>

        <script>
            filtraresultados.addEventListener("click", function() {
                ocultaFormBotao('input');
            }, false);
        </script>






        <div class="container divconsultas">

                <table class="table">
            <thread>
                <tr>
                    <td align="center" style="color:white; font-size: 17px; font-family:Tahoma">Nome</td>
                    <td align="center" style="color:white; font-size: 17px; font-family:Tahoma">Data de nascimento</td>
                    <td align="center" style="color:white; font-size: 17px; font-family:Tahoma">Telefone</td>
                    <td align="center" style="color:white; font-size: 17px; font-family:Tahoma">Endereço</td>
                    <td align="center" style="color:white; font-size: 17px; font-family:Tahoma">Editar</td>
                    <td align="center" style="color:white; font-size: 17px; font-family:Tahoma">Excluir</td>
                </tr>
            </thread>
                <?php
                if (is_array($grupo) || is_object($grupo)){
                foreach($grupo as $pessoa){
                 ?>

                    <tr>
                        <td align="center" style="color:white; font-size: 15px; font-family:Tahoma"> <?=$pessoa["nome"]?> </td>
                        <td align="center" style="color:white; font-size: 15px; font-family:Tahoma"> <?=$pessoa["data_formatada"]?> </td>
                        <td align="center" style="color:white; font-size: 15px; font-family:Tahoma"> <?=$pessoa["telefone"]?> </td>
                        <td align="center" style="color:white; font-size: 15px; font-family:Tahoma"> <?=$pessoa["endereco"]?></td>
                        <td align="center" style="color:white; font-size: 15px; font-family:Tahoma">

                             <form align="center" action="alterar_pessoa.php" name="alterar" method="POST">
                                <input type="hidden" name="id" value=<?=$pessoa["id"]?>>
                                <input type="submit" class="btn editar cor" value="Editar" name="Editar" class="btn btn-default">
                             </form>

                        </td>
                        <td>

                            <form align="center" action="registra_pessoa.php" name="excluir" method="POST">
                                <input type="hidden" name="id" value=<?=$pessoa["id"]?>>
                                <input type="hidden" name="acao" value="excluir"/>
                                <input type="submit" class="btn editar excluir" onclick="msgSucesso()" value="Excluir" name="excluir" class="btn btn-default">
                            </form>

                        </td>
                    </tr>


                </div>

                    <script>
                        function msgSucesso(){
                            alert('Pessoa excluida com sucesso');
                        }
                    </script>


                <?php
                }
            }else{
                echo('Ainda não existem clientes cadastrados');
            }

                ?>

            </table>
        </div>




    </body>
</html>

pdf_clients.php:

<?php
    include_once("registra_pessoa.php");
    include("./MPDF57/mpdf.php");
    $nome_filtrar = $_POST['nomefiltrar'];
    $pessoas = filtraPessoas();
    $mpdf = new mPDF();
    $mpdf->setDisplayMode("fullpage");
    $mpdf->WriteHTML("<h1 align='center'>Relatório de Clientes</h1> <hr/>");

            $html = "
            <table class='tabela'>
            <thread>
                <tr>
                    <th>Nome</span></th>
                    <th>Data de nascimento</span></th>
                    <th>Telefone</th>
                    <th>Endereço</th>
                </tr>
            </thread>
            <tbody>
            ";
                foreach($pessoas as $pessoa){

                    $html = $html ." <tr>
                        <td align='center'> {$pessoa["nome"]} </td>
                        <td align='center'> {$pessoa["data_formatada"]} </td>
                        <td align='center'> {$pessoa["telefone"]} </td>
                        <td align='center'> {$pessoa["endereco"]} </td>
                    </tr>";
                }

                $html = $html ."
                </tbody>
                </table>
                <h1>{$nome_filtrar}</h1>
                ";

    $css = file_get_contents('pdf_estilo.css');
    $mpdf->WriteHTML($css, 1);
    $mpdf->WriteHTML($html);
    $mpdf->Output();
    exit();

?>

Function registra_person.php:

function filtraPessoas(){
    $grupo = '';
    $banco = abrirBanco();
    $teste = $_POST['nomefiltrar'];

    $sql = "SELECT id, nome, DATE_FORMAT(nascimento, '%d/%m/%Y') AS data_formatada, endereco, telefone FROM pessoa WHERE nome LIKE '%$teste%' ";
    $resultado = $banco->query($sql);
    $banco->close();
    while($row = mysqli_fetch_array($resultado)){
        $grupo[] = $row;
    }
    return $grupo;
}

makes a test by exchanging $('#name filter'). val() for 'Eticia' in ajax, and how Oce knows he can’t recover? because of H1?

– Julio Henrique

2018/02/05 at 13:50
I switched and still didn’t recover the value

– veroneseComS

2018/02/05 at 13:58
Yes, in <H1> shows nothing

– veroneseComS

2018/02/05 at 14:02
managed to solve?

– Julio Henrique

2018/02/05 at 17:04
I couldn’t write anything in the chat. I decided to create a proper button to filter the field for the report.

– veroneseComS

2018/02/05 at 18:52

No answers

Browser other questions tagged php html jquery mysql ajax

You are not signed in. Login or sign up in order to post.