[RESOLVED] Deleting Stuff

gszauer

First, this is my table
CREATE TABLE db_x(
id int(11) NOT NULL auto_increment,
sold varchar(5) NOT NULL default 'false',
listing varchar(10) NOT NULL default '',
price decimal(9,2) NOT NULL default '',
address varchar(150) NOT NULL default '',
description varchar(255) NOT NULL default '',
tn varchar(50) NOT NULL default '',
p1 varchar(50) NOT NULL default '',
p2 varchar(50) NOT NULL default '',
p3 varchar(50) NOT NULL default '',
p4 varchar(50) NOT NULL default '',
p5 varchar(50) NOT NULL default '',
p6 varchar(50) NOT NULL default '',
p7 varchar(50) NOT NULL default '',
p8 varchar(50) NOT NULL default '',
p9 varchar(50) NOT NULL default '',
p10 varchar(50) NOT NULL default '',
PRIMARY KEY (id)
)
Now, sold colum has 1 of 2 values, eather true, or false.
Basically, when my php script is executed, all rows that have true in the sold colum should be deleted, also the rows contain the URL to the followind data
tn, p1, p2, p3, p4, p5, p6, p7, p8, p9, p10
The files that thease URL's point to should be deleted as well!
This is the php script i came up with

<title>Recycled</title>
Listing has ben Recycled<br><br>
<a href='main.html' target='_self'>Home</a><br><br><br><?php
$location = "localhost"; 
$username = "program"; 
$password = "e******";
$database = "program_program"; 
$id = $_POST["list"];
$sell = "true";
mysql_connect($hostname,$username, $password) OR DIE (" ");
mysql_select_db($database); 
$conn = @mysql_connect($location,$username,$password); 

mysql_select_db($database,$conn) or die ("Could not open database"); 
//mysql_query('DELETE FROM db_x WHERE id=$id');
$result = mysql_query("SELECT tn,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10 FROM db_x WHERE sold=$sell");
list ($tn,$p1,$p2,$p3,$p4,$p5,$p6,$p7,$p8,$p9,$p10) = mysql_fetch_array($result);

unlink("http://programmer2.net/data/data/$tn");
unlink("http://programmer2.net/data/data/$p1");
unlink("http://programmer2.net/data/data/$p2");
unlink("http://programmer2.net/data/data/$p3");
unlink("http://programmer2.net/data/data/$p4");
unlink("http://programmer2.net/data/data/$p5");
unlink("http://programmer2.net/data/data/$p6");
unlink("http://programmer2.net/data/data/$p7");
unlink("http://programmer2.net/data/data/$p8");
unlink("http://programmer2.net/data/data/$p9");
unlink("http://programmer2.net/data/data/$p10");

$delete = "DELETE FROM db_x WHERE sold=true";
mysql_query($delete) or die ("An error has occured!. <Br />Error: " . mysql_error());
?>

For some reason it never works 🙁 i keep getting errors like:
Warning: unlink(http://programmer2.net/data/data/): No such file or directory in /home/program/public_html/data/recycle2.php on line 32
An error has occured, and the data can not be added to the list, please contact Gabor.
Error: Unknown column 'true' in 'where clause'
Can anyone help?
All help is appriciated, and thank you for taking the time to read this post
~Gabor

bpat1434

TRUE is a mySQL reserved, word, put single quotes around it in the query and you should be fine:

$result = mysql_query("SELECT tn,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10 FROM db_x WHERE sold='$sell'");

gszauer

That works 🙂
1 last question, executing the sctipt, i get the following error messege for deleting files:

Warning: unlink(): open_basedir restriction in effect. File(/data/) is not within the allowed path(s): (/home/program/:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/program/public_html/data/recycle2.php on line 22

Any iades?

rane500

Looks like you're trying filesystem operations on directories outside of where PHP has permission to operate. You'll need to either move the directory you're trying to operate on to within one of the allowed paths listed in the error message and adjust accordingly or add the directory to that path/include list.

gszauer

So, youre saying the only directory i can use is pretty mutch home/program?

bpat1434

No, the directories you can use are:
-- Your personal PHP directory (/home/program probably)
-- The PHP Temp file area
-- Any other area defined by the PATH variable.

Now, you can actually add directories to the path fairly easily:

set_include_path( get_include_path( ) . ”:/path/you/want”);

gszauer

Just i last thing, to make shure i get what you are saying,

set_include_path( get_include_path( ) . ”:/path/you/want”);
That means i can change that to a directory of my choice, right?, also, seeing how there are multiple files do i need that once, or should i put it in the loop?
And :/path...
Does that path go from where the php file is, or from the root directory?
By the way, thanks for all this help

bpat1434

i believe it goes anywhere you want it to go.. not root of your directory, but root of computer. So:

set_include_path( get_include_path(). ":\home\users\b\bp\bpat1434\public_html\includes");

Something like that (note, "\" would be forward slash, but my computer is being a dick right now).