boa noite senhores, gostaria de saber como realizar uma consulta em uma tabela mysql com o resultado de um value do combobox selecionado.
segue o exemplo teste.php que não estar funcionando.
<script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
<div class="col-md-4">
<div class="form-group">
<select id="cb_catinsumo" class="form-control select_ticket" name="teste">
<option value="0">zero</option>
<option value="1">um</option>
<option value="2">dois</option>
<option value="3">três</option>
<option value="4">quatro</option>
<option value="5">cinco</option>
<option value="6">seis</option>
<option value="7">sete</option>
<option value="8">oito</option>
<option value="9">nove</option>
<option value="10">dez</option>
</select>
</div>
</div>
// captura o value do select:option via jquery
<?php $id = '<span id="res"></span>';?>
<h3 align="center"><strong>RELAÇÃO</strong></h3>
<div class="table-responsive">
<table id="example" class="table table-bordered">
<thead>
<tr>
<th scope="col" data-sortable="false">#</th>
<th scope="col" data-sortable="false">Descrição</th>
<th scope="col" data-sortable="false">Ação</th>
</tr>
</thead>
<tbody>
<?php
$select = $pdo->query("select *from tabela2 where id = {$id}"); // id capturado do select via jquery
$result = $select->fetchAll();
foreach($result as $rows)
{
echo '<tr>';
echo '<td align="center">''</td>';
echo '<td>'. $rows['descricao'] .'</td>';
echo '<td align="center">';
echo '<a class="btn btn-warning btn-xs" href="?option=edit"><i class="glyphicon glyphicon-pencil"></i></a>';
echo '</tr>';
}
?>
</tbody>
</table>
<a class="btn btn-primary" href="?option=home"><i class="glyphicon glyphicon-home"> Voltar</i></a>
</div>
<script type="text/javascript">
$(document).ready( function ()
{
$("#cb_catinsumo").on('change', function() {
var option = $(this).find('option:selected').val();
//$('#res').html("select *from tabela where id = "+option);
$('#res').html(option);
});
});
</script>
