Ir para conteúdo

Arquivado

Este tópico foi arquivado e está fechado para novas respostas.

raPPa

Link ancora em menu dropdown (Materialize)

Recommended Posts

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>

 

Compartilhar este post


Link para o post
Compartilhar em outros sites

  • Conteúdo Similar

    • Por djwagnersp
      Boa noite amigos, tudo bem?
      Estou montando um site com materialize, inseri um carousel-slider porem ele nao da autoplay, alguem sabe me dizer qual o problema?
       
      segue meu codigo para detalhar
       
      <!DOCTYPE html> <html lang="pt-BR"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1.0" /> <title>Lab Ingressos - Sua Melhor Experiência em Entretenimento</title> <!-- CSS --> <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet"> <link href="css/materialize.css" type="text/css" rel="stylesheet" media="screen,projection" /> <link href="css/style.css" type="text/css" rel="stylesheet" media="screen,projection" /> <script src="https://unpkg.com/ionicons@5.0.0/dist/ionicons.js"></script> </head> <body class="grey lighten-4"> <?php include_once 'inc/menu_nav.php';?> <div class="tabs-content carousel carousel-slider"> <a class="carousel-item" href="#one!"><img src="img/img1.jpg"></a> <a class="carousel-item" href="#two!"><img src="img/logo_LAB_full.png"></a> <a class="carousel-item" href="#three!"><img src="img/img2.jpg"></a> </div> (function ($) { $(function () { $(".sidenav").sidenav(); $('.carousel.carousel-slider').carousel({ fullWidth: true, duration: 200, }); $(".collapsible").collapsible(); $("#textarea1").val(""); M.textareaAutoResize($("#textarea1")); $(document).ready(function () { $("select").formSelect(); }); }); // end of document ready\ })(jQuery); // end of jQuery name space  
    • Por opl12
      Podem me ajudar?
      Preciso colocar um menu "DropDown" na "Nav Bar"... mas tô me quebrando hahahaha
      o que estou fazendo de errado?
      <!DOCTYPE html> <html lang="pt-br"> <head> <!-- Última versão CSS compilada e minificada --> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous"> <!-- Tema opcional --> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous"> <!-- Última versão JavaScript compilada e minificada --> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"> <title>::: TESTE :::</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <style> .dropdown { position: relative; display: inline-block; } .dropdown-content { display: none; position: absolute; background-color: #f9f9f9; min-width: 160px; box-shadow: 0px 8px 16px 0px rgba(0,0,0,0.2); padding: 12px 16px; z-index: 1; } .dropdown:hover .dropdown-content { display: block; } </style> </head> <body> <nav class="navbar navbar-default"> <div class="container-fluid"> <div class="navbar-header"> <!--<img width="80px" height="30" src="#" title="seu texto" vspace="10px"/>--> </div> <ul class="nav navbar-nav"> <li class="nav-item"><a class="nav-link" href="#" target="a_blank">HOME</a></li> <li class="nav-link"><a href="#" target="a_blank">LINK A</a></li> <li class="nav-link"><a href="#" target="a_blank">LINK B</a></li> <li class="nav-link"><a href="#">LINK C</a></li> <li><a href="#">LINK D</a></li> <li><a href="#">LINK E</a></li> <li><a href="#">LINK F</a></li> <li><a href="#" target="a_blank">LINK G</a></li> <div class="dropdown"> <div class="dropdown-content" id="myDropdown"> <a href="#">Link 1</a> <a href="#">Link 2</a> <a href="#">Link 3</a> </div> </div> </ul> <ul class="nav navbar-nav navbar-right"> <li><a href="#"><span class="glyphicon glyphicon-user" aria-hidden="true"></span> User</a></li> <li><a href="#"><span class="glyphicon glyphicon-off" aria-hidden="true" <img title="Deslogar"/> </span>Sair</a></li> </ul> </div> </nav> </body> </html>  
    • Por 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>  
    • Por 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>  
    • Por 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!
       
×

Informação importante

Ao usar o fórum, você concorda com nossos Termos e condições.