0

I am able to delete the file from the database but not the file found on a folder associated with it...is there somethign wrong?

<?php
include("../includes/mysqliconnect.php");
include("../includes/config.php");
if(isset($_GET['delpost'])){ 



    $delpho = $mysqli->query("SELECT * FROM photos where imageID=$imageID");
    $run=mysqli_fetch_array($delpho);
                    $imageName=$run['imageName'];

                    $dir = '/uploads'; 

                    unlink($dir.'/'.$imageName);

    $stmt = $db->prepare('DELETE FROM photos WHERE imageID = :imageID');
    $stmt->execute(array(':imageID' => $_GET['delpost']));

    header('Location: index.php');
}    
?>
<html>
<head>
    <title>Album Gallery</title>
    <script src="js/jquery-1.11.0.min.js"></script>
    <script src="js/lightbox.min.js"></script>
    <link href="css/lightbox.css" rel="stylesheet" />
    <link rel='stylesheet' href='style.css'>
    <link href="/sics/css/bootstrap.css" rel="stylesheet">
    <link href="/sics/css/simple-sidebar.css" rel="stylesheet">
    <link rel="stylesheet" href="/sics/css/bootflat.css">
    <link rel="stylesheet" type="text/css" href="/sics/css/MainPanel.css">
    <script language="JavaScript" type="text/javascript">

      /*The javascript confirm function, once confirmed a command window.location.href is ran which will redirect the page, 
      in this case it goes to viewpost.php again but appends ?delpost= and the id of the post to be deleted, 
      which in turn will execute a php function.*/

        function delpost(id, title)
             {
                if (confirm("Are you sure you want to delete '" + title + "' photo?"))
                {
                    window.location.href = 'view.php?delpost=' + id;
                }
             }
      </script>
   </head>
<body>
<div id='body'>
    <?php include('title_bar.php');
    include('../includes/navbar.php');?>

    <div id='container'>

        <?php

            $album_id= $_GET['id'];
            $query = $mysqli->query("SELECT url, imageID FROM photos where albumid=$album_id");
            while ($run=mysqli_fetch_array($query)) {

                $url=$run['url'];
                $imageID=$run['imageID'];   


        ?>

        <div id='view_box'>
            <a href='uploads/<?php echo $url; ?>' data-lightbox="image">  
            <br>
            <img src='uploads/<?php echo $url; ?>'></a>

            <p class="text-center"><a href="javascript:delpost('<?php echo $imageID;?>','<?php echo $url;?>')">Delete</a></p>



        </div>

        <?php
            }
        ?>
        <div class='clear'></div>
    </div>
    <a href="index.php"><button class="btn btn-primary">Back</button></a>


</div>
<!--FOOTER -->


    <!-- Bootstrap core JavaScript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
    <script src="../js/bootstrap.min.js"></script>

    <!-- Bootflat js files -->
    <!-- Bootflat's JS files.-->
    <script src="../js/icheck.min.js"></script>
    <script src="../js/jquery.fs.selecter.min.js"></script>
    <script src="../js/jquery.fs.stepper.min.js"></script>
</body>
</html>
2
Contributors
1
Reply
18
Views
2 Years
Discussion Span
Last Post by mark.suner
0

This is also my problem last week then I found this realpath function in php

$realpath = realpath('/xampp/htdocs/directoryName/images/uploads');
unlink($realpath.'/'.$imageName);

hope this help

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.