[RESOLVED] Deleteing file help

[fishy]

$QueryS = "SELECT * FROM homework WHERE HwID = '$GET[id]'";
$ResultS = mysql_db_query($DBName,$QueryS,$Link) or die(mysql_error());
$QueryD = "DELETE FROM homework WHERE HwID = '$GET[id]' LIMIT 1";
$ResultD = mysql_db_query($DBName,$QueryD,$Link) or die(mysql_error());
while ($link = mysql_fetch_array($ResultS['FileURL']))
{unlink("c:\Inetpub\wwwroot\intranet\EHS\counter\$link");}

I am having trouble getting a filename from the database to actually delete an uploaded file on the server.

I get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\intranet\EHS\Test\getin1.php on line 67

I don't know what I am doing wrong.

Thanks for the help

[bpat1434]

You're using mysql_fetch_array() wrong. It should either be:

$row = mysql_fetch_array($ResultS){
  $link = $row['FileURL'];
}

or

$link = mysql_result($ResultS, 0, 'FileURL')

NOT

$link = mysql_fetch_array($ResultS['FileURL'])

~Brett

[fishy]

I tried to run this

$link = mysql_result($ResultS, 0, 'FileURL')

it gave me a list of repeating errors that said I believe no file of that name etc

I can't understand where the first code snippet goes. is that part of the while loop?

I am really struggling with php compared to coldfusion.

[bpat1434]

Given the following code:

$QueryS = "SELECT * FROM homework WHERE HwID = '$_GET[id]'";
$ResultS = mysql_db_query($DBName,$QueryS,$Link) or die(mysql_error());
$QueryD = "DELETE FROM homework WHERE HwID = '$_GET[id]' LIMIT 1";
$ResultD = mysql_db_query($DBName,$QueryD,$Link) or die(mysql_error());
while ($link = mysql_fetch_array($ResultS['FileURL']))
{unlink("c:\Inetpub\wwwroot\intranet\EHS\counter\$link");}

Everything is fine until the while loop. What you need is this:

$QueryS = "SELECT * FROM homework WHERE HwID = '$_GET[id]'";
$ResultS = mysql_db_query($DBName,$QueryS,$Link) or die(mysql_error());
$QueryD = "DELETE FROM homework WHERE HwID = '$_GET[id]' LIMIT 1";
$ResultD = mysql_db_query($DBName,$QueryD,$Link) or die(mysql_error());
$link2 = mysql_result($ResultS, 0, 'FileURL');
unlink("c:\Inetpub\wwwroot\intranet\EHS\counter\$link2");

Oh, and what does EHS stand for? ( Emergency Health Services perhaps 😃 )

~Brett

[fishy]

argg-getting closer I think. I can't believe I used the same name for a variable twice.

I switched it up and I am still getting this

unlink(C:\Inetpub\wwwroot\intranet\EHS\counter$link2) [function.unlink]: No such file or directory in C:\Inetpub\wwwroot\intranet\EHS\Test\getin1.php on line 68

The problem has to be getting the filename out of the database. would it print the variable out if it actually recieved the variable from the mysql_result?

new code

$QueryS = "SELECT * FROM homework WHERE HwID = '$GET[id]'";
$ResultS = mysql_db_query($DBName,$QueryS,$Link) or die(mysql_error());
$QueryD = "DELETE FROM homework WHERE HwID = '$GET[id]' LIMIT 1";
$ResultD = mysql_db_query($DBName,$QueryD,$Link) or die(mysql_error());
$link2 = mysql_result($ResultS, 0,'FileURL');
unlink("C:\Inetpub\wwwroot\intranet\EHS\counter\$link2");

EHS stands for essex high school http://www.ejhs.k12.vt.us/EHS/home/home1.cfm
trying to code a homework upload and delete program. Had it working nice in coldfusion but we are moving to php so have to recode. Thanks for all of the help

Tom

[bpat1434]

Okay, so you want to delete a file & DB record?

$conn = mysql_connect('host', 'user', 'pass');
mysql_select_db('database', $conn);
$query = "SELECT HwID, FileURL FROM `homework` WHERE HwID='".mysql_real_escape_string($_GET['id'])."' LIMIT 1";
$result = mysql_query($query);
if($result)
{
  $row = mysql_fetch_array($result);
  $query2 = "DELETE FROM `homework` WHERE HwID='".$row['HwID']."' LIMIT 1";
  $rslt = mysql_query($query2);
  $del = unlink($_SERVER['DOCUMENT_ROOT'].'/counter/'.$row['FileURL']);
  if($rslt)
  {
    if($del)
    {
      echo 'Deleted both successfully!';
    }
    else
    {
      echo 'Failed deleting file [<em>'.$row['FileURL'].'</em>]';
    }
  }
  else
  {
    echo 'Failed deleting from database.';
  }
}

~Brett

[fishy]

Cool thanks with some directory wrangling i got that to work great! thank you

I am getting this error though

Notice: Undefined index: DOCUMENT_ROOT in C:\Inetpub\wwwroot\intranet\EHS\counter\getin1.php on line 72

even though it works to delete the file.

can I just turn off the error reporting? I don't understand why that error would be showing up if it deletes the file successfully.

[fishy]

Alright so I guess that is a IIS issue. but the funny thing is that is still works. So I just dropped the doc root and it works great thanks

Tom