[Resolved] unlink.. deleting a file in a different directory

abda53

im trying to delete a picture after i hit delete. it also deletes the database entry. i got the database entry fine, but when it tries to delete the actual file, i get this error.

Warning: Division by zero in /admin.delete.php on line 20

Warning: unlink(jpg): No such file or directory in /admin.delete.php on line 20

Warning: Cannot modify header information - headers already sent by (output started at /admin.delete.php:20) in /admin.delete.php on line 22

the php files are in one directory.. and the images are in a folder called "hosted" right under that. my database is set where the file name is "image_name" and the extension is "image_ext"..

im not sure how to use unlink where i can add the name.ext in it
heres what i have now. i know its messed up..

if($mode == "delete") {
$date = now();
$sql = "DELETE from image where image_id = '$image_id' and image_status='D'";
$result = mysql_query($sql);
$sqldel = unlink(hosted/'$image_name'.'$image_ext'); ///not sure how to add a directory in here, or if im adding the name.ext correctly..
$result = mysql_query($sqldel);
header("location: admin.delete.php");
}
?>

drew010

try
$sqldel = unlink("hosted/" . $image_name . $image_ext);

also, dont know why you are running that command thru mysql_query. its not sql so it will return an error.

abda53

im still learning..

how would you recommend doing it?

i tried this..

if($mode == "delete") {
$date = now();
$sql = "DELETE from image where image_id = '$image_id' and image_status='D'";
$sqldel = unlink("hosted/" . $image_name . $image_ext);
$result = mysql_query($sqldel) or die(mysql_error());
$result = mysql_query($sql);

header("location: admin.delete.php");
}
?>

and i got this error
Warning: unlink(hosted/): Is a directory in /admin.delete.php on line 19
Query was empty

need some assistance on a better way to do this. im calling the delete functions from this..
<a href="javascript:jp_delete('<?php print($data->image_id); ?>');">remove</a>

drew010

well, the reason unlink didnt work is because the variables in it arent filled...i dont know where you are getting image_name and image_ext from. also, you dont need to run that thru mysql because its not doing anything to the database..only the first thing needs to be run thru mysql_query.

abda53

well the image_name and image_ext is the part of my database that holds the file name..

see i have the delete link
<a href="javascript:jp_delete('<?php print($data->image_id); ?>');">remove</a>
and that sends the command the query which will delete the database entry, and will delete the image from the server. the only way i could think of while doing both was how i did it. im still learning so obviously i guess i didnt think right.. and im in need of some help here. ive tried reading up on the unlink command but i havent seen anywhere that uses it to delete a image where the name is being pulled from a database..

any ideas? thanks ahead

drew010

not knowing the exact look of your code, im guessing something along the lines of what i am showing below is gonna give you some direction on how to do this.

<?php
if($mode == "delete") {
    $query = "SELECT image_name, image_ext FROM image WHERE image_id = '$image_id'";
    //Retrieve the image name and its extension from database.

$result = mysql_query($query); // run the query
$data = mysql_fetch_array($result); // get results into $data

$query = "DELETE FROM image WHERE image_id = '$image_id' AND image_status = 'D'";
// Delete the image info from the database
$result = mysql_query($query); //run the query

unlink("hosted/" . $data[image_name] . $data[image_ext]);
// delete the file, concats to "hosted/name.ext"

header("Location: admin.delete.php");
//forward to admin.delete.php
}
//...
?>

abda53

thank you!!

i got this error with your script..
Warning: unlink(hosted/pikvd413deu7b3oflfuo5dmsmuat20swjpg): No such file or directory in /home/upixs/public_html/admin.delete.php on line 26

so i had to change it to

unlink("hosted/" . $data[image_name] . "." . $data[image_ext]);

but thank you so much for the help. now i just gotta figure out exactly how you did that so i can get smartered 😉