MySQL question

5 posts by 2 authors in: Forums > CMS Builder
Last Post: May 8, 2011   (RSS)

By fleff - April 21, 2011

I want to put an availability calendar on an existing CMSB website that calls for new PHP and MySql. Should I set up a separate MySQL account for this or can I use the existing CMSB MySQL database. I don't want any conflict and don't know enough about MySQL to know if there could be one. Just want to be sure.

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

Hi Farnham,

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
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

Re: [gkornbluth] MySQL question

By fleff - April 23, 2011

Thanks, Jerry. I'll let you know how it works out. Actually, it's the Ajax Availability Calendar I'm planning to use.

Also, thanks for your Cookbook. It's helped me many times.

Farnham

Re: [fleff] MySQL question

By fleff - May 8, 2011

Hi Jerry,

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