Smarteste måde at uploade billede og gemme img url i database?

Er det bare mig som der er blind, eller er der ingen steder hvor vi åbner til databasen??

Hvordan håndtere man at der bliver uploaded flere billeder af samme hest.

Kan man lave noget kode som løber igennem databasen og tjekker hvilke filer i mappen "Billeder" som der er i brug/ findes i databasen - og så sletter alle de billeder som ikke bruges i databasen?

Jeg mener den henter Billede og BilledeT (thumbnail) - hvad skal ImgPath bruges til? Er den info ikke i "billede"?
Vil den ikke skrive hele URL i "Billede" og "BilledeT"??

Mht. at få det lagt ind i databasen, så har jeg forsøgt med:

Kode 

 /*
// Insert info into database table!
mysql_query("UPDATE Databasen SET Billede='$DestRandImageName', BilledeT='$thumb_DestRandImageName' WHERE hid = '".mysql_real_escape_string($_GET['hid'])."'");
*/ 

PHP kode 

 <!-- Minus AutoDato -->
 <noscript>
  <div align="center"><a href="index.php">Go Back To Upload Form</a></div><!-- If javascript is disabled -->
  </noscript>
 <?php
 <?php
 //ini_set('display_errors', 1);
 //error_reporting(E_ALL);
 
 if(isset($_POST))
 {
       //Some Settings
      $ThumbSquareSize        = 200; //Thumbnail will be 200x200
      $BigImageMaxSize        = 600; //Image Maximum height or width
      $ThumbPrefix            = "thumb_"; //Normal thumb Prefix
      $DestinationDirectory           = '/billeder/'; //Upload Directory ends with / (slash)
      $Quality                = 90;
 
      // check $_FILES['ImageFile'] array is not empty
      // "is_uploaded_file" Tells whether the file was uploaded via HTTP POST
      if(!isset($_FILES['ImageFile']) || !is_uploaded_file($_FILES['ImageFile']['tmp_name']))
      {
              die('Something went wrong with Upload!'); // output error when above checks fail.
      }
 
      // Random number for both file, will be added after image name
      $RandomNumber   = rand(0, 9999999999);
 
      // Elements (values) of $_FILES['ImageFile'] array
      //let's access these values by using their index position
      $ImageName      = str_replace(' ','-',strtolower($_FILES['ImageFile']['name']));
      $ImageSize      = $_FILES['ImageFile']['size']; // Obtain original image size
      $TempSrc        = $_FILES['ImageFile']['tmp_name']; // Tmp name of image file stored in PHP tmp folder
      $ImageType      = $_FILES['ImageFile']['type']; //Obtain file type, returns "image/png", image/jpeg, text/plain etc.
 
      //Let's use $ImageType variable to check wheather uploaded file is supported.
      //We use PHP SWITCH statement to check valid image format, PHP SWITCH is similar to IF/ELSE statements
      //suitable if we want to compare the a variable with many different values
      switch(strtolower($ImageType))
      {
          case 'image/png':
              $CreatedImage =  imagecreatefrompng($_FILES['ImageFile']['tmp_name']);
              break;
          case 'image/gif':
              $CreatedImage =  imagecreatefromgif($_FILES['ImageFile']['tmp_name']);
              break;
          case 'image/jpeg':
          case 'image/pjpeg':
              $CreatedImage = imagecreatefromjpeg($_FILES['ImageFile']['tmp_name']);
              break;
          default:
              die('Unsupported File!'); //output error and exit
      }
 
      //PHP getimagesize() function returns height-width from image file stored in PHP tmp folder.
      //Let's get first two values from image, width and height. list assign values to $CurWidth,$CurHeight
      list($CurWidth,$CurHeight)=getimagesize($TempSrc);
      //Get file extension from Image name, this will be re-added after random name
      $ImageExt = substr($ImageName, strrpos($ImageName, '.'));
      $ImageExt = str_replace('.','',$ImageExt);
 
      //remove extension from filename
      $ImageName      = preg_replace("/\.[^.\s]{3,4}$/", "", $ImageName);
 
      //Construct a new image name (with random number added) for our new image.
      $NewImageName = $ImageName.'-'.$RandomNumber.'.'.$ImageExt;
      //set the Destination Image
      $thumb_DestRandImageName    = $DestinationDirectory.$ThumbPrefix.$NewImageName; //Thumb name
      $DestRandImageName          = $DestinationDirectory.$NewImageName; //Name for Big Image
 
      //Resize image to our Specified Size by calling resizeImage function.
      if(resizeImage($CurWidth,$CurHeight,$BigImageMaxSize,$DestRandImageName,$CreatedImage,$Quality,$ImageType))
      {
          //Create a square Thumbnail right after, this time we are using cropImage() function
          if(!cropImage($CurWidth,$CurHeight,$ThumbSquareSize,$thumb_DestRandImageName,$CreatedImage,$Quality,$ImageType))
              {
                  echo 'Error Creating thumbnail';
              }
          /*
          At this point we have succesfully resized and created thumbnail image
          We can render image to user's browser or store information in the database
          For demo, we are going to output results on browser.
          */
 
          //Get New Image Size
          list($ResizedWidth,$ResizedHeight)=getimagesize($DestRandImageName);
 
          echo '<table width="100%" border="0" cellpadding="4" cellspacing="0">';
          echo '<tr>';
          echo '<td align="center"><img src="billeder/'.$ThumbPrefix.$NewImageName.'" alt="Thumbnail" height="'.$ThumbSquareSize.'" width="'.$ThumbSquareSize.'"></td>';
          echo '</tr><tr>';
          echo '<td align="center"><img src="billeder/'.$NewImageName.'" alt="Resized Image" height="'.$ResizedHeight.'" width="'.$ResizedWidth.'"></td>';
          echo '</tr>';
          echo '</table>';
 
          /*
          // Insert info into database table!
          mysql_query("INSERT INTO Databasen (Billede, BilledeT, ImgPath)
          VALUES ($DestRandImageName, $thumb_DestRandImageName, 'billeder/')");
          */
 
      }else{
          die('Resize Error'); //output error
      }
 
 }
 
 
 // This function will proportionally resize image
 function resizeImage($CurWidth,$CurHeight,$MaxSize,$DestFolder,$SrcImage,$Quality,$ImageType)
 {
      //Check Image size is not 0
      if($CurWidth <= 0 || $CurHeight <= 0)
      {
          return false;
      }
 
      //Construct a proportional size of new image
      $ImageScale         = min($MaxSize/$CurWidth, $MaxSize/$CurHeight);
      $NewWidth           = ceil($ImageScale*$CurWidth);
      $NewHeight          = ceil($ImageScale*$CurHeight);
 
      if($CurWidth < $NewWidth || $CurHeight < $NewHeight)
      {
          $NewWidth = $CurWidth;
          $NewHeight = $CurHeight;
      }
      $NewCanves  = imagecreatetruecolor($NewWidth, $NewHeight);
      // Resize Image
      if(imagecopyresampled($NewCanves, $SrcImage,0, 0, 0, 0, $NewWidth, $NewHeight, $CurWidth, $CurHeight))
      {
          switch(strtolower($ImageType))
          {
              case 'image/png':
                  imagepng($NewCanves,$DestFolder);
                  break;
              case 'image/gif':
                  imagegif($NewCanves,$DestFolder);
                  break;
              case 'image/jpeg':
              case 'image/pjpeg':
                  imagejpeg($NewCanves,$DestFolder,$Quality);
                  break;
              default:
                  return false;
          }
      //Destroy image, frees up memory
      if(is_resource($NewCanves)) {imagedestroy($NewCanves);}
      return true;
      }
 
 }
 
 //This function corps image to create exact square images, no matter what its original size!
 function cropImage($CurWidth,$CurHeight,$iSize,$DestFolder,$SrcImage,$Quality,$ImageType)
 {
      //Check Image size is not 0
      if($CurWidth <= 0 || $CurHeight <= 0)
      {
          return false;
      }
 
      //abeautifulsite.net has excellent article about "Cropping an Image to Make Square"
      //http://www.abeautifulsite.net/blog/2009/08/cropping-an-image-to-make-square-thumbnails-in-php/
      if($CurWidth>$CurHeight)
      {
          $y_offset = 0;
          $x_offset = ($CurWidth - $CurHeight) / 2;
          $square_size    = $CurWidth - ($x_offset * 2);
      }else{
          $x_offset = 0;
          $y_offset = ($CurHeight - $CurWidth) / 2;
          $square_size = $CurHeight - ($y_offset * 2);
      }
 
      $NewCanves  = imagecreatetruecolor($iSize, $iSize);
      if(imagecopyresampled($NewCanves, $SrcImage,0, 0, $x_offset, $y_offset, $iSize, $iSize, $square_size, $square_size))
      {
          switch(strtolower($ImageType))
          {
              case 'image/png':
                  imagepng($NewCanves,$DestFolder);
                  break;
              case 'image/gif':
                  imagegif($NewCanves,$DestFolder);
                  break;
              case 'image/jpeg':
              case 'image/pjpeg':
                  imagejpeg($NewCanves,$DestFolder,$Quality);
                  break;
              default:
                  return false;
          }
      //Destroy image, frees up memory
      if(is_resource($NewCanves)) {imagedestroy($NewCanves);}
      return true;
 
      }
 
 }

