Replace filepath with dbfas id

gistfile1.txt

<?php 

$objResult = Database::getInstance()->prepare('SELECT * FROM XXXX') ->execute();

while($objResult->next())
{
    $objTlFiles = Database::getInstance()
            ->prepare('SELECT * FROM tl_files WHERE path=?')
            ->execute($objResult->image);
    
    if($objTlFiles->numRows == 0)
    {
        continue;
    }
    
    Database::getInstance()
            ->prepare('UPDATE XXXX SET image=? WHERE id=?')
            ->execute($objTlFiles->id, $objResult->id);
}