Jump to content
padini

Cria caixa de pesquisa cidade estado gerando resultado na própria página

Recommended Posts

Boa noite pessoal, estou com problemas em criar um menu dropdown onde as opções deem um resultado final na própria página. 

 

Exemplo: 

Caixa 1 - Estados 

Caixa 2 - cidades 

Resultado em texto abaixo: Lojas daquela cidade e estado e caso não houver nenhuma loja, o resultado seria uma mensagem padrão. 

 

é como este: https://www.unimed.coop.br/servicos/segunda-via-de-boletos Porem esse gera um terceiro dropdown e depois uma página externa. 

 

Já consegui gerar o banco de dados para que cidade e estados estejam interligados, porem não consigo fazer aparecer o resultado. 

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By vanessaaaaaaa
      Tenho um codigo html com JavaScript com um dropDown para estado que exibe a cidade de acordo com esse estado e depois mostra um endereço, a cada seleção ele empurra a div que esta em baixo mais para baixo.
      <div class="fisico " > <select id="test" name="form_select" onchange="mostrarCidade(this)" style="width: 200px; text-align: center; text-align-last: center;"> <option value="0">Estados</option> <option value="1">Rio de Janeiro</option> <option value="2">Espirito Santo</option> <option value="3">Minas Gerais</option> </select> <div id="cidadeRio" style="display:none;" style="position:relative;" > <select id="rio" name="form_rio" onchange="mostrarEndereco(this)" style="width: 200px;text-align: center; text-align-last: center;" > <option value="0">Cidade</option> <option value="1">ITAPERUNA</option> <option value="2">CAMPOS DOS GOYTACAZES</option> <option value="3">RIO DAS OSTRAS</option> <option value="4">MACAÉ</option> <option value="5">SAQUAREMA</option> <option value="6">MARICA</option> <option value="7">ARARUAMA</option> <option value="8">CABO FRIO</option> <option value="9">RIO BONITO</option> <option value="10">SÃO PEDRO DA ALDEIA</option> <option value="11">NOVA FRIBURGO</option> <option value="12">PETROPOLIS</option> <option value="13">TERESOPOLIS</option> </select><br> <div class="ruasRio" style="width: 200px; text-align: center; text-align-last: center;"> <div id="itaperuna" style="display:none;" >AV CARDOSO MOREIRA nº325 - Centro</div> <div id="campos"style="display:none;">AV 7 DE SETEMBRO nº492 - Centro</div> <div id="ostras"style="display:none;">AV AMARAL PEIXOTO nº4472 - BALNEARIO REMANSO</div> <div id="macae"style="display:none;">AV RUI BARBOSA nº663 - Centro</div> <div id="saquarema"style="display:none;"> RUA PROF FRANCISCO FONSECA nº350 - Bacaxa</div> <div id="marica"style="display:none;"> PC CONSELHERO MACEDO SOARES nº168 - Centro</div> <div id="araruama"style="display:none;"> RUA MAJOR FELIX MOREIRA nº107 - Centro</div> <div id="cabo"style="display:none;"> RUA TEIXEIRA E SOUZA nº31 - Centro</div> <div id="bonito"style="display:none;">RUA XV DE NOVEMBRO nº104</div> <div id="pedro"style="display:none;">RUA DR ANTONIO ALVES nº208/218 - Centro</div> <div id="friburgo"style="display:none;">AV ALBERTO BRAUNE nº64 - Centro</div> <div id="petropolis"style="display:none;">RUA DO IMPERADOR nº751 - Centro</div> <div id="teresopolis"style="display:none;">AV DELFIM MOREIRA nº610 - Centro</div> </div> </div> <div id="cidadeEs" style="display:none;" style="position:relative;"> <select id="es" name="form_es" onchange="mostrarEndereco(this)" style="width: 200px; text-align: center; text-align-last: center; "> <option value="14">Cidade</option> <option value="15">VILA VELHA</option> <option value="16">VITORIA</option> <option value="17">SERRA</option> <option value="18">CARIACICA</option> <option value="19">CACHOEIRO DE ITAPEMIRIM</option> <option value="20">GUARAPARI</option> <option value="21">SÄO MATEUS</option> <option value="22">LINHARES</option> <option value="23">ARACRUZ</option> <option value="24">COLATINA</option> <option value="25">GUACUI</option> </select><br> <div class="ruasEs" style="width: 200px; text-align: center; text-align-last: center;"> <div id="velha" style="display:none;">AV JERONIMO MONTEIRO nº74 - Centro</div> <div id="vitoria"style="display:none;">AV PRINCESA ISABEL nº426 - Centro</div> <div id="serra"style="display:none;">AV JOAO PALACIOS nº300 - Fatima</div> <div id="cariacica"style="display:none;">Rod. BR 262, KM 5 nº6555 - São Francisco</div> <div id="itapemirim"style="display:none;">RUA CEL FRANCISCO BRAGA nº71/73 - Centro</div> <div id="guarapari"style="display:none;"> RUA EWERSON DE ABREU SODRE nº1 - Muquicaba</div> <div id="mateus"style="display:none;"> RUA CEL. MATEUS CUNHA nº67 - Centro</div> <div id="linhares"style="display:none;"> AV GOV JONES SANTOS NEVES nº912 - Centro</div> <div id="aracruz"style="display:none;">AV VENANCIO FLORES nº1116 - Centro</div> <div id="colatina"style="display:none;">AV GETULIO VARGAS nº203 - Centro</div> <div id="guacui"style="display:none;"> PRACA DA BANDEIRA nº1 - Centro</div> </div> </div> <div id="cidadeMinas" style="display:none; " style="position:relative;" > <select id="minas" name="form_minas" onchange="mostrarEndereco(this)" style="width: 200px" style="height: 125px; "> <option value="26">Cidade</option> <option value="27">BELO HORIZONTE</option> <option value="28">RIBEIRAO DAS NEVES</option> <option value="29">SANTA LUZIA</option> <option value="30">CONTAGEM</option> <option value="31">BETIM</option> <option value="32">CONSELHEIRO LAFAIETE</option> <option value="33">SETE LAGOAS</option> <option value="34">BARBACENA</option> <option value="35">MONTES CLAROS</option> <option value="36">JUIZ DE FORA</option> <option value="37">DIVINOPOLIS</option> <option value="38">GOVERNADOR VALADARES</option> <option value="39">TIMOTEO</option> <option value="40">IPATINGA</option> </select><br> <div class="ruasMinas" style="width: 200px; text-align: center; text-align-last: center;"> <div id="bh" style="display:none;">RUA DOS CARIJOS nº516 - Centro</div> <div id="neves"style="display:none;">RUA RAIMUNDO NONATO DE SOUZA nº26 - Centro</div> <div id="luzia"style="display:none;">AV BRASILIA nº2165 - São Benedito</div> <div id="contagem"style="display:none;">RUA TIRADENTES nº2550 - Bairro Industrial</div> <div id="betim"style="display:none;">RODOVIA BR 381 FERNÃO DIAS KM 492,6 - São João</div> <div id="lafaiete"style="display:none;"> RUA DOUTOR MELO VIANA nº10 - Centro</div> <div id="lagoas"style="display:none;"> AV DEPUTADO EMILIO DE VASCONCELOS COSTA nº34 - Centro</div> <div id="barbacena"style="display:none;"> RUA QUINZE DE NOVEMBRO nº86 - Centro</div> <div id="claros"style="display:none;">AV DONATO QUINTINO nº90 - Canelas</div> <div id="juiz"style="display:none;">RUA MARECHAL DEODORO nº558 - Centro</div> <div id="divinopolis"style="display:none;"> RUA MOACIR JOSE LEITE nº100 - Santa Clara</div> <div id="valadares"style="display:none;"> RUA MARECHAL FLORIANO nº824 - Centro</div> <div id="timoteo"style="display:none;"> ALAMENDA 31 DE OUTUBRO nº115 - Centro Norte</div> <div id="ipatinga"style="display:none;"> AV 28 DE ABRIL nº187 - Centro</div> </div> </div> <script type="text/javascript"> function mostrarCidade(select){ if(select.value==1){ document.getElementById('cidadeRio').style.display = "block"; document.getElementById('cidadeEs').style.display = "none"; document.getElementById('cidadeMinas').style.display = "none"; } else if(select.value==2){ document.getElementById('cidadeRio').style.display = "none"; document.getElementById('cidadeEs').style.display = "block"; document.getElementById('cidadeMinas').style.display = "none"; }else if(select.value==3){ document.getElementById('cidadeRio').style.display = "none"; document.getElementById('cidadeEs').style.display = "none"; document.getElementById('cidadeMinas').style.display = "block"; }else{ document.getElementById('cidadeRio').style.display = "none"; document.getElementById('cidadeEs').style.display = "none"; document.getElementById('cidadeMinas').style.display = "none"; } } function mostrarEndereco(select){ if(select.value==1){ document.getElementById('itaperuna').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; } else if(select.value==2){ document.getElementById('campos').style.display = "block"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; }else if(select.value==3){ document.getElementById('ostras').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; }else if(select.value==4){ document.getElementById('macae').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; } else if(select.value==5){ document.getElementById('saquarema').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; } else if(select.value==6){ document.getElementById('marica').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; } else if(select.value==7){ document.getElementById('araruama').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; } else if(select.value==8){ document.getElementById('cabo').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; } else if(select.value==9){ document.getElementById('bonito').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; } else if(select.value==10){ document.getElementById('pedro').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; } else if(select.value==11){ document.getElementById('friburgo').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; } else if(select.value==12){ document.getElementById('petropolis').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; } else if(select.value==13){ document.getElementById('teresopolis').style.display = "block"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('itaperuna').style.display = "none"; }else if(select.value==15){ document.getElementById('velha').style.display = "block"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guacui').style.display = "none"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "none"; }else if(select.value==16){ document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "block"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "none"; document.getElementById('guacui').style.display = "none"; }else if(select.value==17){ document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "block"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "none"; document.getElementById('guacui').style.display = "none"; }else if(select.value==18){ document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "block"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "none"; document.getElementById('guacui').style.display = "none"; }else if(select.value==19){ document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "block"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "none"; document.getElementById('guacui').style.display = "none"; }else if(select.value==20){ document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guarapari').style.display = "block"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "none"; document.getElementById('guacui').style.display = "none"; }else if(select.value==21){ document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "block"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "none"; document.getElementById('guacui').style.display = "none"; }else if(select.value==22){ document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "block"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "none"; document.getElementById('guacui').style.display = "none"; }else if(select.value==23){ document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "block"; document.getElementById('colatina').style.display = "none"; document.getElementById('guacui').style.display = "none"; }else if(select.value==24){ document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "block"; document.getElementById('guacui').style.display = "none"; }else if(select.value==25){ document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "none"; document.getElementById('guacui').style.display = "block"; } else if(select.value==27){ document.getElementById('bh').style.display = "block"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; }else if(select.value==28){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "block"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==29){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "block"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==30){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "block"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==31){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "block"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==32){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "blok"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==33){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "block"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==34){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "block"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==35){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "block"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==36){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "block"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==37){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "block"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==38){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "block"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==39){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "block"; document.getElementById('ipatinga').style.display = "none"; } else if(select.value==40){ document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "block"; } else{ document.getElementById('itaperuna').style.display = "none"; document.getElementById('campos').style.display = "none"; document.getElementById('ostras').style.display = "none"; document.getElementById('macae').style.display = "none"; document.getElementById('saquarema').style.display = "none"; document.getElementById('marica').style.display = "none"; document.getElementById('araruama').style.display = "none"; document.getElementById('cabo').style.display = "none"; document.getElementById('bonito').style.display = "none"; document.getElementById('pedro').style.display = "none"; document.getElementById('friburgo').style.display = "none"; document.getElementById('petropolis').style.display = "none"; document.getElementById('teresopolis').style.display = "none"; document.getElementById('velha').style.display = "none"; document.getElementById('vitoria').style.display = "none"; document.getElementById('serra').style.display = "none"; document.getElementById('cariacica').style.display = "none"; document.getElementById('itapemirim').style.display = "none"; document.getElementById('guarapari').style.display = "none"; document.getElementById('mateus').style.display = "none"; document.getElementById('linhares').style.display = "none"; document.getElementById('aracruz').style.display = "none"; document.getElementById('colatina').style.display = "none"; document.getElementById('guacui').style.display = "none"; document.getElementById('bh').style.display = "none"; document.getElementById('neves').style.display = "none"; document.getElementById('luzia').style.display = "none"; document.getElementById('contagem').style.display = "none"; document.getElementById('betim').style.display = "none"; document.getElementById('lafaiete').style.display = "none"; document.getElementById('lagoas').style.display = "none"; document.getElementById('barbacena').style.display = "none"; document.getElementById('claros').style.display = "none"; document.getElementById('juiz').style.display = "none"; document.getElementById('divinopolis').style.display = "none"; document.getElementById('valadares').style.display = "none"; document.getElementById('timoteo').style.display = "none"; document.getElementById('ipatinga').style.display = "none"; } } </script> </div>  
    • By Flaviaac
      Boa tarde galera!
       
      Estou tendo um problema esquisito aqui.
      Sou iniciante e não faço a mínima ideia do que pode ser.
       
       
      Veja só, no campo dropdown abaixo coloquei no "value" o ID, mas ele salva no banco como tipo STRING e não INT.
      <?php $sql = "SELECT id, sigla FROM local ORDER BY sigla ASC"; $result = $conn->query($sql); ?> . . . <select name="local" class="form-control"> <option selected>Selecione...</option> <?php while($row = $result->fetch_assoc()){ echo "<option value=".$row['id'].">".$row['sigla']."</option>"; } ?> </select> . . . Dei um var_dump() pra saber o que apareceria e ele mostra como STRING.
      <pre> <?php $sql = "SELECT id, sigla FROM local ORDER BY sigla ASC"; $result = $conn->query($sql); $row = $result->fetch_assoc(); var_dump($row['id']); ?> </pre> Resultado:
      string(1) "5"  
       
      Esse é o Banco de dados:
      Coloquei a coluna ID como INT.
      -- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Banco de dados: `arq` -- -- -------------------------------------------------------- -- -- Estrutura para tabela `local` -- CREATE TABLE `local` ( `id` int(11) NOT NULL, `SIGLA` mediumtext NOT NULL, `LOCAL` mediumtext NOT NULL, `TELEFONE` mediumtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Fazendo dump de dados para tabela `local` -- INSERT INTO `local` (`id`, `SIGLA`, `LOCAL`, `TELEFONE`) VALUES (1, 'AAC', 'AAC', '2222-2222'), (2, 'DSV', 'DSV', '1111-1111'), (3, 'SCA', 'SCA', '3333-3333'); -- -- Índices de tabelas apagadas -- -- -- Índices de tabela `local` -- ALTER TABLE `local` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT de tabelas apagadas -- -- -- AUTO_INCREMENT de tabela `local` -- ALTER TABLE `local` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; Obrigada pessoal!
       
    • By nathicoelhoo
      Tenho um cadastro de cliente e no cadastro é selecionado o sexo e o estado, por exemplo. Na área de edição, preciso puxar esses dados JÁ SELECIONADOS para um combobox. Tentei fazer com foreach porém não funcionou. Alguém pode me ajudar?
      <div class="form-group col-md-5" > <label for="inputSexo">Sexo</label> <select name="sexo_cliente" id="sexo_cliente" class="form-control" disabled> <option selected disabled="">Sexo</option> <?php require_once "api/conexao.php"; try { $prepared3 = $conexao_pdo->prepare("select * from sexo"); $prepared3->execute(); $result3 = $prepared3->fetchAll(); foreach($result3 as $resultado3) { echo "<option value='". $resultado3["cod"] ."'>". $resultado3["sexo"] ."</option>"; } } catch (PDOException $e) { echo "<option></option>"; } ?> </select> </div>  
    • By petrochinski
      Eu tive uma ideia muito boa, mas não consegui fazer ainda.
       
      A ideia é simples, eu tenho um botão escrito 'Contato', quando passar o mouse gostaria que ele "abrisse" uma div logo abaixo (dropdown), como por exemplo aparecer o telefone somente se passar o mouse.
       
      Não achei nenhum tópico com essa ideia... é que gostaria de fazer sem utilizar nav, pois nav é o menu, e a ideia inicial é de fato ser um botão que aparece as informações quando se passa o mouse.
       
      Grato :)
    • By raPPa
      Boa tarde pessoal, estou com um problema, o link ancora não funciona no menu Dropdown do Materialize. Porém fora do dropdown funciona beleza. Alguém pode ajudar?
       
      <!-- Link sem drop down Funciona --> <a href="#teste">Link Ancora</a> <!-- Dropdown Trigger --> <a class='dropdown-trigger btn' href='#' data-target='dropdown1'>Drop Me!</a> <!-- Dropdown Structure --> <ul id='dropdown1' class='dropdown-content'> <li><a href="#teste">one</a></li> </ul> <p id="teste">teste</p>  
×

Important Information

Ao usar o fórum, você concorda com nossos Terms of Use.