Connecting Tech Pros Worldwide Forums | Help | Site Map

How to delete a file in my web server via php

marce1972
Guest
 
Posts: n/a
#1: Jan 22 '07
Hi to all, that's my question I have mysql database and a web page to
upload files to my webpage, I know how to delete them from the
database, but didnt find the code to delete them from the web server.
Please help me with this code.

Regards

Marcelo Fabiani


Janwillem Borleffs
Guest
 
Posts: n/a
#2: Jan 22 '07

re: How to delete a file in my web server via php


marce1972 wrote:
Quote:
Hi to all, that's my question I have mysql database and a web page to
upload files to my webpage, I know how to delete them from the
database, but didnt find the code to delete them from the web server.
Please help me with this code.
>
The only way to do this through HTTP is to create a remote script that
accepts parameters and uses these to select and delete the file. There's
also a HTTP DELETE method, but I have never encountered a server which
supports it.


JW


Floortje
Guest
 
Posts: n/a
#3: Jan 22 '07

re: How to delete a file in my web server via php


Janwillem Borleffs schreef:
Quote:
marce1972 wrote:
Quote:
>Hi to all, that's my question I have mysql database and a web page to
>upload files to my webpage, I know how to delete them from the
>database, but didnt find the code to delete them from the web server.
>Please help me with this code.
>>
>
The only way to do this through HTTP is to create a remote script that
accepts parameters and uses these to select and delete the file. There's
also a HTTP DELETE method, but I have never encountered a server which
supports it.
>
>
JW
shortest way :
@unlink($file);

Make sure to check the input first

--
Arjen
http://www.hondenpage.com
Toby Inkster
Guest
 
Posts: n/a
#4: Jan 22 '07

re: How to delete a file in my web server via php


Janwillem Borleffs wrote:
Quote:
The only way to do this through HTTP is to create a remote script that
accepts parameters and uses these to select and delete the file. There's
also a HTTP DELETE method, but I have never encountered a server which
supports it.
Apache does, though you need to do a lot of setup to get it to work.
WebDAV is a bit easier to set up, and better supported at the client end.

--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact

marce1972
Guest
 
Posts: n/a
#5: Jan 22 '07

re: How to delete a file in my web server via php



Floortje wrote:
Quote:
Janwillem Borleffs schreef:
Quote:
marce1972 wrote:
Quote:
Hi to all, that's my question I have mysql database and a web page to
upload files to my webpage, I know how to delete them from the
database, but didnt find the code to delete them from the web server.
Please help me with this code.
>
The only way to do this through HTTP is to create a remote script that
accepts parameters and uses these to select and delete the file. There's
also a HTTP DELETE method, but I have never encountered a server which
supports it.


JW
>
shortest way :
@unlink($file);
>
Make sure to check the input first
>
--
Arjen
http://www.hondenpage.com
Do I rite this on my php code as you wrote it?

$nom=$_POST['numero'];
$sql="DELETE FROM canciones WHERE idcancion='$nom';";
mysql_query($sql) or die ("problema con borrado");
$arch=$_POST['ref'];
@unlink($arch);

Is this correct
Thanks I'll download the other option webdav too to see if it works

regards

Marcelo

Ruben van Engelenburg
Guest
 
Posts: n/a
#6: Jan 22 '07

re: How to delete a file in my web server via php


marce1972 wrote:
Quote:
Do I rite this on my php code as you wrote it?
>
$nom=$_POST['numero'];
$sql="DELETE FROM canciones WHERE idcancion='$nom';";
mysql_query($sql) or die ("problema con borrado");
$arch=$_POST['ref'];
@unlink($arch);
>
Is this correct
Thanks I'll download the other option webdav too to see if it works
No, as Arjen already pointed out: check the input. This means you should
check the value of $_POST['ref'], because if you don't the user will be
able to delete any file the webserver has writing rights to.

Ruben.
Floortje
Guest
 
Posts: n/a
#7: Jan 22 '07

re: How to delete a file in my web server via php


Ruben van Engelenburg schreef:
Quote:
marce1972 wrote:
>
Quote:
>Do I rite this on my php code as you wrote it?
>>
> $nom=$_POST['numero'];
> $sql="DELETE FROM canciones WHERE idcancion='$nom';";
> mysql_query($sql) or die ("problema con borrado");
> $arch=$_POST['ref'];
> @unlink($arch);
>>
>Is this correct
> Thanks I'll download the other option webdav too to see if it works
>
No, as Arjen already pointed out: check the input. This means you should
check the value of $_POST['ref'], because if you don't the user will be
able to delete any file the webserver has writing rights to.
One way to do it:
check if page is listed in the db
$sql = "SELECT id,page FROM $table WHERE id = '".intval($_POST['id'])."'";

if that query gives one result then execute your code


--
Arjen
http://www.hondenpage.com
Floortje
Guest
 
Posts: n/a
#8: Jan 22 '07

re: How to delete a file in my web server via php


Floortje schreef:
Quote:
Ruben van Engelenburg schreef:
Quote:
>marce1972 wrote:
>>
Quote:
>>Do I rite this on my php code as you wrote it?
>>>
>> $nom=$_POST['numero'];
>> $sql="DELETE FROM canciones WHERE idcancion='$nom';";
>> mysql_query($sql) or die ("problema con borrado");
>> $arch=$_POST['ref'];
>> @unlink($arch);
>>>
>>Is this correct
>> Thanks I'll download the other option webdav too to see if it works
>>
>No, as Arjen already pointed out: check the input. This means you
>should check the value of $_POST['ref'], because if you don't the user
>will be able to delete any file the webserver has writing rights to.
>
One way to do it:
check if page is listed in the db
$sql = "SELECT id,page FROM $table WHERE id = '".intval($_POST['id'])."'";
>
if that query gives one result then execute your code
And I mean execute your code with the results from the query :-) not
from the user input.


--
Arjen
http://www.hondenpage.com
Closed Thread