delete files

hmgroen

Hello,

I'm using 'is_uploaded_file' and 'move_uploaded_file' for uploading files to my HD.
But I realy don't know how to delete them in my delete command.

ir4z0r

either use unlink()

btw. temporary files don't need to be deleted when not copied
to a folder
they will be deleted automatically when the script stops

hmgroen

Yes i'm using unlink() , and I know they wild be deleted automaticly.
Sorry It's my fauld. I've asked my question the wrong way.
I just want to delete files i've downloaded one day.

I've tried it with unlink() but that gives me an error:

Warning: unlink() failed (Permission denied)

I've put all permission to MySQl but he doesn't mind.

What does it mean that warrning exactly?

ir4z0r

mysql? the apache user needs the perms
if you have uploaded the files via a php-script, run a chmod()
on the file you wish to delete (at least 400)

possibly the directory which contains the file, doesn't allow
writing by the Apache user, change it

hmgroen

Excuse me but what is chmod() mode and how can I excecute it on a file?

ir4z0r

chmod is a UNIX/Linux command to change a file's/dir's permissions, it exists for php, too

permissions consist of 3 fields: ugo
u = user, the owner
g = group, users of the same group
o = other, anybody else

their values are:
4 = read
2 = write
1 = execute
to combine values, just add them, ie write and read: 6

the mode has to be set as octal, meaning you have to use sth
like this:
chmod("myfile","0" . octdec(600));

hmgroen

Hi again,

I've try the unlink command with giving him all the link. It's working.
(I'm working with W2K, probebly I don't need the CHMOD() mode (I've tried)).

But I wanted to used it in a script with a variable in it, but probebly he doesn't like it.

unlink('c:\easyphp\www\audio\'."$id_titre".".wav");

Do you see a sulution?

ir4z0r

unlink("c:\easyphp\www\audio\" . $id_titre . ".wav");

but what does it say? did you print the variable?

hmgroen

The error is like

Parse error: parse error, unexpected $

Probely he doesn't like the variable in the syntax, no?

hmgroen

Sorry,

The variable is the filename which I take out of my db.

ir4z0r

please post some code, where the var gets its value and so on.
the parse error is not connected to unlink() itself

hmgroen

Here's a part of the code:

$id_titre=$row["id_titre"];
$chemin=$row["chemin"];
$id_genre=$row["id_genre"];
$id_desription=$row["id_description"];
$id_album=$row["id_album"];
$id_auteur=$row["id_auteur"];

// maintenant on va supprimer les donnees de la selection des differente tables



// dans la tablegenre

$sql = "DELETE FROM tablegenre WHERE tablegenre.id_genre='$id_genre'";
mysql_query($sql)or die('Erreur SQL !'.$sql.'<br>'.mysql_error());

// dans la tabledescription

$sql = "DELETE FROM tabledescription WHERE tabledescription.id_description='$id_description'";
mysql_query($sql)or die('Erreur SQL !'.$sql.'<br>'.mysql_error());

// dans tablealbum

$sql = "DELETE FROM tablealbum WHERE tablealbum.id_album='$id_album'";
mysql_query($sql)or die('Erreur SQL !'.$sql.'<br>'.mysql_error());

// dans tableauteur

$sql = "DELETE FROM tableauteur WHERE tableauteur.id_auteur='$id_auteur'";
mysql_query($sql)or die('Erreur SQL !'.$sql.'<br>'.mysql_error());

// dans la tabletitre

$sql = "DELETE FROM tabletitre WHERE tabletitre.id_titre='$id_titre'";
mysql_query($sql)or die('Erreur SQL !'.$sql.'<br>'.mysql_error());

echo "$id_titre";


unlink('\EasyPHP\www\audio\'."$id_titre".".wav");

}

mysql_close(); // on ferme la connexion

I've try a echo "$id_titre"; before the unlink but I even haven't a echo of this.

ir4z0r

j'aime les commentaires francaises, mais je parle francais tres mal 😃

so echo doesn't display anything? (don't use " around variables)
echo $id_titre;

are the entries removed from the tables?

if $id_titre only contains the filename itself, append a \ behind "audio":
unlink('\EasyPHP\www\audio\'."$id_titre".".wav");

please post your "main" query, too which returns the ids
and tell me the line in which ther parse error occurs