By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,824 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,824 IT Pros & Developers. It's quick & easy.

How to delete a file in my web server via php

P: n/a
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

Jan 22 '07 #1
Share this Question
Share on Google+
7 Replies


P: n/a
marce1972 wrote:
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
Jan 22 '07 #2

P: n/a
Janwillem Borleffs schreef:
marce1972 wrote:
>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
Jan 22 '07 #3

P: n/a
Janwillem Borleffs wrote:
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

Jan 22 '07 #4

P: n/a

Floortje wrote:
Janwillem Borleffs schreef:
marce1972 wrote:
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

Jan 22 '07 #5

P: n/a
marce1972 wrote:
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.
Jan 22 '07 #6

P: n/a
Ruben van Engelenburg schreef:
marce1972 wrote:
>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
Jan 22 '07 #7

P: n/a
Floortje schreef:
Ruben van Engelenburg schreef:
>marce1972 wrote:
>>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
Jan 22 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.