Display variable only once on a foreach and count total rows of an IF

Question

I have a script, which basically compares the files of a bank table with the files of a directory, and it shows the files that are NOT in the database and are in the directory.

I have 2 problems:

1. Count the amount of files that nay are in the bank and are in the directory
2. Display message with this amount, only once inside the foreach

---

Code I am using:

    <?php
    include('menu.php'); include('connect.php'); 

    $files = glob("teste-uploads/*.{pdf,jpg,png}", GLOB_BRACE);  // Encontra nomes dos arquivos de determinada pasta e salva no array $files

    $Busca_Imagens = mysqli_query($con,"SELECT fotos FROM teste");  // Busca nome das imagens no seu Banco de Dados

    while($Checa_Imagens = mysqli_fetch_assoc($Busca_Imagens)){

    $images[] = 'teste-uploads/' . $Checa_Imagens['fotos'];
          };

    foreach($files as $file){
    if(!in_array($file, $images)){

    echo "Cerca de <b>" .count($file). "</b> arquivo(s) que não estão no banco de dados <p></p>"; // Número total

    echo "<b>" . $file . "</b><br>"; // Exibe os arquivos
    }}?>

The problem is that it is not counting correctly and the phrase "About ..." is repeating itself to each file.

Answer 1

There are several problems in its implementation:

1. It is not counting correctly, because each iteration has only 1 same;
2. The phrase is repeating itself because it is inside the loop; You can solve this by putting the phrase into a variable to be concatenated, and initiating a counter out of the loop:

// Encontra nomes dos arquivos de determinada pasta e salva no array $files
$files = glob("teste-uploads/*.{pdf,jpg,png}", GLOB_BRACE);

// Busca nome das imagens no seu Banco de Dados
$Busca_Imagens = mysqli_query($con,"SELECT fotos FROM teste");  

while ($Checa_Imagens = mysqli_fetch_assoc($Busca_Imagens)) {
    $images[] = 'teste-uploads/' . $Checa_Imagens['fotos'];
}
$contador = 0;
$html = '';
foreach ($files as $file) {
  if (!in_array($file, $images)) {
    // Número total
    $contador++;
    $html .= "<b>" . $file . "</b><br>"; 
  }
}
echo 'Cerca de <b>' . $contador . '</b> arquivo(s) que não estão no banco de dados <p></p>';

// Exibe os arquivos
echo $html;