Image gallery - filtering results based on category

Fri, 11 Nov 2016 19:46:20 -0800

Fantastic! I updated the link code for the gallery categories to the below and now it all works perfectly. Thanks for your help :)

">

Image gallery - filtering results based on category

Fri, 11 Nov 2016 11:02:18 -0800

Thanks for posting your files.

I have two recommendations.

1. On your gallery_.php page, look for

'allowSearch' => false,

and change it to:

'allowSearch' => true,

That will let you link to gallery_.php with variables in the URL like: gallery_.php?gallery=gallery

2. In your gallery schema, change the "Use this field for option values" for your "Category" drop down to "num" instead of title. This change gets made in CMS Builder (don't just edit your schema).

That should get you sorted out.

Let me know how you make out.

Thanks!

Image gallery - filtering results based on category

Thu, 10 Nov 2016 15:29:35 -0800

Thanks Ross. Please see below

gallery.php

/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */ // load viewer library $libraryPath = 'cms/lib/viewer_functions.php'; $dirsToCheck = array('/home/thth3571/public_html/','','../','../../','../../../'); foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }} if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); } // load records from 'gallery2' list($gallery2Records, $gallery2MetaData) = getRecords(array( 'tableName' => 'gallery2', 'loadUploads' => true, 'allowSearch' => false, )); ?> Home http://www.thenelunefoundation.org/new/assets/magnific-popup/magnific-popup.css"> http://www.thenelunefoundation.org/new/assets/magnific-popup/jquery.magnific-popup.js">


 
 
 
 
 
 
 
 
 
 
 
  
 
 About

 Projects

 Sponsors

                        News

                        Events

                        Gallery

                        Contact
 
 
 
 How to help

 Donate




    

 GALLERY
 

Pictures from our recent charity events

 

                
                

">









                
                
                     
        
        
        
        
        





 





 
 
 
 
                 
 
The NELUNE Foundation

PO Box 1033,

Spit Junction 2088 NSW

Media Enquiries:

Marketing Manager

NELUNE Foundation

info@thenelunefoundation.org

02 8082 8199




 https://www.facebook.com/nelunefoundation/">

 http://twitter.com/NeluneR">

 http://www.youtube.com/channel/UCVutWJqVU8Jw0-U7MZOiAQg?feature=watch">



          
                
                

 

 
                
                
 
 
        
        
 © 
  document.write(new Date().getFullYear());
 The NELUNE Foundation. All rights reserved

gallery_.php


 
 
 
 
 
 
 
 
 
 
 
  
 
 About

 Projects

 Sponsors

                        News

                        Events

                        Gallery

                        Contact
 
 
 
 How to help

 Donate




    
 GALLERY                



 



 
                

 - 
Date: 

Location: 

Photographer credit: 



  
   


 $upload): ?>

" title="">" height="100" />




      
       
$('.gallery').each(function() { // the containers for all your galleries
    $(this).magnificPopup({
        delegate: 'a', // the selector for gallery item
        type: 'image',
        gallery: {
          enabled:true
        }
    });
});
    



 
                





            
             


 
                
                
                     
        
        
        
        
        





 





 
 
 
 
                 
 
The NELUNE Foundation

PO Box 1033,

Spit Junction 2088 NSW

Media Enquiries:

Marketing Manager

NELUNE Foundation

info@thenelunefoundation.org

02 8082 8199




 https://www.facebook.com/nelunefoundation/">

 http://twitter.com/NeluneR">

 http://www.youtube.com/channel/UCVutWJqVU8Jw0-U7MZOiAQg?feature=watch">



          
                
                

 

 
                
                
 
 
        
        
 © 
  document.write(new Date().getFullYear());
 The NELUNE Foundation. All rights reserved

Gallery categories schema

return array ( '_detailPage' => '', '_disableAdd' => '0', '_disableErase' => '0', '_disableView' => '1', '_filenameFields' => 'title', '_hideRecordsFromDisabledAccounts' => '0', '_listPage' => '', '_maxRecords' => '', '_maxRecordsPerUser' => '', '_tableName' => 'gallery_categories', 'listPageFields' => 'dragSortOrder, title', 'listPageOrder' => 'dragSortOrder DESC', 'listPageSearchFields' => '_all_', 'menuName' => 'Gallery categories', 'menuOrder' => 1478666474, 'menuType' => 'multi', 'num' => array( 'order' => '1', 'type' => 'none', 'label' => 'Record Number', 'isSystemField' => '1', ), 'createdDate' => array( 'order' => '2', 'type' => 'none', 'label' => 'Created', 'isSystemField' => '1', ), 'createdByUserNum' => array( 'order' => '3', 'type' => 'none', 'label' => 'Created By', 'isSystemField' => '1', ), 'updatedDate' => array( 'order' => '4', 'type' => 'none', 'label' => 'Last Updated', 'isSystemField' => '1', ), 'updatedByUserNum' => array( 'order' => '5', 'type' => 'none', 'label' => 'Last Updated By', 'isSystemField' => '1', ), 'dragSortOrder' => array( 'order' => '6', 'label' => 'Order', 'type' => 'none', ), 'title' => array( 'order' => '7', 'label' => 'Title', 'type' => 'textfield', 'defaultValue' => '', 'description' => '', 'fieldWidth' => '', 'isPasswordField' => '0', 'isRequired' => '1', 'isUnique' => '0', 'minLength' => '', 'maxLength' => '', 'charsetRule' => '', 'charset' => '', ), ); ?>

Gallery schema

return array ( '_detailPage' => '/new/gallery_.php', '_disableAdd' => '0', '_disableErase' => '0', '_disableModify' => '0', '_disablePreview' => '0', '_disableView' => '1', '_filenameFields' => 'category, subcategory', '_hideRecordsFromDisabledAccounts' => '0', '_indent' => '0', '_listPage' => '', '_maxRecords' => '', '_maxRecordsPerUser' => '', '_perPageDefault' => '25', '_previewPage' => '', '_requiredPlugins' => '', '_tableName' => 'gallery2', 'listPageFields' => 'dragSortOrder, Category, subcategory', 'listPageOrder' => 'dragSortOrder DESC', 'listPageSearchFields' => '_all_', 'menuHidden' => '0', 'menuName' => 'Gallery', 'menuOrder' => '0000000020', 'menuType' => 'multi', 'num' => array( 'order' => 1, 'type' => 'none', 'label' => 'Record Number', 'isSystemField' => '1', ), 'createdDate' => array( 'order' => 2, 'type' => 'none', 'label' => 'Created', 'isSystemField' => '1', ), 'createdByUserNum' => array( 'order' => 3, 'type' => 'none', 'label' => 'Created By', 'isSystemField' => '1', ), 'updatedDate' => array( 'order' => 4, 'type' => 'none', 'label' => 'Last Updated', 'isSystemField' => '1', ), 'updatedByUserNum' => array( 'order' => 5, 'type' => 'none', 'label' => 'Last Updated By', 'isSystemField' => '1', ), 'category' => array( 'order' => '6', 'label' => 'Category', 'type' => 'list', 'defaultValue' => '', 'fieldPrefix' => '', 'description' => '', 'isRequired' => '0', 'isUnique' => '0', 'listType' => 'pulldown', 'optionsType' => 'table', 'optionsTablename' => 'gallery_categories', 'optionsValueField' => 'title', 'optionsLabelField' => 'title', ), 'dragSortOrder' => array( 'order' => 7, 'label' => 'Order', 'type' => 'none', ), 'subcategory' => array( 'order' => '8', 'label' => 'Sub category', 'type' => 'textfield', 'defaultValue' => '', 'fieldPrefix' => '', 'description' => '', 'fieldWidth' => '', 'isPasswordField' => '0', 'isRequired' => '1', 'isUnique' => '0', 'minLength' => '', 'maxLength' => '', 'charsetRule' => '', 'charset' => '', ), 'date' => array( 'order' => 9, 'label' => 'Date', 'type' => 'date', 'fieldPrefix' => '', 'description' => '', 'isRequired' => '0', 'isUnique' => '0', 'defaultDate' => '', 'defaultDateString' => '2016-01-01 00:00:00', 'showTime' => '0', 'showSeconds' => '0', 'use24HourFormat' => '0', 'yearRangeStart' => '', 'yearRangeEnd' => '', ), 'location' => array( 'order' => 10, 'label' => 'Location', 'type' => 'textfield', 'defaultValue' => '', 'fieldPrefix' => '', 'description' => '', 'fieldWidth' => '', 'isPasswordField' => '0', 'isRequired' => '0', 'isUnique' => '0', 'minLength' => '', 'maxLength' => '', 'charsetRule' => '', 'charset' => '', ), 'photographer_credit' => array( 'order' => 11, 'label' => 'Photographer credit', 'type' => 'textfield', 'defaultValue' => '', 'fieldPrefix' => '', 'description' => '', 'fieldWidth' => '', 'isPasswordField' => '0', 'isRequired' => '0', 'isUnique' => '0', 'minLength' => '', 'maxLength' => '', 'charsetRule' => '', 'charset' => '', ), 'comments' => array( 'order' => 12, 'label' => 'Comments', 'type' => 'textbox', 'defaultContent' => '', 'fieldPrefix' => '', 'description' => '', 'isRequired' => '0', 'isUnique' => '0', 'minLength' => '', 'maxLength' => '', 'fieldHeight' => '', 'autoFormat' => '1', ), 'photos' => array( 'order' => 13, 'label' => 'Photos', 'type' => 'upload', 'fieldPrefix' => '', 'description' => '', 'isRequired' => '0', 'allowedExtensions' => 'gif,jpg,png,wmv,mov,swf,pdf', 'checkMaxUploadSize' => '1', 'maxUploadSizeKB' => '5120', 'checkMaxUploads' => '1', 'maxUploads' => '25', 'resizeOversizedImages' => '1', 'maxImageHeight' => '800', 'maxImageWidth' => '600', 'createThumbnails' => '1', 'maxThumbnailHeight' => '150', 'maxThumbnailWidth' => '150', 'createThumbnails2' => '0', 'maxThumbnailHeight2' => '150', 'maxThumbnailWidth2' => '150', 'createThumbnails3' => '0', 'maxThumbnailHeight3' => '150', 'maxThumbnailWidth3' => '150', 'createThumbnails4' => '0', 'maxThumbnailHeight4' => '150', 'maxThumbnailWidth4' => '150', 'useCustomUploadDir' => '0', 'customUploadDir' => '', 'customUploadUrl' => '', 'infoField1' => '', 'infoField2' => '', 'infoField3' => '', 'infoField4' => '', 'infoField5' => '', ), ); ?>

Image gallery - filtering results based on category

Thu, 10 Nov 2016 12:53:54 -0800

Hi there.

Thanks for posting

Could you post a copy of both your pages (not just a link to them) so I can review the code?

Also, if you know how, could you post a copy of the schema files for your two sections. They will be in /data/schemas/. Having the schemas gives me more options on narrowing everything down. The schemas aren't required though so if it doesn't work to post them, don't worry; I can still work with just the pages.

Thanks!

Image gallery - filtering results based on category

Wed, 09 Nov 2016 19:45:56 -0800

I am trying to create an image gallery that has a main category, and a list of sub items underneath each e.g.

The Lilac Ball
- 2016
- 2015

News and Media
- Something
- Something else

On the gallery page, I want to list the main categories only, and then when you click on that link you will see the items under it eg

>> on main gallery page

The Lilac Ball
News and Media

>> Once you have clicked on one of the above, The Lilac Ball for example you'd see:

2016
2015

I've created 2 sections in CMBS. Gallery categories (the main category) and Gallery.

GC is a list of category names that I am pulling into a dropdown field in the Gallery section. This is so the website owner can add new categories later themselves.

I have created a gallery page that lists the gallery categories (using the gallery section, not the GC section) and then added the link. I also created a list page for the gallery section to list all the items. It is currently not working though and is listing all of the items from every category no matter what you click on.

Can anyone give me a heads up to the code I'm missing? I thought I could append something like category_keyword=The%20Lilac%20Ball to the URL but that didn't work either. Ideally it would be done dynamically in the page because I'd like the site owner to be able to add new categories without me having to make updates for them

Here are my pages so far:
http://www.thenelunefoundation.org/new/gallery.php
http://www.thenelunefoundation.org/new/gallery_.php

If the title on gallery_.php could also update to whatever category you had clicked on, that would be awesome but if it's too tricky it's no biggy