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
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
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
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
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
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 - edited: May 1, 2013
Hi Jerry
When I read in your post :" multi-value" everything made sense. My mistake was using a simple pull-down list, instead of a pull-down (multi value) list. Now, it displays more than one logo. http://www.fecofutsalon.com/logotestdetail.php Thanks for that.
I have another question, is it possible to show several programs in the logotestdetail.php page?
Carlos Pinedo