1. I can't delete the photo file from database until my check is corrected as it will not go passed it to continue the code.
2. If I don't have my check code inserted I can delete the file perfectly well from the database but can not get it to delete the file from the directory the photo was uploaded too.
Here is my latest code.
Code: Select all
<?php
if($_GET['mode'] == "delete_photo"){
if (isset($_GET['photo'])) { $photo = (int) $_GET['photo']; } else { $photo = false; }
if (($photo === false) || ($photo < 1) || ($photo > 12)) { $msg = "Error: photo number not specified or out of range!"; }
///// Checks if any Photo has been Removed Already or not been Uploaded Before /////
$check = "SELECT photo".$_GET['photo']." FROM ".TBL_PROPERTIES." WHERE property_id='".$_GET['id']."' AND username='$session->username' ";
if(@mysql_query($check)){
if ($check == $empty){
$msg3 = "Photo ".$_GET['photo']." has either already been removed or no photo was uploaded before.";
}else{
$msg3 = "ERROR: There seems to be a problem, please contact administrators for help at " . ADMIN_EMAIL . " !";
}
}else{
///// Remove Photos from Directory and DB /////
$get_file = mysql_query("SELECT photo".$_GET['photo']." FROM ".TBL_PROPERTIES." WHERE property_id='".$_GET['id']."' AND username='$session->username' AND name='$name' ") or die ( mysql_error() );
list($del_path) = mysql_fetch_row($get_file);
@unlink("$SITEurl/photos/properties/{$session->username}/$name/$del_path");
$deletefile = mysql_query("DELETE photo".$_GET['photo']." FROM ".TBL_PROPERTIES." WHERE property_id='".$_GET['id']."' ");
if(@mysql_query($deletefile)){
$msg2 = "Photo <b>".$_GET['photo']."</b> has been deleted!";
}else{
$msg2 = "ERROR: Theres a problem deleting <b>photo ".$_GET['photo']."</b> from your property photo directory, please contact administrators for help at " . ADMIN_EMAIL . " !";
}
$sql = mysql_query("DELETE FROM ".TBL_PROPERTIES." WHERE property_id='".$_GET['id']."' AND photo".$_GET['photo']."='$photo' ") or die ( mysql_error() );
$lastedit = date("Y:m:d H:i:s");
$sqlUPDATE = "UPDATE ".TBL_PROPERTIES." SET photo".$_GET['photo']."='', last_edit='$lastedit' WHERE property_id='".$_GET['id']."' ";
if(@mysql_query($sqlUPDATE)){
$msg = "You have removed <b>photo ".$_GET['photo']."</b> from your property!";
}else{
$msg = "ERROR: Theres a problem removing photo ".$_GET['photo'].", please contact administrators for help at " . ADMIN_EMAIL . " !";
}
}
}
?>