user area

User name:

Password:

Login

Daily Scheduler Calendar with MySQL Database

Purchase and DownloadThe Daily Scheduler Calendar with MySQL Database is a special version of the original Daily Scheduler Calendar that uses a MySQL database instead plain text files to store the calendar data.

Like in the original calendar, this one can be installed (optionally) directly from the Adobe Dreamweaver's menu and includes a web-based administration system to edit the calendar data & settings.

Important: Note that this special version is sold as a separate extension. However if you have purchased previously the original Daily Scheduler Calendar (with plain text databases) please contact us and we will provide you with an upgrade link for only us$29.99. Be sure to include the email address used for the previous purchase in your contact message.

This calendar has the following features:

  • The calendar data is stored into a MySQL database, making easier its interaction with third party applications and exporting data.
  • Allows to create entries for each day, indicating, optionally, start and end times for each entry.
  • Supports three types of entries:
    1. With both start time and end time defined
    2. Only start time defined
    3. Without defined start or end time
  • Supports recurring events on weekly basis, ex.: all Mondays at 09.00 AM, all Saturdays at 10.00 PM, etc. Note: only recurring events of weekly frequency are supported, without exception, excluding any other type of recurring events (more information below).
  • Can be used to visualize calendar entries on a public site, where additional information will be shown in floating panels.
  • Can be used as a reservation calendar. If inserted into a reservation form, can be used as a date picker to select start and end dates.
  • Includes an HTML (WYSIWYG) Editor, to edit calendar entries.
  • Supports 12 hours (AM/PM) or 24 hours format.

Note: Dreamweaver is no longer a mandatory requirement for this product. Beside a Dreamweaver extension, we are launching a version that can be used directly, without having to use Dreamweaver, just by copying the files and pasting the code into your webpage.

Includes three types of appearance on a website:

  • Type 1: Small Calendar - only a small calendar is shown; rolling the mouse over a day, a floating panel is shown with the entries associated to that day, if any. This option is useful if you wish to locate the calendar in a sidebar or in a small area of the central content. Click the following link to see an example:

    Click to open the Demo for Type 1 Calendar.

  • Type 2: Large Calendar - shows a bigger calendar that occupies the main content of a page, where entries' titles are shown directly in the related day cells, while the remaining information is shown in floating panels, which appear once the mouse is rolled over the titles. Click the following link to see an example:

    Click to open the Demo for Type 2 Calendar.

  • Type 3: Reservation Calendar - to be used as a date picker in a web reservation form. Please click the following link to see an example:

    Click to open the Demo for Type 3 Calendar.

All admin and visualization is made using modern Ajax technologies. This product does not require programming knowledge.

»»» Click to open Admin Demo «««
»»» Click to see Admin User Help Video «««

Tip: in the case of the Daily Scheduler with MySQL Database, if you don't have a script that processes your reservation form to collect the data sent by the user, we can suggest any one of the following Dreamweaver extensions:

REQUIREMENTS

IMPORTANT: This software has the following requirements:

  1. The server must support PHP 4.0 or later
  2. Your webserver must support MySQL 3.23 or later versions.

Optional requirements:

  • If you want to use it as a Dreamweaver extension: Dreamweaver MX or later version (can be MX, MX 2004, DW 8, DW CS3, DW CS4, DW CS5, CS6, CC, ...)

HELP & FAQ & VIDEOS

Please read below the "Basic Installation" and "Development Notes".

For visual information, please consult the animated video-demo.

For a live sample please visit the following links:

BASIC INSTALLATION

If you aren't using Dreamweaver then ignore the references to Dreamweaver below and follow the instructions specified into the "readme.txt" file located into the folder "Non-Dreamweaver version" (after unzipping the downloaded file). Basically just copy the files into your website.

To install in Dreamweaver, please follow these steps:

  1. Double click on the downloaded .MXP file. This will install the product in Dreamweaver.
  2. Restart Dreamweaver to complete the installation
  3. At this time you will have access to a new option in your Dreamweaver, which can be found under "Dreamweaver Menu >> Commands >> Insert Daily Scheduler with MySQL Database"

