Deleting Files

SeanKann

I have a drop.php file that deletes info from my 2 tables and works fine.

But I need it to delete the files that are with $table 2

I've done some testing and I keep getting the same error everytime can't find the file name.


<?
include('connection.php');

if (isset($_GET['drop'])){
        $drop = $_GET['drop'];
} else {
        $drop = 'id';
}

$query = "DELETE $table, $table2 FROM $table LEFT JOIN $table2 ON $table.id = $table2.loc_id WHERE $table.id = $drop";

#$result = mysql_query($query);

$pic_dir = "/var/www/goodlife/pictures/";
$filename = "$table2.url_file = $drop";
$dirpic = $picdir.$filename;

unlink($dirpic);

$result = mysql_query($query);

echo "Removed Location from Database";

mysql_close();
?>

I know my code for unlink is wrong. As I've just been trying different things and seeing if I can get it to work.

In table2 have the colums id url_filename and loc_id.

url_filename works with another file that uploads pictures. it shows the url of the file that is being uploaded so that I can do a img src where all the loc_id = $value.

But I want to be able to delete the files related to the drop so they don't use up space on my server.

My add_pics.php file adds a timestamp to each file so that I don't get the same files uploaded thats why I want to have it delete the files related to the drop.

Any ideas? Thoughts?

TIA

Sean

bradgrafelman

This:

$filename = "$table2.url_file = $drop";

doesn't make any sense. Where is $table2 defined? Also, does the file name actually contain the text ".url_file = "?

SeanKann

$table2 is defined in my connection.php.

When I posted this question I was trying a couple different values to delete files to see if I could get it to work.

I actually noticed that I made a mistake with my query where I had url_file. When I have my add_pics.php it would send a value to the database for the exact url on the website not on the server. So I quickly made a change and put in a pic_file for the file name. So that it would put the filename into the database. example image.png into the row.

So I tried


$pic_dir = "/var/www/goodlife/pictures/";
$filename= "$drop$file_pic"l
$dirpic = $pic_dir.$filename

unlink($pic_dir.$filename);

And still couldn't get it to work.

This is the first time that I have worked with deleting files. So I'm a little confused on how to get it to work 100%. I keep googling different options to see what I can come up with, but nothing. Also tried searching here.

bradgrafelman

From what I can see, your problem doesn't have anything to do with deleting files or "options" .. it's simply getting the file path correct.

[man]echo[/man] out the various variables you're using when building the file path so you know what values they contain.

If you still can't get it, show us the result of echo'ing those variables out so we know the values of the variables you're using.

SeanKann

'/var/www/goodlife/pictures/'filename = 'file_pic'Removed Location from Database

So from what I can see it's getting the directory just not the file name. So I have to figure that out.

Also I uploaded a picture as well from my database from php

I took out the data for the url_filename

So there is 2 rows that have the same ID I want those actual files on the server to be deleted.

Hope this makes more sense.