Receive javascript data to query in mysql

Question

Receive javascript data to query in mysql

Navigation

#1 by (2 votes)

1

I was trying to return the post_id variable to php in order to do SELECT in mysql, but I'm not able to work with post_id. How to make the query?

    <script type="text/html" id="javo-map-tab-infobx-content">
     <div class="btn-group btn-group-justified pull-right">
                    <a id="botaoBrief" class="btn btn-primary btn-sm" onclick="window.javo_map_tab_func.brief_run(this);" data-id="{post_id}">
                        <i class="fa fa-user"></i> <?php _e("Briefaaaa", "javo_fr"); ?>
                    </a>

From post_id I'll make a query and receive the value of a plan for the post. So I'll decide if I show:

<a id='colorDetail' href='{permalink}' class='btn btn-primary btn-sm'>
                                <i class='fa fa-group'><span>  Detalhes</span></i>
                            </a>

Or if it displays:

<a id='colorDetail' class='btn btn-primary btn-sm'>
                                <i class='fa fa-group'><span>  Sem Detalhes</span></i>
                            </a>

How to make the query so my code knows what to display?

php javascript wordpress

asked by anonymous 04.09.2015 / 01:15

1 answer

Make button disappear persistence of data in two or more banks simultaneously [closed]

score 2 · Accepted Answer

I believe that a request with a jQuery help would help a lot.

The first step is to assign a click event to the desired element:

//Aplica o script apenas quando a página carregar
$(document).ready(function(){
  $btnBrief = $("#botaoBrief");
  $btnBrief.on("click", function(e){
    //Evita que o botão clicado faça alguma coisa exceto o que vamos orientar dentro deste método
    e.preventDefault();

    //Pegamos o ID que você precisa do elemento
    var idPost = $(this).attr("data-id");
    //Envia uma requisição POST assincrona para o script que tratará seu dado
                   //índice $_POST no PHP : var no javascript definida acima
                   //            |              |
                   //            |        ______|  Executa ao fim do script
                   //            |       |            |
                   //            |       |            |      |- Resposta
    $.post("seuscript.php", { idPost: idPost }, function(response){
       //Joga o resultado no lugar desejado. Ex. #colorDetail-container
       $("#colorDetail-container").html(response);
    } 
  });
});

The above code can be saved in a .js file or placed in HTML within <script></script>

Receiving the data, your PHP script will treat idPost any way you want.

suscript.php

<?php 
  $idPost = $_POST['idPost'];

  //Faça as consultas que quiser
  //Toda sua lógica de exibir um tipo de link ou outro entra aqui

  //Ao final, decida qual saída você dará em seu script
  if($temDetalhes){
     echo "<a id='colorDetail' href='".$permalink."' class='btn btn-primary btn-sm'><i class='fa fa-group'><span>  Detalhes</span></i></a>";
  }else{
     echo "<a id='colorDetail' class='btn btn-primary btn-sm'><i class='fa fa-group'><span>  Sem Detalhes</span></i></a>";
  }

I hope I have helped.