1. For this example we will use the following database table to create a Calendar application.
id int (11) NOT NULL AUTO_INCREMENT,
title varchar (64) DEFAULT NULL,
description varchar (128) DEFAULT NULL,
start_date date DEFAULT NULL,
start_time time DEFAULT NULL ,
end_date date DEFAULT NULL,
end_time time DEFAULT NULL,
recurrent varchar (1) DEFAULT NULL,
period varchar (1) DEFAULT NULL,
users varchar (10) DEFAULT NULL,
PRIMARY KEY (
Note: Scriptcase still gives you the option to automatically create the complete calendar table in the database that will allow to use the full calendar features.
2. Select the fields in the table that will be used in the application.
Elements with “*” are required to create the application. The other fields are used only for calendar information.
- Id: Used to identify the record, it is the primary key field in this table. (Int (11))
- Title: It is used to store the subject of each activity that will be displayed in the application. ((Varchar (50))
- Start date: The start date of the activity that will be registered. * (Date or datetime)
- Start Time: It will register the start time of the activity .. * (Date or datetime)
- End date: It will register the end date of the activity. * (Date or datetime)
- End Time: The end time of the activity will be registered. * (Date or datetime)
- Recurrence: It is used to indicate if the event will be repeated in a month, week or day (Int) (1)
- Period: Used to indicate the period of the recurrence: monthly, weekly or daily. (Int) (1)
Note: If you have a datetime field in the database, you can use that same datetime field to fill the both fields: date field and time field. The application will concatenate the fields before saving them in the database.
3. After compiling your new calendar application, you will see four types of visualization:
4. To add a new record, just click on the area corresponding to the date and time of the event you want. A simple form will be opened through a modal window.