在drupal中查找文件路径

drush sql-query --query="SELECT filename FROM file_managed WHERE uri LIKE '%example.com/path/%'"

$result = db_query("SELECT filename FROM {file_managed} WHERE uri LIKE '%example.com/path/%'");
while ($row = $result->fetchAssoc()) {
  $file_paths[] = $row['filename'];
}

function mymodule_form_alter(&$form, &$form_state, $form_id) {
  if ($form_id == 'file_managed_form') {
    $form['actions']['submit']['#value'] = 'Upload';
    $form['actions']['submit']['#submit'][] = 'mymodule_submit';
  }
}

function mymodule_submit($form, &$form_state) {
  $files = file_get_uploads();
  foreach ($files as $file) {
    $file_path = $file->uri;
    // Do something with the file path
  }
}