How to find out the value of a select that is pulled from the database

Question

How to find out the value of a select that is pulled from the database

Navigation

#1 by (0 votes)

0

I am putting together a plan table TABLE , where the" JOIN THE PLANE "button changes the link according to the options chosen in the select.

Two of the 4 select the user should select, are STATUS and CITY, these, not written in the select option and yes they are pulled from a database.

So, in order for the joins button to switch from link to selected options, you need to know the value of each select option, which is pulled from the database.

So I would like to know if it is possible to find the value of a select that is pulled from the database, or if there is any other way to mention the city, or state other than by value, which in this case does not exist.

Thank you.

   jQuery(function($){
        $('#volume, #tipo, #estados').change(function(){
        var volume = $('#volume').val();
        var tipo = $('#tipo').val();
        var estados = $(this).val();

            if (volume == "peq" && tipo == "visitas_quatro" && estados == "SP") {
          $('.Linkbotao').attr('href', 'site.com');

php javascript html

asked by anonymous 24.05.2017 / 19:43

1 answer

List getting whole page of android Average time in seconds

score 0 · Answer 1

It's possible, yes. can do so

$(function(){

    // Pais
    function pais(){
        $.ajax({
            type: 'GET',
            url: 'funcoes.php',
            data: {
                acao: 'pais'
            },
            dataType: 'json',
            success: function(data){
                console.log(data);

                for(i = 0; i < data.qtd; i++){

                    $('select[name=pais]').append('<option value="'+data.id[i]+'">'+data.pais[i]+'</option>');
                }
            }
        });
    }
    pais();

    // Estado
    function estado(pais){
        $.ajax({
            type: 'GET',
            url: 'funcoes.php',
            data: {
                acao: 'estado',
                id: pais
            },
            dataType: 'json',
            beforeSend: function(){
                $('select[name=estado]').html('<option>Carregando...</option>');
            },
            success: function(data){
                $('select[name=estado]').html('');
                $('select[name=estado]').append('<option>Selecione o estado</option>');
                for(i = 0; i < data.qtd; i++){
                    $('select[name=estado]').append('<option value="'+data.id[i]+'">'+data.estado[i]+'</option>');
                }
            }
        });
    }


    // Cidade
    function cidade(estado){
        $.ajax({
            type: 'GET',
            url: 'funcoes.php',
            data: {
                acao: 'cidade',
                id: estado
            },
            dataType: 'json',
            beforeSend: function(){
                $('select[name=cidade]').html('<option>Carregando...</option>');
            },
            success: function(data){
                $('select[name=cidade]').html('');
                $('select[name=cidade]').append('<option>Selecione a cidade</option>');
                for(i = 0; i < data.qtd; i++){
                    $('select[name=cidade]').append('<option value="'+data.id[i]+'">'+data.cidade[i]+'</option>');
                }
            }
        });
    }

    function verificar(volume, tipo, estados, cidades){
        if(volume == "peq" && tipo == "visitas_quatro" && estados == "?" && cidades == "?"){
            $('.Linkbotao').attr('href', 'google.com');
        }
    }


    $('select[name=pais]').change(function(){
        $('select[name=cidade]').val($("select[name=cidade] option:first-child").val());
        var id = $(this).val();
        estado(id);
    });

    $('select[name=estado]').change(function(){
        var idEstado = $(this).val();
        var cidade = $("select[name=cidade] option:first-child").val();
        var estado = $("select[name=estado] option:first-child").val();
        var tipo = $("select[name=cidade] option:first-child").val();
        var volume = $("select[name=estado] option:first-child").val();

        verificar(volume, tipo, estado, cidade)

        cidade(idEstado);
    });


});