[SOLVED] PHP Unlink

[steviez]

Hi,

 

I am trying to have some files deleted from my server when a user closes their account, the only thing is it wont work!

 

Here is my code so far:

 

<?php
include("../connect");
include("../header");

mysql_connect("$DBSERVER", "$USERNAME", "$PASSWORD");
mysql_select_db("$DATABASENAME","$db");

$filepath = "/home/steviez/YC9R5F01/htdocs/music4play/audio/";
$file = "SELECT FROM audio WHERE user_id = '68'";

if (! unlink ($file,$filepath)) {
   echo ("Couldn't delete file");
} else {
    echo ("Removed $file");
}
?>

 

Any ideas?

[HaLo2FrEeEk]

Your file variable is in mysql_query format, but is not inside a mysql_query() function.

[steviez]

how do i do this? im new to php

[ikmyer]

<?php
include("../connect");
include("../header");

mysql_connect("$DBSERVER", "$USERNAME", "$PASSWORD");
mysql_select_db("$DATABASENAME","$db");

// query the database for the file name first... how ever you want to do that... once you have that done continue below

$file = "/home/steviez/YC9R5F01/htdocs/music4play/audio/" . $row['filename'];


if (! unlink ($file)) {
   echo ("Couldn't delete file");
} else {
    echo ("Removed $file");
}
?>

[steviez]

I tryed the code above but i cant get it working, here is my code now:

 

<?php
include("../connect");
include("../header");

$sql = "SELECT * FROM audio WHERE user_id = '68'";
$result = mysql_query($sql) or die(mysql_error());
$filename = "$result";
$path = '/home/steviez/YC9R5F01/htdocs/xxx/audio/'.$filename;
if (!unlink($filename))
  {
  echo ("Error deleting $filename");
  }
else
  {
  echo ("Deleted $filename");
  }
?>

[ikmyer]

try

 

<?php
include("../connect");
include("../header");

$sql = "SELECT * FROM audio WHERE user_id = '68'";
$result = mysql_query($sql) or die(mysql_error());
$row_result = mysql_fetch_assoc($result);

$path = '/home/steviez/YC9R5F01/htdocs/xxx/audio/'.$row_result['fieldoffilename']; // update the field name...

if (!unlink($path))
  {
  echo ("Error deleting $path");
  }
else
  {
  echo ("Deleted $path");
  }
?>