[RESOLVED] deleting files using unlink()

[mpar612]

Hi everyone,

I have been searching the forums for examples of using unlink() and I thought I understood it, but my code is not working.

I have a form where the user can upload an image. The image is stored in a directory on my server and the path to that file is stored in a database. I have have another form that allows an admin to delete that row from the database, but I also want the actual image file deleted too.

I don't recieve any errors, but the rows get deleted from the database and images do not get deleted. I am using PHP5, MySQL and PEAR. Does anyone have any thoughts on why this is not working?

Thanks in advance!

Here is my code:

if($_SERVER['REQUEST_METHOD']=='POST') {
	if ($_POST['yes_no'] == 'yes') {
    	$isbn = $_POST['isbn'];
		$sql_select = "SELECT image FROM lounge WHERE isbn = $isbn";
		$rows = $db->getRow($sql_select);
		$uploaddir = "uploads/";
		$filename = $rows[image];
		$image = $uploaddir.$filename;
		unlink($image);

	$sql_delete = "DELETE FROM lounge WHERE isbn = $isbn";
	$db->query($sql_delete);
	print "<script>window.location='water_music_retrieve_testing.php'</script>";
} else {
	print "Record not deleted";
	print "<script>window.location='water_music_retrieve_testing.php'</script>";
}
}

[abc123]

Echo out $image to see that actual path that you are trying to delete from.

Also check out permissions for the file you are trying to delete.

I'd also try just manually creating a text file and then use unlink to delete it. If this works then the problem isn't your understanding of unlink but rather is the implementation of it.

Post back and let us know the results.

[mpar612]

Thanks! Echoing the path of the image helped me figure out what was wrong. The full path is stored in the database and I was adding an additional "uploads/" to the path. So the script was referencing a directory that did not exist. I changed that and everything works great.

Thanks again!