Guest User

Untitled

a guest
Oct 19th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. //criei a query = $consulta
  2. $consulta = "SELECT denuncia.id, data, imagem ,denuncia.descricao, b.descricao as bloco_descricao, doq.descricao as oque_descricao, id_bloco, id_denuncia_oque, qual_descricao, u.matricula, nome, sobrenome FROM denuncia INNER JOIN usuario u ON u.id = denuncia.id_usuario INNER JOIN bloco b ON b.id = denuncia.id_bloco INNER JOIN denuncia_oque doq ON doq.id = denuncia.id_denuncia_oque";
  3. //prepara a query
  4. $con = $connection->prepare($consulta);
  5. //executar o comando sql
  6. $denuncia = $con->execute();
  7. //juntar todos os resultados do select em um vetor de arrays
  8. $denuncia = $con->fetchAll();
  9.  
  10. <select select="required" class="form-control" name="id_denuncia_oque" id="sel1" required="required" >
  11. <option value="" disabled selected>Ex: Laboratório</option>
  12. <?php foreach ( $denuncia as $den ) { ?>
  13. <option value="<?$deno["id_denuncia_oque"]; ?>"> <?php echo $den["oque_descricao"]; ?></option>
  14. <?php }?>
  15. </select>
  16. </div>
Add Comment
Please, Sign In to add comment