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>
