Importer images dans BDD

Bonjour à tous,


Voilà 2 semaines que je bloque pour importer des images dans ma base de données.
Lorsqu'avec un code similaire je souhaite importer une seule image, cela fonctionne.
Cependant dès que je mets le 'INSERT INTO' dans la boucle foreach, cela ne fonctionne pas.


Voici le code que j'ai, sachant que les fonctions postImagesToDimensions() et postThumbToDimensions() sont deux fonctions me permettant d'importer l'image sur le serveur, de les redimentionner, les compresser et les renommer en 001.jpg, 002.jpg etc... De plus elles me retournent le chemin du fichier image, chemin qui est sensé lui aussi s'importer dans l'une des colonnes de ma BDD.

            <form method="post" id="form-ajout" enctype="multipart/form-data">
                <div>
                    <label for="nom_album">Nom de l'album</label><br>
                    <input type="text" name="nom_album" id="nom_album"><br>
                    <label for="date_photos"><strong>Date des photos</strong></label><br>
                    <input type="date" name="date_photos" id="date_photos"><br>
                    <label for="photos_album">Choisir des images</label><br>
                    <input type="file" name="photos_album[]" multiple accept="image/png, image/jpeg"><br>
                </div>
                <div class="ajouter_button">
                    <input type="submit" name="ajouter_album" id="ajouter_album" value="Ajouter">
                </div>
            </form>

<?php
if(!empty($_POST['ajouter_album'])){
    if(isset($_POST['nom_album'], $_POST['date_photos']) && !empty($_POST['nom_album']) && !empty($_POST['date_photos'])){
        foreach($_FILES['photos_album']['tmp_name'] as $key=>$tmp_name){
            $nom_album = htmlspecialchars(strip_tags($_POST['nom_album']));            
            $date_album_sql = $_POST['date_photos'];
            $date_album = date('Y.m.d', strtotime($_POST['date_photos']));
            $path = 'img/galeries/'.$date_album.'/';
            $path_min = $path.'min/';
            if(!is_dir($path)) mkdir($path);   
            if(!is_dir($path_min)) mkdir($path_min);
            postImagesToDimensions('photos_album', str_pad($key, 3, 0, STR_PAD_LEFT).'.jpg', $path, '1920', '1280', $key);
            postThumbToDimensions('photos_album', 'min_'.str_pad($key, 3, 0, STR_PAD_LEFT).'.jpg', $path_min, '300', '200', $key);
            $photo = postImagesToDimensions('photos_album', str_pad($key, 3, 0, STR_PAD_LEFT).'.jpg', $path, '1980', '1280', $key);
            $photo_min = postThumbToDimensions('photos_album', 'min_'.str_pad($key, 3, 0, STR_PAD_LEFT).'.jpg', $path_min, '300', '200', $key);
            $sql_photos = "INSERT INTO `photos` (`album`, `date_album`, `photo`, `photo_min`)
                           VALUES (:album, :date_album, :photo, :photo_min)";
            $query_photo = $db->prepare($sql_photo);
            $query_photo->bindValue(":album", $nom_album, PDO::PARAM_STR);
            $query_photo->bindValue(":date_album", $date_album_sql, PDO::PARAM_STR);
            $query_photo->bindValue(":photo", $photo, PDO::PARAM_STR);
            $query_photo->bindValue(":photo_min", $photo_min, PDO::PARAM_STR);
        }
        if(!$query_photo->execute()){
            echo '<script language="javascript">';
            echo 'alert("Erreur d\'insertion dans la base de données !")';
            echo '</script>';
        } else{
            echo '<script language="javascript">';
            echo 'alert("Album photos ajouté !")';
            echo '</script>';
        }
    
    } else {
        echo '<script language="javascript">';
        echo 'alert("Le formulaire est incomplet !")';
        echo '</script>';
    }
}
?>

Je vous remercie beaucoup par avance pour vos lumières !!

Si besoin, les fonctions précédemment expliquées :

function postImagesToDimensions($name_form, $new_name, $path, $new_width, $new_height, $i){ 
    $image_tmp = $_FILES[$name_form]['tmp_name'][$i];
    $image_dest = $path.$new_name;
    copy($image_tmp, $image_dest);
    $save = $image_dest;
    $file = $image_dest;
    list($width, $height) = getimagesize($file);
    $ratio = $width / $height;
    $new_ratio = $new_width/$new_height;
        if($ratio <= $new_ratio){
            $new_height = $new_width/$ratio;
        }else{
            $new_width = $ratio*$new_height;
        }
    $tn = imagecreatetruecolor($new_width, $new_height);
    $info = getimagesize($image_dest);
        if ($info['mime'] == 'image/jpeg'){
        $image = imagecreatefromjpeg($file);
        }elseif ($info['mime'] == 'image/gif'){
        $image = imagecreatefromgif($file);
        }elseif ($info['mime'] == 'image/png'){
        $image = imagecreatefrompng($file);
        }
    imagecopyresampled($tn, $image, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
    imagejpeg($tn, $save, 80);
    return $image_dest;
};

function postThumbToDimensions($name_form, $new_name, $path, $new_width, $new_height, $i){ 
    $image_tmp = $_FILES[$name_form]['tmp_name'][$i];
    $image_dest_min = $path.$new_name;
    move_uploaded_file($image_tmp, $image_dest_min);
    $save = $image_dest_min;
    $file = $image_dest_min;
    list($width, $height) = getimagesize($file);
    $ratio = $width / $height;
    $new_ratio = $new_width/$new_height;
        if($ratio <= $new_ratio){
            $new_height = $new_width/$ratio;
        }else{
            $new_width = $ratio*$new_height;
        }
    $tn = imagecreatetruecolor($new_width, $new_height);
    $info = getimagesize($image_dest_min);
        if ($info['mime'] == 'image/jpeg'){
        $image_min = imagecreatefromjpeg($file);
        }elseif ($info['mime'] == 'image/gif'){
        $image_min = imagecreatefromgif($file);
        }elseif ($info['mime'] == 'image/png'){
        $image_min = imagecreatefrompng($file);
        }
    imagecopyresampled($tn, $image_min, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
    imagejpeg($tn, $save, 80);
    return $image_dest_min;
};

Configuration: Windows / Chrome 102.0.0.0