To install the product in your page:

  1. Open the page where you wish to install your calendar. This page must be previously saved within your website.
  2. Use the option "Dreamweaver Menu >> Commands >> Insert Daily Scheduler with MySQL Database", at which point the following window will appear:

    Insert Daily Scheduler

    The window's fields are as follows:

    • Language: Calendar language. At this time, the following languages are available: English, Spanish, French, Italian, German, Japanese, Portuguese and Dutch.
    • Page number: amount of months that you wish to show simultaneously in your calendar.
    • Calendar Type: Select what type of calendar you require; it can be "Type 1 - Small Calendar", "Type 2 - Large Calendar", or "Type 3 - Reservation Calendar", as explained previously.
    • Username: Name of the user who will access the calendar's admin.
    • Password: Password to access the calendar's admin.

  3. When you click on OK, the calendar will be inserted in your page, and all the relative files pertaining to the calendar's admin will be automatically created.
  4. Important Step: To specify the database access details for the calendar open the file "DC_DailyScheduler/admin/config.inc.php" and in the first lines you need to specify the MySQL database access details. Read below in the "DATABASE CONFIGURATION" section.
  5. You can now access the Admin System of the calendar at the following address: http://your-web-server/DC_DailyScheduler/admin

DATABASE CONFIGURATION

First you must create a MySQL database. It can be a blank MySQL database since the required tables will be created automatically by the calendar scripts when needed.

To specify the database access details for the calendar open the file "DC_DailyScheduler/admin/config.inc.php" and in the first lines you will see:

define("DC_MYSQL_HOST","localhost"); 
define("DC_MYSQL_USER","DATABASE USERNAME HERE"); 
define("DC_MYSQL_PASSWORD","DATABASE PASSWORD HERE"); 
define("DC_MY_DATABASE","DATABASE NAME HERE");

The first parameter is the MySQL hostname, usually "localhost" unless your hosting provider specifies a different hostname for MySQL. The remaining parameters are (as the text suggests) the database username, database password and database name. Put there the correct access values for your database and be sure that the database user has privileges to create new tables.

DEVELOPMENT NOTES

The address from which you can manage your calendar is:

http://your-web-server/DC_DailyScheduler/admin

or, if the calendar is not at the root of your website:

http://your-web-server/subfolder-1/subfolder-2/...../DC_DailyScheduler/admin

About recurring events:

Please note that this calendar only supports recurring events that always occur the same day of the week, which means that the following kinds of events are supported:

  • Every Monday at 9.00 AM
  • Every Saturday at 10.00 PM
  • etc...

The following types of events are NOT supported:

  • Every second Monday of the month
  • Every 5th of the month
  • Every 5th of February, yearly
...or any other type that does not occur on weekly basis.

Managing the calendar:

Defining working days: Please mark the days that are available to add appointments, activities etc, as shown on this image:

Defining working days

These days will be shown in the calendar as stricken through.

Defining appointment times: To define the time of appointments or activities, go to the day of the needed week (Monday, Tuesday...), where you will have the option to add each time independently (ex. Add Time at 8.00), or if you wish, you can generate, in one step, multiple appointment times for each interval (ex. add starting at 8 AM, every 30 minutes, 5 times; this will generate the sequence: 8.00, 8.30, 9.00, 9.30, 10.00). The following image shows both options:

Defining appointment times

To delete times, mark them and use the button "Delete marked times"

Adding restricted dates: Special days where no appointments or activities will be held, can be entered individually through this opton. Simply click on them to make them as "restricted" and if you wish to "un-restrict" them, simply click on them again. The following image shows the interface for these actions:

Adding restricted dates

Adding information to the calendar: After defining the working days and the schedules you can use the calendar that appears in the upper part to add information on the activities that occupy the established times. For that, click on the desired day and the list of pre-defined times will be shown. Click on the start and end times (date range) and a window will appear where you can enter the title of the activity / appointment and a description, as shown in the following image:

Adding information to the calendar

As you can see, all the work is realized on a single page, which is highly interactive, done in real time with comfortable effects based on modern dynamic scripts.

Changing the visual presentation:

If you wish to modify colours, fonts, size and other calendar styles you can do it by editing Cascading Style Sheets files (.CSS) that define these parameters. These files can be found in these locations:

  • For the main styles: DC_DailyScheduler/DCDailyScheduler.css
  • For general styles: DC_DailyScheduler/calendar.css

We recommend that you make a backup copy before modifying these visual styles.

Instant Download
Preferred payment & download method:
Paypal or Credit Cards:
PRICE
USD $59.99
After payment you will be redirected to a direct-download page and the download link will be emailed to the payment address.