PHP kode 

 // Insert info into database table!
          mysql_query("UPDATE Databasen (Billede, BilledeT, ImgPath)
          VALUES ($DestRandImageName, $thumb_DestRandImageName, 'billeder/') WHERE hid = '".mysql_real_escape_string($_GET['hid'])."'");
          */
 
      }else{
          die('Resize Error'); //output error
      }

PHP kode 

 // Insert info into database table!
          mysql_query("UPDATE Databasen SET  Billede='$DestRandImageName', BilledeT=' $thumb_DestRandImageName' WHERE hid = '".mysql_real_escape_string($_GET['hid'])."');
          */
 
      }else{
          die('Resize Error'); //output error
      }

PHP kode 

 At this point we have succesfully resized and created thumbnail image
          We can render image to user's browser or store information in the database
          For demo, we are going to output results on browser.
          */
 
          //Get New Image Size
          list($ResizedWidth,$ResizedHeight)=getimagesize($DestRandImageName);
 
          echo '<table width="100%" border="0" cellpadding="4" cellspacing="0">';
          echo '<tr>';
          echo '<td align="center"><img src="billeder/'.$ThumbPrefix.$NewImageName.'" alt="Thumbnail" height="'.$ThumbSquareSize.'" width="'.$ThumbSquareSize.'"></td>';
          echo '</tr><tr>';
          echo '<td align="center"><img src="billeder/'.$NewImageName.'" alt="Resized Image" height="'.$ResizedHeight.'" width="'.$ResizedWidth.'"></td>';
          echo '</tr>';
          echo '</table>';
  include_once('Connect.php');  //
           /*
          // Insert info into database table!
          mysql_query("UPDATE Databasen SET  Billede='$DestRandImageName', BilledeT='$thumb_DestRandImageName' WHERE hid = '".mysql_real_escape_string($_GET['hid'])."'");
          */
 
      }else{
          die('Resize Error'); //output error
      }
 
 }

