Delete the file before deleting the row data?

Question

I wanna delete the file from the uploads folder before deleting the row data from the database. I used the below code but its giving the error. Error=> No such file or directory

function deleteItem($conn,$product_id)
{
    $stmtgetfile=$conn->prepare("SELECT * FROM tbl_item WHERE product_id=:product_id");
    $stmtgetfile->bindParam('product_id',$product_id);
    $stmtgetfile->execute();
    $row = $stmtgetfile->fetch(PDO::FETCH_ASSOC);
    $item=$row['product_photo'];
    $path="../uploads/".$item;
    unlink($path);
    // $stmtdelete=$conn->prepare("DELETE FROM tbl_item WHERE product_id=:product_id");
    // $stmtdelete->bindParam('product_id',$product_id);
    // if($stmtdelete->execute())
    //     return true;
    // return false;
}

Madhur Bhaiya · Answer 1 · 2018-11-07T06:50:35.860

1

You will need to fix the $path value to get actual path. You can use __DIR__ constant for the same. And, also use file_exists() function to check if the file actually exists or not, before trying to delete it. It seems that some of the file path(s) in your database are non-existent now.

$path = __DIR__ . "/../uploads/" . $item;
if (file_exists($path)) {
    unlink($path);
}

Also, if you are just going to need product_photo column value, don't use Select *. Change prepare query statement to:

$stmtgetfile=$conn->prepare("SELECT product_photo FROM tbl_item 
                             WHERE product_id=:product_id");

Do read: Why is SELECT * considered harmful?

edited Nov 07 '18 at 06:50

answered Nov 07 '18 at 06:29

Madhur Bhaiya

28,155
10
49
57

I tried your code. It removed the error but still the file is not deleted. And the file im trying is existing. – Soonang Rai Nov 07 '18 at 06:32
@SoonangRai What is the actual file path as per your OS? `echo $path` to check whether you are getting the same file path or not. – Madhur Bhaiya Nov 07 '18 at 06:33
This is path where this code exist. -> C:\xampp\htdocs\boutiqueAdmin\app And this is the path for file to be deleted. -> C:\xampp\htdocs\boutiqueAdmin\uploads – Soonang Rai Nov 07 '18 at 06:36

score 1 · Accepted Answer · answered Nov 07 '18 at 06:36

1

USE $_SERVER['DOCUMENT_ROOT'] to get absolute path of root directory.

$path=$_SERVER['DOCUMENT_ROOT']."/uploads/".$item;
if(file_exists($path)){
   unlink($path);
}else{
   echo $path; // check path here
}

answered Nov 07 '18 at 06:36

Vitthal

127
7

This worked for me. Your method helped me to get full path of the file thus finally it was deleted. – Soonang Rai Nov 07 '18 at 06:46

Delete the file before deleting the row data?

2 Answers2