MySQL question
5 posts by 2 authors in: Forums > CMS Builder
Last Post: May 8, 2011 (RSS)
By fleff - April 21, 2011
Also, will I be able to call up each individual calendar from the availability database for its corresponding listing in the CMSB database? The listings are rental properties.
Farnham
Re: [fleff] MySQL question
By gkornbluth - April 22, 2011
I don't think that there's any need to set up a separate database, just some new tables (section editors) in the existing database.
BTW, I found this on a previous post.
http://www.ajaxavailabilitycalendar.com
The post (by Maurice) said that they had integrated it into CMS Builder without too much effort.
Hope that helps,
If you do have any success (or experience any issues), I hope you'll share the details with us here on the forum.
Jerry Kornbluth
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [gkornbluth] MySQL question
By fleff - April 23, 2011
Also, thanks for your Cookbook. It's helped me many times.
Farnham
Re: [fleff] MySQL question
By gkornbluth - April 23, 2011
Good to hear.
Thanks for your support.
Jerry
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [fleff] MySQL question
By fleff - May 8, 2011
Ajax Availability Calendar integrates into CMSB very well. My website is a real estate one and each rental listing has its own calendar that shows what dates have been booked. Each calendar is identified by an individual ID number that appears in the address bar page when it is set up. So I created a field for the ID number in CMSB and called up the calendar on the details page of each listing with this code:
<?php if ($record['rental']): ?>
<div align="center"><iframe width="190px" height="265px" src="calendar/index.php?id_item=<?php echo $propertiesRecord['calendar_id'] ?>" style="border:none;" style="overflow-x: hidden;"></iframe></div>
<?php endif ?>
The calendars for all the listings are in a folder called "calendars" on the server. It works fine.
Best regards,
Farnham