Delete Duplicate records from Database in PHP

I am reading image files from a folder and save the results in the database. There are multiple duplicate images in a folder (same image but different filename).
I am getting md5 of a file to marked the file as duplicate.

While saving the records in database how I can ignore the duplicate files to not save in Database.

This is my code:

<?php

require_once 'db.php';

$dir = '../../../../../sites/default/files/';


$exts = array('gif', 'jpg', 'jpeg', 'png');

if ( is_dir($dir) ):

    // Set up the Iterator
    
	$directory = new RecursiveDirectoryIterator($dir, FilesystemIterator::SKIP_DOTS); //skip dots and double dots hidden folders
    $iterator = new RecursiveIteratorIterator($directory);


    // Clear the table
    $conn->query("TRUNCATE TABLE searchindex_images");
    // Prepare the INSERT query   
	$insert = $conn->prepare("INSERT INTO searchindex_images (dir, img_names, lang,file_date) VALUES (? , ? , ? , ?)");
   
	$insert->bind_param("ssss", $path, $img, $language,$myhash);   	
	
	
	
$foldersToSkip = ['css','default_images','docs'];

foreach ($iterator as $file):
    $folders = explode( DIRECTORY_SEPARATOR, $file->getPath() ); // split the path into an array.	

    if ( ! empty( array_intersect($foldersToSkip, $folders) ) ) { // see if any folder is matched with $foldersToSkip
        // let's skip this folder
		print "<br>Folder SKipped";
        continue;
    }
	else{
		
			//// This code only works on Linux OS. It checks for arabic characters in filenames ///// 
			$match = preg_match( "/\p{Arabic}/u", $img ); // see if we have Arabic characters
			$language = $match ? "Arabic" : "English"; // if $match is true, set $language to Arabic, otherwise set it to English
									////// CODE ENDS /////////				
				
			
			$path = $file->getPath().'/'; // Get the path
			$img = $file->getFilename(); // Get the filename
			$file_date = $file->getMTime(); // Get the filename
			$file_date_c = $file->getCTime(); // Get the filename
			$myhash = md5_file($path.$img );

            $insert->execute(); // Run the query
            echo "<br>{$path}"; // Output the filename
			echo "<br>{$img}<br>"; // Output the filename					
			
			echo "<br>FILE HASH = ".$myhash;



			echo "<br>===================================";	
	}

    


endforeach;   

else:

    echo "Directory not found!";

endif;				
				
?>

Select allOpen in new window