Delete files that are not referenced from database

deleteUnusedImages.php

<?php
// Delete image files in image/product/ folder that do not exist in database table products_photos, column photo
$directoryPath = 'c:/xampp_8_2_12/htdocs/image/product/';
$removePath = 'c:/xampp_8_2_12/htdocs';
$filesAndFolders = glob($directoryPath . '*'); // Note that some files don't have a file extension
$filesNotExistingInDatabase = array();
$counter = 0;
// Part of the path to remove
foreach ($filesAndFolders as $i => $absolutePath) {
    if (is_file($absolutePath)) { // exclude directories
        $relativePath = str_replace($removePath, '', $absolutePath);
        //$imageFileName = '/image/product/img-20220505-wa0010-jpg.jpg';
        $query = "SELECT * FROM products_photos WHERE photo='" . $relativePath . "'";
        $result = $db->query($query)->rows;
        if (sizeof($result) < 1) {
            $counter++;
            echo $counter . ". " . $relativePath . " does not exist in products_photos table<br>";
            $filesNotExistingInDatabase[] = $relativePath;
            if (unlink($absolutePath)) {
                echo "The file was successfully deleted.<br>";
            } else {
                echo "There was an error deleting the file.<br>";
            }
        }
    }
}
echo "sizeof(filesNotExistingInDatabase): " . sizeof($filesNotExistingInDatabase);