Delete from an array

[jzm]

Hello,

 

I am getting my drop down menu data from an array from the database. Were I am stuck is I am not sure how to link the "text" from the drop down menu into the query. When I click delete it should delete the image row from the database. Any help on how to delete the file will be very welcome.

 

Jess

 

Would I set or get? - I think set

 

 

deleteimage.php

<?php 
include('includes/session.php'); 

include('includes/header.php'); 

include('includes/class/class.form.php'); 

include('includes/class/class.image.php'); 

include('includes/class/class.imageManager.php'); 



$formImageDelete = new Form('deleteimage.php', 'Delete','return CheckDelete();', ''); 

$imImageManager = new imageManager(); 

$aImageObjects = $imImageManager->getallImages(); 



$aImageName = array(); 

for($iCount=0; $iCount<count($aImageObjects);$iCount++){ 
    $imImage = $aImageObjects[$iCount]; 
    $aImageName[] = $imImage->getImageName(); 
} 



if(isset($_POST["submit"])){ 
          
    $formImageDelete->setStickyData($_POST); 
     
     
   $formImageDelete->checkNotEmpty("DeleteImage"); 

     
     
    if($formImageDelete->getValid() == true){ 
     
    $removeImage = new Image(); 
     
    $removeImage->setImageName($_POST["DeleteImage"]); 
     
    $removeImage->removeImage(); 
     
    $Message = "Image Deleted"; 
     
    }else{ 
     
    $Message = "Error"; 
    } 
     

} 


$formImageDelete->openFieldset(); 
$formImageDelete->makeDropDownList("Delete","DeleteImage",$aImageName); 
$formImageDelete->makeSubmitButton("submit","Delete"); 
$formImageDelete->closeFieldset(); 

$newNavigation = new Navigation(); 

?> 

    <?php echo $newNavigation->mainMenu();?> 
     
     
           <h1  class="Heading">Delete Image</h1> 
     
    <?php echo $Message; ?> 
         
        <?php echo $formImageDelete->getHTML();?> 
         
     
<?php include('includes/footer.php') ?>

 

class.image.php

 

public function removeImage(){ 
     
         global $database; 
         
        $Query = "DELETE * FROM Gallery WHERE imageName =" .$aImageName; 
         
        $resResult = $database->query($Query); 
     
     
        //Fetch The Row 
         
        $aImage = $database->fetch_array($resResult); 
         
        $this->iID = $aImage["id"]; 
        $this->sImageName = $aImage["imageName"]; 
        $this->sImagePath = $aImage["imagePath"]; 
         
        $this->bExisting = true; 
     
    }