script to display list of files with a particular string matching,plus a few things

The goal from @arvindikchari is straightforward: scan a folder, pick files whose base name ends with one of a small list of suffixes provided at runtime, extract the prefix (the part before that suffix) and store results in two tables. @JoshConnerty was right to point toward filesystem + string parsing; @Member#120589 pushed for doing some work yourself — below is a compact, practical example that does the heavy lifting, uses safe DB practices and notes a few edge cases to watch for.

This example treats the suffix match against the filename without its final extension (so abcpdf.zip -> base abcpdf -> suffix pdf -> prefix abc). It uses prepared statements via PDO, wraps inserts in a transaction, and avoids duplicate prefixes by relying on a UNIQUE key on A.prefix.

<?php
// config
$dir = __DIR__ . '/files';
$suffixString = 'pdf,txt'; // replace with runtime input (POST/CLI)
$suffixes = array_filter(array_map('strtolower', array_map('trim', explode(',', $suffixString))));

// DB (set your host/db/user/pass)
$pdo = new PDO('mysql:host=127.0.0.1;dbname=yourdb;charset=utf8mb4','dbuser','dbpass',[
  PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
]);

$insA = $pdo->prepare('INSERT INTO A (prefix) VALUES (:prefix) ON DUPLICATE KEY UPDATE id=id');
$insB = $pdo->prepare('INSERT INTO B (filename, prefix, suffix) VALUES (:filename, :prefix, :suffix)');

$pdo->beginTransaction();
foreach (new DirectoryIterator($dir) as $f) {
  if (!$f->isFile()) continue;
  $filename = $f->getFilename();
  $base = pathinfo($filename, PATHINFO_FILENAME); // excludes final extension
  $lower = strtolower($base);
  foreach ($suffixes as $s) {
    if ($s === '') continue;
    $ls = strlen($s);
    if ($ls <= strlen($lower) && substr($lower, -$ls) === $s) {
      $prefix = substr($base, 0, -$ls);
      $insA->execute([':prefix'=>$prefix]);
      $insB->execute([':filename'=>$filename, ':prefix'=>$prefix, ':suffix'=>$s]);
      break;
    }
  }
}
$pdo->commit();

Notes and troubleshooting: ensure PHP can read the directory and file names (permissions), set the correct charset on PDO, and add a UNIQUE index on A.prefix to avoid duplicate entries. For large directories consider batching/inserting outside a transaction or using LOAD DATA for B. For background reading on the APIs used, see the PDO and DirectoryIterator docs: PDO and DirectoryIterator.