relate_to_collection()

Description

Relates every resource in $collection to $ref

Parameters

ColumnTypeDefaultDescription
$ref integer
$collection integer

Return

void

Location

include/collections_functions.php lines 3076 to 3089

Definition

 
function relate_to_collection($ref, $collection)
{
    $colresources = get_collection_resources($collection);
    ps_query("delete from resource_related where resource= ? and related in (" . ps_param_insert(count($colresources)) . ")", array_merge(['i', $ref], ps_param_fill($colresources, 'i')));
    $params = [];
    foreach ($colresources as $colresource) {
        $params = array_merge($params, ['i', $ref, 'i', $colresource]);
    }
    ps_query(
        "INSERT INTO resource_related (resource,related) 
            VALUES " . implode(', ', array_fill(0, count($colresources), '(?, ?)')),
        $params
    );
}

This article was last updated 3rd June 2025 21:35 Europe/London time based on the source file dated 3rd June 2025 16:40 Europe/London time.