PHP kode 

 <form action="processupload.php?hid=53" method="post" enctype="multipart/form-data" id="UploadForm">
 <table width="500" border="0">
    <tr>
      <td>File : </td>
      <td><input name="ImageFile" type="file" /></td>
    </tr>
       <tr>
      <td>&nbsp;</td>
      <td><input type="submit"  id="SubmitButton" value="Upload" /></td>
    </tr>
 </table>
 </form>
 <div id="progressbox"><div id="progressbar"></div ><div id="statustxt">0%</div ></div>
 <div id="output"></div>

PHP kode 

 include_once('Connect.php');  //     
         // other post variables
         echo '<pre>Other Post Variables:';
         print_r($_POST);
         echo '</pre>';
         
         // Insert info into database table!
         
         // $hid = (isset($_GET["hid"]))? (int)$_GET["hid"]:0;    
                 $sql ="UPDATE Databasen SET Billede='$DestRandImageName' WHERE hid = '".$hid."'";
         echo $sql; // test ser sql ud som jeg forvendter ??
         mysql_query($sql) or die("Der er sket en fejl. ".mysql_error());
     }else{
         die('Resize Error'); //output error
     }
 }

PHP kode 

 //Get New Image Size
          list($ResizedWidth,$ResizedHeight)=getimagesize($DestRandImageName);
 
          echo '<table width="100%" border="0" cellpadding="4" cellspacing="0">';
          echo '<tr>';
          echo '<td align="center"><img src="billeder/'.$ThumbPrefix.$NewImageName.'" alt="Thumbnail" height="'.$ThumbSquareSize.'" width="'.$ThumbSquareSize.'"></td>';
          echo '</tr><tr>';
          echo '<td align="center"><img src="billeder/'.$NewImageName.'" alt="Resized Image" height="'.$ResizedHeight.'" width="'.$ResizedWidth.'"></td>';
          echo '</tr>';
          echo '</table>';
 
 
       include_once('Connect.php');  //     
          // other post variables
         echo '<pre>Other Post Variables:';
         print_r($_POST);
         echo '</pre>';
         
         // Insert info into database table!
         
         // $hid = (isset($_GET["hid"]))? (int)$_GET["hid"]:0;    
 
         $sql ="UPDATE Databasen SET Billede='$DestRandImageName' WHERE hid = '".$hid."'";
         echo $sql; // test ser sql ud som jeg forvendter ??
         mysql_query($sql) or die("Der er sket en fejl. ".mysql_error());
     }else{
         die('Resize Error'); //output error
     }
 }