php - Multi image upload - insert i db. - Udvikleren.dk - Programmering, webdesign og grafik

Tags: php

Bruger #17554 @ 22.11.13 13:22

Hej folkens.

Spørgsmål løber man hvis aldrig tør for

Jeg har fundet et okay multi upload. Men jeg ønsker at få den til at indsætte i db. Også med de antal der bliver valgt.

Alle billeder skal så have et id. Nogen kloge hoveder?..

Komplet kode:

PHP kode

 <?php
 /**
 * Multi file upload example
 * @author Resalat Haque
 * @link http://www.w3bees.com/2013/02/multiple-file-upload-with-php.html
 **/
 
 $valid_formats = array("jpeg", "jpg", "png", "gif");
 $max_file_size = 2048*1000; //100 kb
 $path = "uploads/"; // Upload directory
 $count = 0;
 
 if(isset($_POST) and $_SERVER['REQUEST_METHOD'] == "POST"){
     // Loop $_FILES to execute all files
     foreach ($_FILES['files']['name'] as $f => $name) {     
         if ($_FILES['files']['error'][$f] == 4) {
             continue; // Skip file if any error found
         }           
         if ($_FILES['files']['error'][$f] == 0) {               
             if ($_FILES['files']['size'][$f] > $max_file_size) {
                 $message[] = "$name is too large!.";
                 continue; // Skip large files
             }
             elseif( ! in_array(pathinfo($name, PATHINFO_EXTENSION), $valid_formats) ){
                 $message[] = "$name is not a valid format";
                 continue; // Skip invalid file formats
             }
             else{ // No error found! Move uploaded files 
                 if(move_uploaded_file($_FILES["files"]["tmp_name"][$f], $path.$name)) {
                     $count++; // Number of successfully uploaded files
                 }
             }
         }
     }
 }
 ?>
 
 <!doctype html>
 <html lang="en">
 <head>
     <meta charset="UTF-8" />
     <title>Multiple File Upload with PHP - Demo</title>
 <style type="text/css">
 a{ text-decoration: none; color: #333}
 h1{ font-size: 1.9em; margin: 10px 0}
 p{ margin: 8px 0}
 *{
     margin: 0;
     padding: 0;
     box-sizing: border-box;
     -webkit-box-sizing: border-box;
     -moz-box-sizing: border-box;
     -webkit-font-smoothing: antialiased;
     -moz-font-smoothing: antialiased;
     -o-font-smoothing: antialiased;
     font-smoothing: antialiased;
     text-rendering: optimizeLegibility;
 }
 body{
     font: 12px Arial,Tahoma,Helvetica,FreeSans,sans-serif;
     text-transform: inherit;
     color: #333;
     background: #e7edee;
     width: 100%;
     line-height: 18px;
 }
 .wrap{
     width: 500px;
     margin: 15px auto;
     padding: 20px 25px;
     background: white;
     border: 2px solid #DBDBDB;
     -webkit-border-radius: 5px;
     -moz-border-radius: 5px;
     border-radius: 5px;
     overflow: hidden;
     text-align: center;
 }
 .status{
     /*display: none;*/
     padding: 8px 35px 8px 14px;
     margin: 20px 0;
     text-shadow: 0 1px 0 rgba(255, 255, 255, 0.5);
     color: #468847;
     background-color: #dff0d8;
     border-color: #d6e9c6;
     -webkit-border-radius: 4px;
     -moz-border-radius: 4px;
     border-radius: 4px;
 }
 input[type="submit"] {
     cursor:pointer;
     width:100%;
     border:none;
     background:#991D57;
     background-image:linear-gradient(bottom, #8C1C50 0%, #991D57 52%);
     background-image:-moz-linear-gradient(bottom, #8C1C50 0%, #991D57 52%);
     background-image:-webkit-linear-gradient(bottom, #8C1C50 0%, #991D57 52%);
     color:#FFF;
     font-weight: bold;
     margin: 20px 0;
     padding: 10px;
     border-radius:5px;
 }
 input[type="submit"]:hover {
     background-image:linear-gradient(bottom, #9C215A 0%, #A82767 52%);
     background-image:-moz-linear-gradient(bottom, #9C215A 0%, #A82767 52%);
     background-image:-webkit-linear-gradient(bottom, #9C215A 0%, #A82767 52%);
     -webkit-transition:background 0.3s ease-in-out;
     -moz-transition:background 0.3s ease-in-out;
     transition:background-color 0.3s ease-in-out;
 }
 input[type="submit"]:active {
     box-shadow:inset 0 1px 3px rgba(0,0,0,0.5);
 }
 </style>
 
 </head>
 <body>
     <div class="wrap">
         <h1><a href="http://www.w3bees.com/2013/02/multiple-file-upload-with-php.html">Multiple File Upload with PHP</a></h1>
         <?php
         # error messages
         if (isset($message)) {
             foreach ($message as $msg) {
                 printf("<p class='status'>%s</p></ br>\n", $msg);
             }
         }
         # success message
         if($count !=0){
             printf("<p class='status'>%d files added successfully!</p>\n", $count);
         }
         ?>
         <p>Max file size 100kb, Valid formats jpg, png, gif</p>
         <br />
         <br />
         <!-- Multiple file upload html form-->
         <form action="" method="post" enctype="multipart/form-data">
             <input type="file" name="files[]" multiple="multiple" accept="image/*">
             <input type="submit" value="Upload">
         </form>
 </div>
 </body>
 </html>

1 svar postet i denne tråd vises herunder
0 indlæg har modtaget i alt 0 karma

Sorter efter stemmer Sorter efter dato

Bruger #17554 @ 22.11.13 13:57

Kan få den til at indsætte, men ikke mere end max 1. Hvis jeg vælger flere, bliver der kun ind lagt ind.

Der skal den indsætte alle "antal" counts, hvor alle får et id af mysql.

Men hvordan.

PHP kode

 if($count !=0){
         
         mysql_query("INSERT INTO `autrailien_billeder` (`FILE_NAME`) VALUES ('$name')");
             printf("<p class='status'>%d files added successfully!</p>\n", $count);
         }

Har nu prøvet således, men den indsætter nu de antal der er valgt.
Men kun samme filname.

Den indsætter ikke filname ud fra de valgte, men blot kun den ene.
Det da noget hø

Kode:

PHP kode

 $f=1;
 while($f<=$count)
   {
   echo "Nummer: $f <br>";
       
         mysql_query("INSERT INTO `autrailien_billeder` (`FILE_NAME`) VALUES ('$name')");
 $f++;
 }

Udskriver nu således:
Nummer: 1 = Koala.jpg
Nummer: 2 = Koala.jpg

Med -> echo "Nummer: $q = $name <br>";

Så der kan man se den kun fanger den ene af $name.

Tror nu jeg fik det løst via else.

PHP kode

 else{ // No error found! Move uploaded files 
                 if(move_uploaded_file($_FILES["files"]["tmp_name"][$f], $path.$name)) {
                     $count++; // Number of successfully uploaded files
                     mysql_query("INSERT INTO `autrailien_billeder` (`FILE_NAME`) VALUES ('$name]')");
                 }

Nu er der begge filname i den, med hver sin id.

Indlæg senest redigeret d. 22.11.2013 15:01 af Bruger #17554

Multi image upload - insert i db.

Karma barometer (30 dage)

Modtaget

Givet

Favorit hos
Forum tråde
Artikler