Upload multiple images to Amazon S3 bucket and MySql database

This is the complete block of code that will loop through multiple images and insert valid images in your database and your s3 bucket. Rember to change AWS KEY, AWS SECRET KEY and AWS S3 BUCKET.

Another issue to consider is the total size of images being uploaded. You might have to increse php_value post_max_size and php_value upload_max_filesize in the php.ini file on your server. If you do not have access to this file you can increse this on your .htaccess file by adding these 2 lines of code.

                
                php_value post_max_size 64M
                php_value upload_max_filesize 64M
                
            

                
                require '../../../vendor/autoload.php';
                define("IMAGE_URL", "https://codercasts.s3.eu-west-1.amazonaws.com/");

                if(isset($_POST['submit']))
                    {
                        $allowedFileType = array('JPG', 'PNG', 'JPEG', 'jpg', 'jpeg', 'png', 'gif');
                        
                        // Velidate if files exist
                        if (!empty(array_filter($_FILES['img']['name']))) 
                            {
                                // Loop through file items
                                foreach($_FILES['img']['name'] as $id=>$val)
                                    {
                                        // Get files upload path
                                        $img        = $_FILES['img']['name'][$id];
                                        $tempLocation    = $_FILES['img']['tmp_name'][$id];
                                        $targetFilePath  = $img;
                                        $fileType        = strtolower(pathinfo($targetFilePath, PATHINFO_EXTENSION));

                                        if(in_array($fileType, $allowedFileType))
                                            {
                                                $sql = "INSERT INTO images (img) VALUES (:img)";
                                                $statement = $db->prepare($sql);
                                                $statement->bindParam(':img'	,	$img  , PDO::PARAM_STR);
                                                try
                                                    {
                                                        $statement->execute();
                                                        $success = "Upload successful";
                                                    }
                                                catch(PDOException $e)
                                                    {
                                                        echo $e;
                                                        $failed = "There was an issue, please try again";
                                                    }
                                            }
                                        else
                                            {
                                                $error = "Only .jpg, .jpeg and .png file formats allowed.";
                                            }
                                        
                                        
                                        if(in_array($fileType, $allowedFileType))
                                            {
                                                $s3 = new Aws\S3\S3Client([
                                                    'region'  => 'eu-west-1',
                                                    'version' => 'latest',
                                                    'credentials' => [
                                                        'key'    => "AWS KEY",
                                                        'secret' => "AWS SECRET KEY",
                                                    ]
                                                ]);		
                                                try
                                                    {
                                                        $result = $s3->putObject([
                                                        'Bucket' => 'AWS S3 BUCKET',
                                                        'Key'    => $img,
                                                        'SourceFile' => $tempLocation,
                                                        'ACL'    => 'public-read',
                                                        'ContentType' => 'image/png'		
                                                        ]);
                                                    }
                                                catch(S3Exception $e)
                                                    {
                                                        echo $e;
                                                    }
                                                $uploaded_images = $result['ObjectURL'] . PHP_EOL;
                                            } 
                                        else 
                                            {
                                                $response = array(
                                                    "status" => "alert-danger",
                                                    "message" => "Only .jpg, .jpeg and .png file formats allowed."
                                                );
                                            }
                                    }
                            } 
                    }    
                
            

Place this block of code above the form in php tags to alert message after submit is selected.

                
                    if(isset($success))
                        {
                            echo $success;
                        }
                    if(isset($failed))
                        {
                            echo $failed;
                        }
                    if(isset($error))
                        {
                            echo $error;
                        }
                
            

Form to select and submit multiple images

                
                    <form action=" $_SERVER["PHP_SELF"] " method="post" enctype="multipart/form-data"> 
                        <div class="form-group">
                            <label>Image</label>
                            <input type="file" name="img[]" class="form-control" multiple>
                        </div>
                        <button name="submit" class="btn btn-info btn-block">Submit</button>
                    </form>