Coding standards
Security in ResourceSpace
Developer reference
Database
Action functions
Admin functions
Ajax functions
Annotation functions
API functions
Collections functions
Comment functions
Config functions
CSV export functions
Dash functions
Debug functions
Encryption functions
Facial recognition functions
File functions
General functions
Language functions
Log functions
Login functions
Message functions
Migration functions
Node functions
PDF functions
Plugin functions
Render functions
Reporting functions
Request functions
Research functions
Slideshow functions
Theme permission functions
User functions
Video functions
Database functions
Metadata functions
Resource functions
Search functions
Map functions
Job functions
Tab functions
Test functions

get_alternative_files_by_filename()

Description

Search the alternative file records for matching filenames
Alternative files can be optionally filtered by the Resource ID or by collection


resource ID, filename, file size, extension, name, and description

Parameters

ColumnTypeDefaultDescription
$filename string Filename of the alternative file(s) to search for
$collection int Collection ID to filter resources, use 0 to ignore
$min int Minimum Resource ID to consider, use 0 to ignore
$max int new PreparedStatementQuery "SELECT ref Maximum Resource ID to consider, use 0 to ignore
resource
file_name
file_size
file_extension
name
FROM description ?"
["s"
$filename]

Return

array All matching alternative file records with corresponding:

Location

include/resource_functions.php lines 4676 to 4701

Definition

 
function get_alternative_files_by_filename(string $filename, int $collection, int $min, int $max) : array
{
    $sql = new PreparedStatementQuery(
        "SELECT ref, resource, file_name, file_size, file_extension, name, description FROM resource_alt_files WHERE file_name = ?",
        ["s", $filename]
    );

    if ($collection) {
        $sql->sql .= " AND resource IN (SELECT resource FROM collection_resource WHERE collection = ?)";
        $sql->parameters[] = "i";
        $sql->parameters[] = $collection;
    } elseif ($min || $max) {
        if ($min) {
            $sql->sql .= " AND resource >= ?";
            $sql->parameters[] = "i";
            $sql->parameters[] = $min;
        }
        if ($max) {
            $sql->sql .= " AND resource <= ?";
            $sql->parameters[] = "i";
            $sql->parameters[] = $max;
        }
    }

    return ps_query($sql->sql, $sql->parameters);
}

This article was last updated 7th May 2026 14:35 Europe/London time based on the source file dated 7th May 2026 11:10 Europe/London time.