Unlink

[jomagi]

I made a php/mysql page with the command UNLINK to delete files, it works fine in the PC, but when I put files in SERVER it don't work.

 

Any guess???

 

Thanks

[FD_F]

check for permissions

[JonnoTheDev]

And filepaths

[jomagi]

Permissions think is allright, I can upload files with no problem.

 

Paths, Ive tried change several times and no result, nothing work.

[andy_b42]

Permissions think is allright, I can upload files with no problem.

 

Paths, Ive tried change several times and no result, nothing work.

 

Having access rights to create files doesn't neccesarily mean you will be able to delete them.

[jomagi]

Permissions are 777, I've check again!

[andy_b42]

Only other thing i can think of then if you have 777 permissions on that folder and file would be that the directory is correct.

 

Have you tried using getcwd() to check you are in the right place?

[JonnoTheDev]

Do you get an error from the unlink() function?

Maybe you could use a file_exists() call first

$file = '/var/www/html/docs/x.txt';
if(file_exists($file)) {
unlink($file);
}
else {
print "file not found: ".$file;
}

[jomagi]

I add the file_exists and give no error, delete from mysql like allways but dont delete file from server.

[jomagi]

I made a echo at the variable and give nothing

 

if ((isset($_GET['id'])) && ($_GET['id'] != "")) {

  $query = sprintf("SELECT * FROM etiquetas WHERE id=%s",
                       GetSQLValueString($_GET['id'], "int"));
  $result = mysql_query($query);
  $row = mysql_fetch_array($result);
  $logoname = $row["logotipo"];
  
  echo "nome ficheiro é:" . $logoname;

 

Connection to database is ok because the record is deleted in the next step.

[redarrow]

add or die mysql_error() and also echo the query out to see if it correct.

 

also in the query what the s <<< for, sprintf s is a  string and i am sure you mean d decimal.

[redarrow]

my version. (re edited sorry.

<?php 

if ((isset($_GET['id'])) && ($_GET['id'] != "")) {

  $query = sprintf("SELECT * FROM etiquetas WHERE id=%d",
                       GetSQLValueString($_GET['id'], "int"));
  $result = mysql_query($query);
  while($row = mysql_fetch_array($result)){
  $logoname = $row["logotipo"];
  $logoname=$_POST['logonname'];
}
  echo "nome ficheiro é:" . $logoname;
}
?>

[redarrow]

even better. re edited( added error cheeking.

<?php 

if ((isset($_GET['id'])) && ($_GET['id'] != "")) {

$query = sprintf("SELECT * FROM etiquetas WHERE id=%d",
GetSQLValueString($_GET['id'], "int"));
$result = mysql_query($query)or die (mysql_error());
if(mysql_num_rows($result)){
	while($row = mysql_fetch_array($result)){
		$logoname = $row["logotipo"];
		$logoname=$_POST['logoname'];
	}
} else {
	echo $query;
	exit;
}
echo "nome ficheiro é:" . $logoname;
}
?>

[redarrow]

very secure example for you.

 

<?php 

if ((isset($_GET['id'])) && ($_GET['id'] != "")) {

if(preg_match("/^[0-9]$/",$_GET['id'])){

	$query = sprintf("SELECT * FROM etiquetas WHERE id=%d",

	GetSQLValueString($_GET['id'], "int"));

	$result = mysql_query($query)or die ("Select error mate <br>".  mysql_error());

	if(mysql_num_rows($result)){

		while($row = mysql_fetch_array($result)){

			$logoname = $row["logotipo"];

			$logoname=$_POST['logoname'];
		}
	} else {
		echo $query;
		exit;
	}
	echo "nome ficheiro é:" . $logoname;

}else{

	echo " sorry this id {$_GET['id']} is not a number!";

	exit;
}
}
?>

 

[jomagi]

Thanks for the help.

 

 

I change the code and now return "sorry this id 25 is not a number!"

[redarrow]

try now mate tell me what happens.

 

settype($_GET['id'],"integer");

 

<?php 

if ((isset($_GET['id'])) && ($_GET['id'] != "")) {

settype($_GET['id'],"integer");

if(preg_match("/^[0-9]$/",$_GET['id'])){

	$query = sprintf("SELECT * FROM etiquetas WHERE id=%d",

	GetSQLValueString($_GET['id'], "int"));

	$result = mysql_query($query)or die ("Select error mate <br>".  mysql_error());

	if(mysql_num_rows($result)){

		while($row = mysql_fetch_array($result)){

			$logoname = $row["logotipo"];

			$logoname=$_POST['logoname'];
		}
	} else {
		echo $query;
		exit;
	}
	echo "nome ficheiro é:" . $logoname;

}else{

	echo " sorry this id {$_GET['id']} is not a number!";

	exit;
}
}
?>

[jomagi]

Same result:

 

"sorry this id 25 is not a number!"

[premiso]

Alright, jo.

 

Post the code where you unlink the file. I fail to see any code like that up there. Better yet, post your full working code for us and I will see if we cannot get this solved for you.

[jomagi]

This is the code that work fine in PC with MYSQL on SERVER.

 

<?php require_once('Connections/dargil_site.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
} 

if ((isset($_GET['id'])) && ($_GET['id'] != "")) {

  $query = sprintf("SELECT * FROM etiquetas WHERE id=%s",
                       GetSQLValueString($_GET['id'], "int"));
  $result = mysql_query($query);
  $row = mysql_fetch_array($result);
  $logoname = $row["logotipo"];
  unlink($logoname);

  $deleteSQL = sprintf("DELETE FROM etiquetas WHERE id=%s",
                       GetSQLValueString($_GET['id'], "int"));

  mysql_select_db($database_dargil_site, $dargil_site);
  $Result1 = mysql_query($deleteSQL, $dargil_site) or die(mysql_error());

  $deleteGoTo = "admin_etiquetas.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
    $deleteGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $deleteGoTo));
}
?>

 

Then I upload all files with filezilla to the SERVER and all works fine less the scripts with UNLINK.

 

Thanks for the help

[premiso]

Ok, is there an error coming out, or is it just not deleting the file? If an error, post it here.

 

  $logoname = $row["logotipo"];
if (file_exists($logoname)) {
   $fileinfo = substr(sprintf('%o', fileperms($logoname)), -4);
   echo 'The permissions for the file ' . $logonname . ' are: ' . $fileinfo . '<br />';
   if (unlink($logoname)) {
          echo 'The file ' . $logoname . ' should be erased.<br />';
   }else {
          echo 'The file ' . $logoname . ' was not erased.<br />';
   }   
}else {
    echo 'The file does not exist!';
}

 

Add the above in there and run the script and report back what it outputs.

[jomagi]

No error displayed!

All go well, just the file isn't deleted, when I go check folder, the files remain there in the server.

[premiso]

No error displayed!

All go well, just the file isn't deleted, when I go check folder, the files remain there in the server.

 

Did it display any messages? Such as "The permissions for the file" or "the file should be erased" If so please post those.

 

If not, it never makes it to that point in the script and you have an error somewhere...

[jomagi]

It dont show anything, all run normaly with delete mysql record and redirect on finish, just the files don't erase from server folder.

[redarrow]

try this.

<?php
  $logoname = $row["logotipo"];
if (file_exists($logoname)) {
   $fileinfo = substr(sprintf('%o', fileperms($logoname)), -4);
   echo 'The permissions for the file ' . $logonname . ' are: ' . $fileinfo . '<br />';
       
           if (chmod( $logoname, 0777 )&& unlink($logoname)) {
          echo 'The file ' . $logoname . ' should be erased.<br />';
   }else {
          echo 'The file ' . $logoname . ' was not erased.<br />';
   }   
}else {
    echo 'The file does not exist!';
}
?>

 

[jomagi]

Same thing!!!

 

No errors, do the same as before!!!