Undefined Variable Error
7 posts by 3 authors in: Forums > CMS Builder
Last Post: May 12, 2011 (RSS)
By dccreatives - May 11, 2011 - edited: May 11, 2011
I want to have the page call the mounting in the title of my page.
I inserted this code on the top of the page:
<?php echo $galleryRecord['mounting'] ?> Gallery Images
I am getting the following error: Notice: Undefined variable: galleryRecord in /services/webpages/a/x/axislighting.com/public/CMS/GalleryList.php on line 98 Gallery Images
I used this syntax for most of my pages and I never got an error.
Please advise.
I uploaded the file and here it is online:
http://www.axislighting.com/CMS/GalleryList.php?mounting=pendant
Note: When I put in a foreach statement before the whole table it worked, but then looped my table again and again.
Where should I define the variable that it should not loop?
Re: [dccreatives] Undefined Variable Error
By gkornbluth - May 11, 2011
It would seem that you will need a foreach loop in order to pull records from a list of records.
You can use a <?php break ?> before the endforeach to stop the looping after the first record.
Hope that gets you going in the right direction.
Best,
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [gkornbluth] Undefined Variable Error
By dccreatives - May 11, 2011
Re: [dccreatives] Undefined Variable Error
By gkornbluth - May 11, 2011
Something like
At the top of the page:
// load records
list($galleryRecords, $galleryMetaData) = getRecords(array(
'tableName' => 'gallery',In your table:
<?php foreach ($galleryRecords as $record): ?>
<?php echo $record['mounting'] ?> Gallery Images
<?php break ?>
<?php endforeach ?>Good luck,
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [dccreatives] Undefined Variable Error
By Jason - May 11, 2011
Another option would be to limit your query to only one result and then put the first record in it's own variable.
For example:
// load records
list($galleryRecords, $galleryMetaData) = getRecords(array(
'tableName' => 'gallery',
'limit' => 1,
));
$galleryRecord = $galleryRecords[0]; // get first record.You can then use the variable $galleryRecord without needing a foreach loop.
Hope this helps
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [gkornbluth] Undefined Variable Error
By dccreatives - May 12, 2011
Re: [Jason] Undefined Variable Error
By gkornbluth - May 12, 2011
Thanks for the reminder.
It certainly is a much simpler approach.
I guess that's the difference between someone who really understands PHP coding, and those of us who just cobble solutions together using our limited number of tools.
I'll definitely include this approach in the Cookbook.
Best,
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php