Collections functions
General functions
Render functions
Theme permission functions
Resource functions

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 3238 to 3252

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(0count($colresources), '(?, ?)')),
        
$params
    
);
    }

This article was last updated 3rd February 2023 16:35 Europe/London time based on the source file dated 1st February 2023 15:00 Europe/London time.