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
Source: Tips4all
unlink remove files whereas unset is for variables.
ReplyDeleteIf the variable returns empty, perhaps the query does not return any records. Did you try to run the query manually?
$query = mysql_query("SELECT avatar FROM users WHERE UserID = ".$userID."");
ReplyDelete$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
}