Collections functions
General functions
Render functions
Theme permission functions
User 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 3306 to 3320

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 10th December 2023 07:05 Europe/London time based on the source file dated 21st November 2023 15:25 Europe/London time.