PHP unlink function

1.6k Views Asked by At

This is the code

  $query = mysql_query("SELECT avatar FROM users WHERE UserID = ".$userID.""); 
        $row = mysql_fetch_array($query);
        $user_avatar = trim($row['avatar']);
unlink($user_avatar);

but for some reason i get this error Warning:unlink();

why $user_avatar returns empty ? and if i echo it shows t_cabbbccebbfhdb.jpg

3

There are 3 best solutions below

1
On

unlink remove files whereas unset is for variables.

If the variable returns empty, perhaps the query does not return any records. Did you try to run the query manually?

5
On
$query = mysql_query("SELECT avatar FROM users WHERE UserID = ".$userID.""); 
        $row = mysql_fetch_array($query);
        $user_avatar = trim($row['avatar']);
unset($user_avatar);

//if you want to unlink file then

if(!empty($user_avatar)) {    
    unlink($home.$user_avatar); // $yourFile should have full path to your file
} 
0
On

In PHP unlink is used to delete a file, make sure you are giving right path. see here for details http://se.php.net/unlink

try unset for variables. http://se.php.net/manual/en/function.unset.php