PHP - Php Unlink To Delete Images

please help me to solve this problem :
when my client want to remove a record all the related images must be deleted with it ,is that possible??

Hi all, i want delete old updated images with considering its index in array.

<?php
global $oldimg;
$oldimg = array();
//action: edit news
if (isset($_GET['id'])) {

$NewsID = (int)$_GET['id'];

if ($NewsID == 0) {

$rdir = '<META HTTP-EQUIV="Refresh" CONTENT="1.4;URL=panel-news.php">';

die($rdir);}

//get user from the database and put data into $_POST variables.

//Include database connection details

require_once('../config.php');

//Connect to mysql server

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if(!$link) {

 die('Failed to connect to server: ' . mysql_error());

}

//Select database

 $db = mysql_select_db(DB_DATABASE);

 if(!$db) {

die("Unable to select database");

  

  }

$rs = mysql_query("SELECT  newsimg1, newsimg2, ".
    " newsimg3 FROM news WHERE id = $NewsID");
if (mysql_num_rows($rs) == 0) die('no such a  newsID!');

$row = mysql_fetch_assoc($rs);

$oldimg[0] = $row['newsimg1'];

$oldimg[1] = $row['newsimg2'];

$oldimg[2] = $row['newsimg3'];
}
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>"
             enctype="multipart/form-data">
                <input type=file name="file[]" size=20 
                accept="image/jpg,image/jpeg,image/png">
                <input type=file name="file[]" size=20 
                accept="image/jpg,image/jpeg,image/png">
                <input type=file name="file[]" size=20 
                accept="image/jpg,image/jpeg,image/png">
                <input type="hidden" name="MAX_FILE_SIZE" value="2097152" />
                <input type="hidden" name="NewsID" 
                value='<?php echo (isset($NewsID))?$NewsID:"0";?>'>

<input type="submit" value="edit" id="save"  name="save"/>

</form>
            <?php

