Deleting file in web folder not working

Question

Im trying to delete irrelevant files from the web folder and the script aint working.

Here is the code:

<?php

    if(isset($_REQUEST['delete_file'])){

        if(isset($_GET['file_id'])){

$file_id = mysql_real_escape_string(strip_tags($_GET['file_id']));

    $file_info_query = @mysql_query("select * from video where id='$file_id'");
    $file_info_row = @mysql_fetch_assoc($file_info_query);
    $filename = $file_info_row['filename'];

        $path = $_SERVER['DOCUMENT_ROOT'].'/test2/video/';

        $file_path = $path;
        $file_path .= $filename;

            if(unlink($file_path))
            {
            echo "<p>File deleted successfully.</p> ";
            }
            else
            {
            echo "<p>Unable to delete file. Try again shortly.</p> ";
            }       

        }

    }



    ?>

Would be grateful getting this to work...Thank!

You are using [an **obsolete** database API](http://stackoverflow.com/q/12859942/19068) and should use a [modern replacement](http://php.net/manual/en/mysqlinfo.api.choosing.php). You are also **vulnerable to [SQL injection attacks](http://bobby-tables.com/)** that a modern API would make it easier to [defend](http://stackoverflow.com/questions/60174/best-way-to-prevent-sql-injection-in-php) yourself from. — Quentin, Feb 04 '13 at 12:07
If it isn't working, why are you **suppressing all the errors** that might tell you why?! (by littering `@`s across the code base) — Quentin, Feb 04 '13 at 12:08

score 1 · Accepted Answer · answered Feb 04 '13 at 12:09

1

Unlink function expects the complete server path of file. Please change your $path value to this one:

$path = $_SERVER['DOCUMENT_ROOT'].'/test2/video/';

answered Feb 04 '13 at 12:09

Code Prank

4,209
5
31
47

I've updated the path as suggested but stil not working...File stil exist! is there a better way of doing this? – Sms Feb 04 '13 at 12:22
check your folder permission also make sure your path is valid. – Code Prank Feb 04 '13 at 12:23
Change of file path worked..Thanks for the help! – Sms Feb 04 '13 at 12:41

Deleting file in web folder not working

1 Answers1