Personal I have the following page, which works as follows: The user types the name of the city, clicks the search button where it brings the results matching the search in a table. When clicking on the table, choosing the desired result, pops up with the name of the city and its id in the database, also cleaning the page.
What I need to do is instead of opening this popup, the page being updated, bringing the contents of the database according to a query using the id retrieved in the click, and displaying on the same page an html displaying a link and an image (these being brought in the SLQ query using the ID obtained in the click).
I'm totally lay in Js, so I did not get a solution to the problem ...
<?php include_once 'conexao.php'
?>
<html>
<head>
<title>INDEX Foruns Regionais</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script><scripttext="text/javascript">
function mostraConteudo(elemento) {
esconde();
var id = elemento.dataset.id;
var nome = elemento.innerHTML;
mostraResultado(id,nome)
}
function mostraResultado(id, nome){
alert('Código: '+id+'\nCidade: ' +nome);
}
function esconde() {
$('.table td').hide();
}
$(document).ready(function(){
$("p").click(function(){
$(this).fadeOut();
});
});
</script>
</head>
<body>
<h1>Pesquisa cidade</h1>
<form onclick="" name="formulario_busca" method="post"/>
<input type="text" name="nome_cidade"/>
<input type="submit" name="busca"/>
</form>
<?php
$busca = $_POST['nome_cidade'];
$query = "SELECT id,cidade FROM cidades WHERE cidade LIKE '%".$busca."%'";
$resultado = mysqli_query($conexao, $query);
mysqli_fetch_array($resultado,$lista_Cidades);
?>
<table class="table table-striped table-bordered">
<?php
if ((mysqli_num_rows($resultado)>0) && ($busca != "") ):
while ($linha = mysqli_fetch_assoc($resultado)) {
?>
<tr>
<td data-id="<?= $linha['id']?>" onclick="mostraConteudo(this)"><?= $linha['cidade']?></td>
</tr>
<?php
} echo "<br/>";
endif; if(mysqli_num_rows($resultado)<=0):
echo "Cidade não encontrada";
endif;
?>
</table>
</body>
</html>