this shouldnt be this difficult???

Anon

I am trying to delete images out of a folder using its name stored in the database but i cant seem to get it working, it either tells me that the file or directory doesn't exist or that the image_name hasnt been defined. The directory path is correct, i am running this locally php/mysql apache. Do folder access priviledges (chmod 777) apply in a local environment? I have tried passing the image_name along with the id to the delete function but it seems to make little difference.

Can anyone help me with this please....thanks in advance

echo "<a href=\"$PHP_SELF?id=$myrow[id]&delete=yes\">DELETE</a></td></tr>";

if ($delete) {

$dirs="/files/catagories/images/";
unlink($dirs.$image_name);
$sql = "DELETE FROM general WHERE id=$id";
$result = mysql_query($sql);

Anon

Additionally i am using php 4.1.1 on Windows NT 5.1, if that makes any difference....thanks

mistcat

well on the UNIX side of things, the file has to be deleteable by the effective user PHP is running at (normally the apache user) who normally can't edit or delete files. You have to set up the directory permissions for that user on the system.

From your code snipet its not clear where $image_name WOULD get defined from. Are you sure its set to something? Maybe throw some echo's in your code to check out what vars are set where?

(damn PHP needs a half decent debugger...)

Anyhow I know this is pretty general, but maybe post with some more information about what variables are set correctly and what not...

Anon

well what is happening is that i am displaying an image, description, price etc an then options to delete or edit (this is for the client to change info at will). The delete call uses the primary key id to delete the info in the db and hopefully the image_name to delete the image from the folder.It has been suggested that i do this.....

<?php
echo
"<a href=\"$PHP_SELF?".id=$myrowid]."&image_name=".$myrow[image_name]."&delete=yes\">DELETE</a>";

if($deleted=="yes"){

$dirs="/files/catagory/images/";
unlink($dirs.$image_name);
$sql = "DELETE FROM general WHERE id=$id";
$result = mysql_query($sql);
}
?>

but i cant get this to work either....ARRGGHH

mistcat

just to run through the standard areas here maybe do something like this to see whats going on:

<?php
echo
"<a href=\"$PHP_SELF?".id=$myrowid]."image_name=".urlencode($myrow[image_name])."&delete=yes\">DELETE</a>";

echo $image_name . "<BR>";

if($deleted=="yes"){

$dirs="/files/catagory/images/";
echo $dirs . $image_name . "<BR>";
unlink($dirs.$image_name);
$sql = "DELETE FROM general WHERE id=$id";
$result = mysql_query($sql);
}
?>

do the resulting lines make sense? I.E. if you were to open up a dos window, navigate to /files/catagory/images/ would you see the image you want to delete? Is the name getting translated properly?

Anon

Well it certainly doesnt like this line....

<a href=\"$PHP_SELF?".id=$myrow[id]."image_name=".urlencode($myrow[image_name])."&delete=yes\">DELETE</a>;

is it expecting a "'; or something like that kind of error message but i dont understand where it could want any of those....this coding businees is rather annoying, i appreciate your help

Anon

Well it certainly doesnt like this line....

<a href=\"$PHP_SELF?".id=$myrow[id]."image_name=".urlencode($myrow[image_name])."&delete=yes\">DELETE</a>;

is it expecting a "'; or something like that kind of error message but i dont understand where it could want any of those....this coding businees is rather annoying, i appreciate your help

Anon

thank god for that...