Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //criei a query = $consulta
- $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";
- //prepara a query
- $con = $connection->prepare($consulta);
- //executar o comando sql
- $denuncia = $con->execute();
- //juntar todos os resultados do select em um vetor de arrays
- $denuncia = $con->fetchAll();
- <select select="required" class="form-control" name="id_denuncia_oque" id="sel1" required="required" >
- <option value="" disabled selected>Ex: Laboratório</option>
- <?php foreach ( $denuncia as $den ) { ?>
- <option value="<?$deno["id_denuncia_oque"]; ?>"> <?php echo $den["oque_descricao"]; ?></option>
- <?php }?>
- </select>
- </div>
Add Comment
Please, Sign In to add comment