unlink/delete file from mysql database

[jessica87]

hi there....
i need some guidance here with
this code?

Code: ( text )

1.
$myFile = "testFile.txt";
2.
$fh = fopen($myFile, 'w') or die("can't open file");
3.
fclose($fh);



and this one too
Code: ( text )

1.
$myFile = "testFile.txt";
2.
unlink($myFile);




and my question is...
1) can i use this code to delete/unlink my file from mysql database?
2)or can i use the common delete code to delete my file?

[hsriat]

Just run a DELETE query (or UPDATE query).

DELETE FROM `table` WHERE `id` = '".$_GET['id']."'
 
UPDATE `table` SET `file` = '' WHERE `id` = '".$_GET['id']."'

Use the one which fulfills your needs.
Is it what you want?

[jessica87]

erm....
it's ok guys...
i solved it again.....
i use the common delete coding to delte the file from my database..
this is the code i use ^_^

[PHP]<?
include("connectdb.php");

$id=$_GET['id'];
mysql_query("delete from filestorage where FileId='$id'");
mysql_close();
header("location:list_filesZ.php");
?>[/PHP]

[jessica87]

Just run the DELETE query (or UPDATE query).

DELETE FROM `table` WHERE `id` =  '".$_GET['id']."'
 
UPDATE `table` SET `file` = '' WHERE `id` = '".$_GET['id']."'

Use the one which fulfills your needs.
Is it what you want?

ya...just the same code i try myself...Thank u ^_^

[hsriat]

ya...just the same code i try myself...Thank u ^_^

You are welcome

[Markus]

erm....
it's ok guys...
i solved it again.....
i use the common delete coding to delte the file from my database..
this is the code i use ^_^

[PHP]<?
include("connectdb.php");

$id=$_GET['id'];
mysql_query("delete from filestorage where FileId='$id'");
mysql_close();
header("location:list_filesZ.php");
?>[/PHP]

You should, as good practice, uppercase your mysql reserved words (eg: WHERE, FROM, SELECT ... ) and also wrap column names, table names, etc in backticks.

[php]
$_mysql = "SELECT `col_1` FROM `tbl_1` WHERE `col_1` = 'safe'";
[/php]

[hsriat]

You should, as good practice, uppercase your mysql reserved words (eg: WHERE, FROM, SELECT ... ) and also wrap column names, table names, etc in backticks.

[php]
$_mysql = "SELECT `col_1` FROM `tbl_1` WHERE `col_1` = 'safe'";
[/php]

Very good point... I'm also in favor of this.

Although PHP, SQL and JavaScript are not too strict in syntax, but one should always follow a proper rule.

[Markus]

Also, need some mysql_real_escape_string()'ing going on up there.

You're vulnerable to attacks!

[jessica87]

You should, as good practice, uppercase your mysql reserved words (eg: WHERE, FROM, SELECT ... ) and also wrap column names, table names, etc in backticks.

okay..^_^

i'll remember it...Thanks for the tip...
i do learn a lot from this forum....