PHP - Upload Multiple images

Question

Hello,

I created a code where I simply upload multiple images.

But I’m not able to enter the values of the urls 'im/pd/'. $file_name_new; of the variable $file_destination in the comic book.

At DB I have..

User_id | img1 | img2 |

What should I include in the code so that urls are inserted in the database and also how to save the images in the folder.

Code:

  //images function
           $ads_file = mysqli_real_escape_string($con, sanitize($_FILES['img_file']['name'][0]));  

           if(!empty($ads_file)) {

               $files = $_FILES['img_file'];
               $allowed = array('png', 'jpg', 'jpeg', 'gif');

               foreach($files['name'] as $position => $file_name) {

                   $file_tmp = $files['tmp_name'][$position];
                   $file_size = $files['size'][$position];
                   $file_error = $files['error'][$position];

                   $file_ext = explode('.', $file_name);
                   $file_ext = strtolower(end($file_ext));

                   if(in_array($file_ext, $allowed)) {

                        if($file_error === 0) {

                           if($file_size <= 4097152) {

                               $file_name_new = uniqid('', true) . '.' . $file_ext;
                               $file_destination = 'im/pd/'. $file_name_new;

                               $uploaded[$position] = $file_destination;
                               //define o caminho para o folder e para DB

                           } else {
                              $errors[] = "
                              <div class='alert warning'>
                                  <span class='closebtn'>&times;</span>  
                                  <strong><i class='fas fa-file-excel'></i></strong> Esta imagem é demasiado grande.
                              </div>";                               
                           }

                        } else {
                              $errors[] = "
                              <div class='alert warning'>
                                  <span class='closebtn'>&times;</span>  
                                  <strong><i class='fas fa-plug'></i></strong> Falha ao efetuar o upload. Tente novamente...
                              </div>";   
                        }

                   } else {
                         $errors[] = "
                         <div class='alert warning'>
                              <span class='closebtn'>&times;</span>  
                              <strong><i class='fas fa-file-excel'></i></strong> Ficheiro desconhecido, tente outro.
                         </div>";  
                   }
               }

          }  

---

New Error

I used the variables you gave me in relation to

 $praBanco .=" '".$file_destination."', ";

 for ($x = 1; $x <=$quantColunas; $x++) {
   $colunas.=" ads_image_".$x." = ";
}                   
$praBanco = substr($praBanco,0,-1); 
$colunas = substr($colunas,0,-1);

$columns and $praBanco

The problem is that... It does not update because I think something is wrong regarding the update entry.

  $smtp_process = "UPDATE public_ads SET ads_title = '$ads_title', ads_content = '$ads_content', ads_price = '$ads_price', edit_attempts = edit_attempts + 1, $colunas = '$praBanco' WHERE ads_id = '$editor_id'"; 
  $smtp_request_query = $con->query($smtp_process);

But... it does not update or show errors...

I think it’s about this: $columns = '$praBanco'

The goal is that it add in the Database the path of the amount of images uploaded. As was done in INSERT, now click UPLOAD.

Answer 1

The solution is to create a variable $praBanco whose value will serve as VALUES in the statement INSERT

$praBanco .="'".$file_destination."',";

I am doing example with the PHP extension mysqli but you use your.

 <?php

....................
...................
if($file_size <= 4097152) {

    $file_name_new = uniqid('', true) . '.' . $file_ext;
    $file_destination = 'im/pd/'. $file_name_new;

    //vai servir pro VALUES do insert                       
    $praBanco .="'".$file_destination."',";
...................
...................


 if (isset($praBanco)){  

    $conn = new mysqli ("localhost", "USUARIO", "SENHA", "NOME_DB"); 

    //retira ultima virgula     
    $praBanco = substr($praBanco,0,-1);  

    /******* insert no banco ********/
    $sql = "INSERT INTO imagens(img1,img2) VALUES ($praBanco)";
    $qr=mysqli_query($conn,$sql); 
    mysqli_close($conn);

 }
?>

The optimal solution would be like this;

.....................................
.....................................

$files = $_FILES['img_file'];
$allowed = array('png', 'jpg', 'jpeg', 'gif');

 //numero de colunas no banco
 $colBanco=5;

 $j=0;

foreach($files['name'] as $position => $file_name) {

    $file_tmp = $files['tmp_name'][$position];
    $file_size = $files['size'][$position];
    $file_error = $files['error'][$position];

    $file_ext = explode('.', $file_name);
    $file_ext = strtolower(end($file_ext));

    if(in_array($file_ext, $allowed)) {

         if($file_error === 0) {

            if($file_size <= 4097152) {

                $file_name_new = uniqid('', true) . '.' . $file_ext;
                $file_destination = 'im/pd/'. $file_name_new;

                 //limita para a quantidade correspondente ao numero de colunas no banco
                 if ($j<$colBanco){
                    $praBanco .="'".$file_destination."',";
                 }
                 $j++;

                 $uploaded[$position] = $file_destination;
                 //define o caminho para o folder e para DB

.....................................
.....................................

     if (isset($praBanco)){
        /*****************************************************************************/
        //verificamos o numero de imagens para determinar o numero de colunas no banco.

        $quantColunas = substr_count($praBanco, ',');
        /*****************************************************************************/

        /****criamos os nomes das colunas para usar na declaração INSERT *******/
        for ($x = 1; $x <=$quantColunas; $x++) {
            $colunas.="img".$x.",";
        }
        /*****************************************************************************/


        /******* conexão ao banco - exemplo com a extensão do PHP mysqli ********/
        $conn = new mysqli ("localhost", "USUARIO", "SENHA", "NOME_DB");

        /**** retira a ultima virgula *******/     
        $praBanco = substr($praBanco,0,-1); 
        $colunas = substr($colunas,0,-1);
        /***********************************/

        /******* insert no banco ********/
        $sql = "INSERT INTO imagens ($colunas) VALUES ($praBanco)";
        echo $sql;
        $qr=mysqli_query($conn,$sql); 
        mysqli_close($conn);

   } 

In this case it would only save in the bank in MAXIMO until the amount of existing columns

---

_{As requested in the AP comment mas como faço agora para ele MOVER as 2 IMAGENS para a Folder? I edited the question and the answer to cover that situation.}

To save images to folder

just insert into the code move_uploaded_file($file_tmp, $file_destination);

Situations to consider

1 - All images sent by form

................
................
if ($j<$colBanco){
    $praBanco .="'".$file_destination."',";
}
move_uploaded_file($file_tmp, $file_destination)
$j++;
...............
...............

2 - Only those whose urls were saved in the database

Insert the line inside the conditional

................
................
if ($j<$colBanco){
    $praBanco .="'".$file_destination."',";
    move_uploaded_file($file_tmp, $file_destination)
}
$j++;
...............
...............