SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict
    Join Date
    May 2008
    Posts
    231
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    problem with image updating script

    I have a seriously problem about updating image in the DB.The script below works fine if a user uploads an Image but if no image is uploaded then it updates the filename coloumn in the DB with empty space even though the image is still in the image directory.
    What I want is to prevent the empty space and just leave the filename in the DB if no image is uploaded.
    please look at my code below ,sorry that is too long

    PHP Code:
    if (isset($_POST['btnSubmit'])){
    // The agent's details have been updated.
    $id=$_POST['id'];
    $file_image=$_POST['file_image'];
    $file_image2=$_POST['file_image2'];
    $file_image3=$_POST['file_image3'];
    $file_image4=$_POST['file_image4'];

       
    $save_image=array();
       while(list(
    $key,$value) = each($_FILES['cons_image']['name']))
    {
    if(!empty(
    $value)){   // this will check if any blank field is entered

       
    $size=getimagesize($_FILES['cons_image']['tmp_name'][$key]);
        
    $sizekb=filesize($_FILES['cons_image']['tmp_name'][$key]);
        
    //reads the name of the file the user submitted for uploading
        
    $image=$_FILES['cons_image']['name'][$key];
        
    // if it is not empty


        // get the original name of the file from the clients machine
        
    $filename stripslashes($_FILES['cons_image']['name'][$key]);

        
    // get the extension of the file in a lower case format
        
    $extension getExtension($filename);
        
    $extension strtolower($extension);



          
    $randrand(01000000000);
          
    //we will give an unique name, for example a random number
          
    $image_name=$rand.'.'.$extension;

        
    //the new name will be containing the full path where will be stored (images folder)

          
    $consname="image/".$image_name;  //change the image/ section to where you would like the original image to be stored

          
    $consname2="image/thumb".$image_name//change the image/thumb to where you would like to store the new created thumb nail of the image

          
    $copied copy($_FILES['cons_image']['tmp_name'][$key], $consname);

          
    $copied copy($_FILES['cons_image']['tmp_name'][$key], $consname2);
          
    $save_image[] = $image_name;

    //we verify if the image has been uploaded, and print error instead
          
    if (!$copied) {
             
    $error[] = '<p>Image was not uploaded!</p>';
          }
          else
          {
             
    // the new thumbnail image will be placed in images/thumbs/ folder
             
    $thumb_name=$consname2    ;
             
    // call the function that will create the thumbnail. The function will get as parameters
             //the image name, the thumbnail name and the width and height desired for the thumbnail
             
    $thumb=make_thumb($consname,$thumb_name,WIDTH,HEIGHT);
          }


    }
    }

    $thumb_path "thumb".$file_image;
    $thumb_path2 "thumb".$file_image2;
    $thumb_path3 "thumb".$file_image3;
    $thumb_path4 "thumb".$file_image4;


    if(!empty(
    $save_image[0])){
        @
    unlink("image/$file_image");
        @
    unlink("image/$thumb_path");
    }

    if(!empty(
    $save_image[1])){
    @
    unlink("image/$file_image2");
    @
    unlink("image/$thumb_path2");
    }

    if(!empty(
    $save_image[2])){
    @
    unlink("image/$file_image3");
    @
    unlink("image/$thumb_path3");
    }

    if(!empty(
    $save_image[3])){
    @
    unlink("image/$file_image4");
    @
    unlink("image/$thumb_path4");
    }

    if(!empty(
    $save_image[0])){
         
    $sql "UPDATE property_list SET
          image_filename='
    $save_image[0]'
          WHERE prop_id='
    $id'";
            
    $query mysql_query($sql)or die(mysql_error());
        }


    if(!empty(
    $save_image[1])){
         
    $sql "UPDATE property_list SET
          image_filename2='
    $save_image[1]'
          WHERE prop_id='
    $id'";
            
    $query mysql_query($sql)or die(mysql_error());
        }

    if(!empty(
    $save_image[2])){
         
    $sql "UPDATE property_list SET
          image_filename3='
    $save_image[2]'
          WHERE prop_id='
    $id'";
            
    $query mysql_query($sql)or die(mysql_error());
        }

    if(!empty(
    $save_image[3])){
         
    $sql "UPDATE property_list SET
          image_filename4='
    $save_image[3]'
          WHERE prop_id='
    $id'";
            
    $query mysql_query($sql)or die(mysql_error());
        }

    /*$sql = "UPDATE property_list SET
          image_filename='$save_image[0]',
          image_filename2='$save_image[1]',
          image_filename3='$save_image[2]',
          image_filename4='$save_image[3]'
          WHERE prop_id='$id'";*/


    if (@mysql_query($sql)) {
    $display '<p><strong>Image updated.</strong></p>';
    } else {
    $display '<p>Image was not updated: ' .
    mysql_error() . '</p>';
    }





    HTML Code:
    <label>Change Image 1</label>
                    <input type='file'  name='cons_image[]' class='bginput' />
    		</p>
    
                    <p>
    
    		<label>Change Image 2</label>
                    <input type='file'  name='cons_image[]' class='bginput' />
    		</p>
    
                    <p>
    
    		<label>Change Image 3</label>
                    <input type='file'  name='cons_image[]' class='bginput' />
    		</p>
    
                    <p>
    
    		<label>Change Image 4</label>
                    <input type='file'  name='cons_image[]' class='bginput' />
    		</p>
    
    
                             <input type="hidden" name="file_image" value="<?php echo $filename;?>"/>
                             <input type="hidden" name="file_image2" value="<?php echo $filename2;?>"/>
                             <input type="hidden" name="file_image3" value="<?php echo $filename3;?>"/>
                             <input type="hidden" name="file_image4" value="<?php echo $filename4;?>"/>
    
                             <input type="hidden" name="id" value="<?php echo $id;?>"/>
                            <input type="submit" value="Submit"  name="btnSubmit"/>

  2. #2
    Theoretical Physics Student bronze trophy Jake Arkinstall's Avatar
    Join Date
    May 2006
    Location
    Lancaster University, UK
    Posts
    7,062
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    PHP Code:
    if(!empty($save_image[0])){ 
    Try:

    PHP Code:
    if(array_key_exists(0$save_image){ 
    Jake Arkinstall
    "Sometimes you don't need to reinvent the wheel;
    Sometimes its enough to make that wheel more rounded"-Molona

  3. #3
    SitePoint Addict
    Join Date
    May 2008
    Posts
    231
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks dude,it worked


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •