MASTER IMAGE LIBRARY. An editor with images that i can select later through a list that get options from a database.

9 posts by 2 authors in: Forums > CMS Builder
Last Post: May 1, 2013   (RSS)

By carlos.pinedo - April 30, 2013 - edited: April 30, 2013

HI, 

I've been trying to create a MASTER IMAGE LIBRARY. An editor with images that i can select later through a list that get options from a database.

I tried a solution posted in this link: http://www.interactivetools.com/forum/forum-posts.php?postNum=2211115#post2211115  . It worked. But i can´t increase the number of records. I changed the 'limit' number but, still, it just shows the first record:  http://www.fecofutsalon.com/logotestdetail.php

This is the code in the detail page. How can increase the record numbers?

list($programsRecords, $programsMetaData) = getRecords(array(
'tableName' => 'programs',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$programsRecord = @$programsRecords[0]; // get first record
?>

<?php //display logos selected from list in other table, note both tables have same field name of 'logos'
$numsTabbedList = $programsRecord['logos'];
$numsTabbedList = trim($numsTabbedList);
$numsCommaList = str_replace("\t", ",", $numsTabbedList);
if ($numsCommaList) {
list($logo_uploadsRecords,) = getRecords(array(
'tableName' => 'logo_uploads',
'where' => "num IN ($numsCommaList)",
'allowSearch' => '0',
));
}
else { $logo_uploadsRecords = array(); // empty array

By gkornbluth - April 30, 2013

Hi Carlos,

Did you download the zip file at http://www.thecmsbcookbook.com/downloads/logos.zip and use the files provided?

What results did you get?

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By carlos.pinedo - May 1, 2013

Hi Jerry, 

Yes I used that zip file. It works,  but i´m having some difficulties increasing the limit of records.  I changed the 'limit' number but, still, it just shows the first record:  http://www.fecofutsalon.com/logotestdetail.php

Carlos

By gkornbluth - May 1, 2013

Carlos,

Could you explain what you mean by "increase the limit of records"?

Do you mean that you want to show more than one logo on the detail page?

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By carlos.pinedo - May 1, 2013

Exactly, I want to display more than one logo on the detail page.

Carlos

By gkornbluth - May 1, 2013

Now I understand.

I'm not sure how to do that, but will look at it as soon as I can.

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By carlos.pinedo - May 1, 2013

Thanks Jerry!

Carlos

By gkornbluth - May 1, 2013

Hi Carlos,

I just checked the demo installation of the master image library files at http://thecmsbcookbook.com/logotestlist.php. Program 1 shows 2 images and program 2 shows only 1 image.

This corresponds to the number of logos selected in the multi-value "logos" list for each record.

You should get the same results with test files that you create from the zip file.

If you do, then the issue is somewhere in your other code. Possibly with an 'allowSearch' value.

Let me know how you make out.

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php