Untitled

<?php

// Sessão se está activa ou não

require('ligacoes/sessao.php');

// Ligar base de dados

require('ligacoes/ligacao.php');

// Eliminar ficheiros


	if(isset($_REQUEST['delete_id']))
	{
		// select image from db to delete
		$id=$_REQUEST['delete_id'];	//get delete_id and store in $id variable

		$select_stmt= $db->prepare('SELECT * FROM bairro WHERE id =:id');	//sql select query
		$select_stmt->bindParam(':id',$id);
		$select_stmt->execute();
		$row=$select_stmt->fetch(PDO::FETCH_ASSOC);
		unlink("upload/bairro/".$row['image']); //unlink function permanently remove your file

		//delete an orignal record from db
		$delete_stmt = $db->prepare('DELETE FROM bairro WHERE id =:id');
		$delete_stmt->bindParam(':id',$id);
		$delete_stmt->execute();

		header("Location:admin_bairro");
    }

    if(isset($_REQUEST['delete_id2']))
	{
		// select image from db to delete
		$id=$_REQUEST['delete_id2'];	//get delete_id and store in $id variable

		$select_stmt= $db->prepare('SELECT * FROM bairro_galeria WHERE id =:id');	//sql select query
		$select_stmt->bindParam(':id',$id);
		$select_stmt->execute();
		$row=$select_stmt->fetch(PDO::FETCH_ASSOC);
		unlink("upload/bairro_galeria/".$row['image']); //unlink function permanently remove your file

		//delete an orignal record from db
		$delete_stmt = $db->prepare('DELETE FROM bairro_galeria WHERE id =:id');
		$delete_stmt->bindParam(':id',$id);
		$delete_stmt->execute();

		header("Location:admin_bairro");
    }


?>
<!DOCTYPE html>
<html>
<head>
<?php
    require('head.php');
?>
</head>

<body>

<!--Menus-->
<?php
    require('menu_admin/menu4.php');
?>
<!--Imagem Menu-->
<div id="fadein1">
    <div id="menu_imagem">
        <img src="imagens/urgeirica.png">
    </div>
<p class="titulo_urgeirica">Bairro Mineiro</p>
</div>
<!--Museu-->
<div class="container" id="fadein2">
    <br>
    <br>
    <a href="admin_bairro_adicionar" class="btn btn-success custom-btn">Nova Publicação</a>
    <br>
    <br>
    <?php
        $select_stmt=$db->prepare("SELECT * FROM bairro ORDER BY id DESC;");	//sql select query
        $select_stmt->execute();
        while($row=$select_stmt->fetch(PDO::FETCH_ASSOC))
        {
        ?>
        <br>
        <div class="row">
            <div class="col-lg-12">
                <div id="texto_urgeirica">
                    <a class="fancybox" href="upload/bairro/<?php echo $row['image']; ?>" data-fancybox-group="gallery"><img src="upload/bairro/<?php echo $row['image']; ?>" id="imagem_espe" class="imagem img-fluid"></a>
                    <div class="col-sm-12 texto_paginas" id="titulo_mineiros"><?php echo $row['titulo'];?> </div><br><?php echo $row['texto'];?>
                </div>
            </div>
        </div>
        <br>
        <div class="row">
            <div class="col-sm-6" align="right"><a href="admin_bairro_editar?update_id=<?php echo $row['id']; ?>" class="btn btn-warning custom-btn" >Editar</a></div>
                <div class="col-sm-6" ><a href="#exampleModal" class="btn btn-danger custom-btn" data-toggle="modal">Eliminar</a>
                    <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
                    <div class="modal-dialog" role="document">
                        <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title" id="exampleModalLabel">Pretende mesmo eliminar?</h5>
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-warning custom-btn" data-dismiss="modal">Cancelar</button>
                            <a href="?delete_id=<?php echo $row['id']; ?>" class="btn btn-danger custom-btn" >Eliminar</a>
                        </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <a class="linha_paginas"></a>
        <br>
        <br>
    <?php
        }
    ?>
</div>
</body>
</html>