if (isset($_POST['save']) && isset($_POST['NewsID'])){

$NewsID = (int)$_POST['NewsID'];

  //Include database connection details

  require_once('../config.php');

  //Connect to mysql server

  $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

  if(!$link) {

   die('Failed to connect to server: ' . mysql_error());

  }

  //Select database

  $db = mysql_select_db(DB_DATABASE);

  if(!$db) {

  die("Unable to select database");

}

  //max fle size value

  $max_file_size = 2097152;

  //Global newsimg

  global $newsimg;global $ctr;

  $ctr = 0;

  //timestamp to make files unique names

  $timestamp = time();

  //destination folder path

  $destpath = "../Dir/Newsimg/";

  //looping each file or image from the form

  while(list($key,$value) = @each($_FILES["file"]["name"])) {

  //check if any empty or errors

  if(!empty($value)){

  if ($_FILES["file"]["error"][$key] > 0) {

  $edir ='<div id="fail" class="info_div">';

  $edir .='<span class="ico_cancel"><strong>';

  $edir .="err : ".  $_FILES["file"]["error"][$key]  .'</strong></span></div>';

  echo($edir);

  } else {

  //add the timestamp to filename

  $file_name = $timestamp.$_FILES['file']['name'];

  //temp name from upload form,  key of each is set

  $source = $_FILES["file"]["tmp_name"][$key] ;

  //getting the file type

  $file_type = $_FILES["file"]["type"][$key];

  //placing each file name into a variable

  $filename1 = $_FILES["file"]["name"][$key];

  //lowering the file names

  $filename = strtolower($filename1);

  //adding timestamp to front of file name

  $filename = "$timestamp$filename";

  ++$timestamp;

  if ($file_type != "image/jpeg" && $file_type != "image/png" && $file_type != "image/jpg") {

die("

<div id='fail' class='info_div'>

<span class='ico_cancel'><strong>

Invalid Format!</strong></span><br />

<a href=\"javascript: history.go(-1)\">Retry</a>

</div>"); }

 //moving the file to be saved from the temp location to the destination path

  move_uploaded_file($source, $destpath . $filename);

  //the actual final location with timestamped name

  $final_file_location = "$destpath$filename";

  if (file_exists($final_file_location)) {

  if (isset($oldimg[$ctr])) {

  chdir('../Dir/Newsimg/');

  echo $oldimg[$ctr];

  unlink($oldimg[$ctr]);}

  $newsimg[$ctr] = $filename;

  $ctr++;

  
?>TNX.

Hi all.
Here is my scripts which allow user to check multiple rows of data and delete it , but it require select data and click for twice to delete the rows , what should be the error?

Code: [Select]
<form name="frmSearch" method="post" action="insert-add.php">

<table width="600" border="1">
  <tr>
    <th width="50"> <div align="center">#</div></th>
    <th width="91"> <div align="center">ID </div></th>
    <th width="198"> <div align="center">First Name </div></th>
    <th width="198"> <div align="center">Last Name </div></th>
    <th width="250"> <div align="center">Mobile Company </div></th>
    <th width="100"> <div align="center">Cell </div></th>
    <th width="100"> <div align="center">Workphone </div></th>
    <th width="100"> <div align="center">Group </div></th>
  </tr>
    </form>
<?

    echo "<form name='form1' method='post' action=''>";

while($objResult = mysql_fetch_array($objQuery))
{


    echo "<tr>";
    echo "<td align='center'><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\" value=\"$objResult[addedrec_ID]\"></td>";
    echo "<td>$objResult[addedrec_ID] </td>";
    echo "<td>$objResult[FirstName]</td>";
    echo "<td>$objResult[LastName] </td>";
    echo "<td>$objResult[MobileCompany] </td>";
    echo "<td>$objResult[Cell] </td>";
    echo "<td>$objResult[WorkPhone] </td>";
    echo "<td>$objResult[Custgroup] </td>";

   echo "</tr>";

}


 echo "<td colspan='7' align='center'><input name=\"delete\" type=\"submit\" id=\"delete\" value=\"Delete\">";

 if (isset($_POST['delete']) && isset($_POST['checkbox'])) // from button name="delete"
 {
 $checkbox = ($_POST['checkbox']); //from name="checkbox[]"
     $countCheck = count($_POST['checkbox']);

 for($d=0;$d<$countCheck;$d++)
     {
         $del_id  = $checkbox[$d];

 $sql = "DELETE from UserAddedRecord where addedrec_ID = $del_id";

 $result2=mysql_query($sql)  or trigger_error(mysql_error());;;

     }
         if($result2)
     { 
          $fgmembersite->GetSelfScript();
         }
         else
         {
 echo "Error: ".mysql_error();
         }
 }
  echo "</form>";


Thanks for every reply.

 <body>
 
 
  <?php
    

 
       include 'sql.php';
       $query = "SELECT * FROM validation";
       $result = mysqli_query($con , $query);  
       $rows = mysqli_fetch_assoc($result) ;
       $totals = mysqli_num_rows($result) ;
   
      
      
          ?>
            <div id="css">
    <form >
       <table width="80%" border="0" cellpadding="2" cellspacing="2" >
          <caption><h2>Personal Details of Customers</h2></caption>
          <tr class="white">
              <td bgcolor="#330033"> &nbsp; </td>
              <td bgcolor="#330033"> Id Number </td>
              <td bgcolor="#330033"> Full Name </td>
              <td bgcolor="#330033"> Email Address </td>
              <td bgcolor="#330033"> Website </td>
              <td bgcolor="#330033"> Comment </td>
              <td bgcolor="#330033"> Time </td>   
     
</tr>
       <?php while($rows=mysqli_fetch_assoc($result)
       {
       <tr>
      
      <input type="raido" name="ID" value="<?php echo $rows['ID']; ?>"  />
      <td bgcolor="#FFFFCC"><?php  echo $rows['ID'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Name'];?> </td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Email'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo  $rows['Website'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Comment'];?></td>
      <td bgcolor="#FFFFCC"><?php  echo $rows['Time'];?></td>  
      
       <td>&nbsp;</td>
     
       <td> <a href="delete.php? ID= "$rows[ID]" /"> <input type="submit" name="del" value="Delete" /> </a> &nbsp;                                                     <input type="button" name=   "edit" value="Edit"  /> </td>
       </tr>
              } 

?>
 
     </table>
   </form>
  </div>
 
 </body>

Hello. I wish to get a file name from a DB and then delete it from the server.

I have tried the code below. It gets the full url to the photo I wish to delete. It looks like this WITHOUT the spaces: http : // www . mysite . com/users/photo.jpg

Then it attempts to unlink it.

Code: [Select]
$result = mysql_query("SELECT PhotoURL FROM `$info` WHERE userid = '$UserID'") or die (mysql_error());

while ($row = mysql_fetch_array($result)) {
$myFile = $row['PhotoURL'];
unlink($myFile);
}



I get an error message like this (edited to remove my url, etc):

Code: [Select]
Warning: unlink() [function.unlink]: Unable to locate stream wrapper in /home/user/public_html/code.php : eval()'d code on line 64

What am I doing wrong? Also is there another way to delete server files?

the code below creates a table that lets me choose a row to delete from mysql database
<?php
$host="host"; // Host name 
$username="user"; // Mysql username 
$password="pass"; // Mysql password 
$db_name="testdocs"; // Database name 
$tbl_name="Docs"; // Table name 
       

        // Connect to server and select databse.
        mysql_connect("$host", "$username", "$password")or die("cannot connect");
        mysql_select_db("$db_name")or die("cannot select DB");
       
        // Build SQL query
        if(!isset($_POST['delete'])) $sql="SELECT * FROM $tbl_name ORDER BY id";
        else {
                $sql = "DELETE FROM $tbl_name WHERE";

                // add row id to where section
                for($i=0;$i<count($_POST['checkbox']);$i++){
                        if($i != 0) $sql.= "AND ";
                        $sql .= " id='" . $_POST['checkbox'][$i] . "'";
                }
     }

      $result = mysql_query($sql);
       if(isset($_POST['delete']))  header('Location: index.php'); // redirect
?>
<table  align="center" width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="delete" method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>">
<table width="400" border="1" cellpadding="3" cellspacing="1">
<tr>
<td colspan="5" align="center"><strong>Testimonials</strong> </td>
</tr>
<tr>
<td align="center"><strong>Select</strong></td>
<td align="center"><strong>ID</strong></td>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Message</strong></td>
<td align="center"><strong>Download</strong></td>
</tr>
<?php while($rows=mysql_fetch_array($result)){ ?>
        <tr>
                <td align="center">
                        <input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>">
                </td>
                <td><? echo $rows['id']; ?></td>
                <td><? echo $rows['Name']; ?></td>
                <td><? echo $rows['Message']; ?></td>
                <td><? echo $rows['Download']; ?></td>
        </tr>
        <tr>
        <td colspan="5" align="center"><input name="delete" type="submit" id="delete" value="Delete"></td>
        </tr>
<?php  }
        mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

but what i am trying to do is add unlink() to the script so when i delete a row it deletes the linked file.
this bit is where the filename is shown like test.doc and the files are stored in the directory /test_docs
<td><? echo $rows['Download']; ?></td>

is there anyway to do it so it deletes the file

hi again, i have a image uploading page, i wanna add a delete option to each image that was uploaded..

the code that im using is taking thumbnails from folder, displaying only 4 images per page, and when u click on thumbnail - original sized image comes up, heres the code:


<?php
$del = "delete";
//The directory to your images folder, with trailing slash
$dir = "uploads/thumbs/watermarkedthumbs/";
$dir2 = "uploads/";
//Set the extensions you want to load, seperate by a comma.
$extensions = "jpeg,jpg,png,gif";
//Set the number of images you want to display per page
$imagesPerPage = 4;
//Set the $page variable
if(!isset($_GET['page'])){
$page = 1;
}else{
$page = $_GET['page'];
}
//Load all images into an array
$images = glob($dir."*.{".$extensions."}", GLOB_BRACE);
$images2 = glob($dir2."*.{".$extensions."}", GLOB_BRACE);
//Count the number of images
$totalImages = count($images);
$totalImages2 = count($images2);
//Get the total pages
$totalPages = ceil($totalImages / $imagesPerPage);
$totalPages2 = ceil($totalImages2 / $imagesPerPage);
//Make sure the page you are on is not greater then the total pages available.
if($page > $totalPages){
//Set the currnet page to the total pages.
$page = $totalPages;
}
//Now find where to start the loading from
$from = ($page * $imagesPerPage) - $imagesPerPage;
//Now start looping
for($i = $from; $i < ($from + $imagesPerPage); $i++){
//We need to make sure that its within the range of totalImages.
if($i < $totalImages){
//Now we can display the image!

    echo "<a href='{$images2[$i]}'><img style='border:thin solid
  #FFF;margin-top:10px;margin-left:10px;margin-right:10px ' src='{$images[$i]}'alt='{$images[$i]}' /></a>";
    
}
}

//Now to display the page numbers!
for($p = 1; $p <= $totalPages; $p++){
if($p == $page){
$tmp_pages[] = "<strong>{$p}</strong>";
}else{
$tmp_pages[] = "<a href='?page={$p}'>{$p}</a>";
}
}
//Now display pages, seperated by a hyphon.
echo "<br/>" . implode(" - ", $tmp_pages);

?>


i was thinking of adding another echo he

if($i < $totalImages){
//Now we can display the image!

    echo "<a href='{$images2[$i]}'><img style='border:thin solid
  #FFF;margin-top:10px;margin-left:10px;margin-right:10px ' src='{$images[$i]}'alt='{$images[$i]}' /></a>";
    
}

and then doing something with unlink..

do i need to look for something else to add a delete button to each image uploaded?
thanks

Hi,

I have a function that resides in a class, this function deletes a file in a specific folder.
This works, the file is deleted but I get the warning that he can't find the file in the folder.

So here's the error:

Quote

Warning: unlink(/Applications/MAMP/htdocs/wordpress/wp-content/plugins/flashplayer/player/songs/14-i_cant_go_on_ill_go_on_feat._vanessa_hudgens-everything_i_own.mp3) [function.unlink]: No such file or directory in /Applications/MAMP/htdocs/wordpress/wp-content/plugins/flashplayer/xml.php on line 122


And here's the code:

Delete function:
function remove_mp3_file(){

$target_path = dirname(__FILE__)."/player/songs/";
unlink($target_path.$this->filename);

}

function that calls the remove function:

function remove_xml_item(){

//$this->open_xml_playlist();

$xml = new DOMDocument('1.0', 'UTF-8');
$xml->preserveWhiteSpace = false;
$file = dirname(__FILE__)."/player/music.xml";
$xml->load($file);

$xpath = new DOMXPath($xml);
$query = '//song[title="'.htmlentities($this->title).'" and artist = "'.htmlentities($this->artist).'" ]';
$entries = $xpath->query( $query );

foreach( $entries as $entry ){

$entry->parentNode->removeChild($entry);

}

$savefile = $xml->save($file);

$remove_file = $this->remove_mp3_file();

if( (!$savefile) && (!$remove_file) ){
return false;
}elseif( ($savefile) && ($remove_file) ){
return true;
}

}

First I thought that it was I set a variable that calls the delete function and then I use a if statement for this, but it wasn't that.

Anyone an idea?

Thanks!

If I use code:
while ($row = mysql_fetch_assoc($result)) {
@unlink(SRV_ROOT . IMAGE_DIR . $row['image']);
}


What is the difference between
@unlink(SRV_ROOT . IMAGE_DIR . $row['image']);

AND

unlink(SRV_ROOT . IMAGE_DIR . $row['image']);

On this path is deleted image files, but why use symbol @
When it is used in syntax, and why?

Tanks in advance

Not used unlink function before so a bit unsure. I do need it to remove a file in a different directory than the one the unlink function is in - it's actually in a parent sub directory.

Is there another way of doing this if unlink is unsuitable or can someone help me correct my code?

Code: [Select]
        elseif ( $action == "dlt" && $step == "2" ) {

          mysql_query('DELETE FROM items WHERE auto_increment = "'.$auto_increment.'"') or die( mysql_error() );

            $small = "../admin/imgs/small/90_'.$auto_increment.'.jpg";
              unlink( $small );
            $large = "../admin/imgs/small/250_'.$auto_increment.'.jpg";
              unlink( $large ); }

Cheers

I have a config file that lists a file like so..

Code: [Select]
$file1 = 'storagefolder/mydatabase.txt';
How can I delete the file "mydatabase.txt" that is in another directory 'storagefolder' ?

Code: [Select]
unlink($file1);gives an error that says not such file or directory

Hi,   I wish to find out is there any possible that I can delete some data inside my php website but inside my sql database, the record will still at there?   Thank you.

I want to delete an image file from a folder using unlink. The code is :
Code: [Select]
$movie_id  = $checkbox[$i];
 
$sql = "DELETE from movie_basic_details where `movie_id` = '$movie_id'";
$result = mysql_query($sql) or die(mysql_error());
$sql1 = "DELETE from movie_details where `movie_id` = '$movie_id'";
$result = mysql_query($sql1) or die(mysql_error());
$sql2 = "DELETE from movie_stars where `movie_id` = '$movie_id'";
$result = mysql_query($sql2) or die(mysql_error());
$query = "select movie_name from movie_basic_details where movie_id = '$movie_id'";
$res = mysql_query($query) or die(mysql_error());
$data = mysql_fetch_array($res);
unlink("upload/movies/".$data['movie_name']);

}
The entries in the database have been deleted but only the image corresponds to that entry do not get deleted. The following warning comes up :

Warning: unlink(upload/movies/) [function.unlink]: Permission denied in C:\wamp\www\ContentPanel\deletemovies.php on line 23

I have uploaded the files using $_FILES server variable and move_uploaded_file function. I am running this script on windows 7.
Please Help.

any help with this please? it works fine with deleting database results but the unlink wont unlink file from dir?

Code: [Select]
else if($action=="del")
{
    $id = $_GET["id"];
    $cls = $_GET["cls"];
    $dir = "gallery/$cls";
  echo "<p align=\"center\">";
 
  $owner = mysql_fetch_array(mysql_query("SELECT uid FROM gallery WHERE id='".$id."'"));
  if(mod(getuid_id($id))||getuid_id($id)==$owner[0])
  {
    $res = mysql_query("DELETE FROM gallery WHERE id='".$id."'");
$res2 = mysql_query("DELETE FROM comments WHERE pid='".$id."'");
$res3 = mysql_query("DELETE FROM rate WHERE pid='".$id."'");

    if($res||res2||res3 || unlink($dir))
        {
            echo "Photo Deleted From Gallery<br/>";
        }else{
          echo "Database Error!<br/>";
        }
  }else{
    echo "You can't delete this Photo";
  }

Hey guys, I've written a script that is suppose to Display the files within a specified directory /documents/ with check boxes to the right of them..  This worked out great.

Then I wanted to devise a method to remove or unlink the selected files (via check box) when the user pressed a Submit button..

File Permissions on the server are 777 and I have hardcoded an unlink to test to see if it works and it does..  So the bug lies within my code..

Before I post the code let me explain my method in doing this.
I created a for loop to name each check box after the corresponding file to the left and created a variable with the file name (to use later)

Then on button press I made a for loop (it goes up to 50 because I wasn't sure how to make it the exact number of files and I didn't want to overload the server with say 1000000 :?) that goes through and checks the check box's values and if they equal 1, unlink the file in /documents/

Here's the code:
Code: [Select]
<html>
<body>

<form action="" method="post" class="delete">
<?php
$dir = "documents/";
if ($handle = opendir($dir))
{
echo '<h2>List of Files in '.$dir.'</h2>';
echo '<table>';
for ($i = -2; false !== ($file = readdir($handle)); $i++)
{
if ($file != "." && $file != "..")
{
echo '<tr><td><a href="'.$dir.''.$file.'">'.$file.'</a></td><td><input type="checkbox" name="Del['.$i.']" /></td</tr>';
$DelFile[$i] = $file;
}
}
echo '</table>';
closedir($handle);
}

?>
<br />
<input type="submit" name="submit" value="Delete Checked Files" />
</form>

<?php
for ($i = 0; $i <= 50; $i++)
if ('Del['.$i.']' == 1)
unlink("'.$dir.''.$DelFile[$i].'");
?>

</body>
</html>
Help is extremely appreciated, and Thanks in advance guys!