Calendar Application

1. The table that will be used for the calendar implementation is “events”.

CREATE TABLE `events` (
`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 (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

2. Select the table fields that will be used in the application.

Items with “*” are required to create the application. The other fields are only used for information to the agenda.

Options

  • Id: Used to identify the record, select the primary key field in this table. (Int (11))
  • Title: Used to store the subject of each activity that is displayed in the application. ((Varchar (50))
  • Start date: the start date of the activity will be recorded. * (Date or datetime)
  • Start Time: Will record the start time of the activity. * (Date or datetime)
  • End date: end date of the activity will be recorded. * (Date or datetime)
  • End Time: Will record the finish time of the activity. * (Date or datetime)
  • Recurrence: Used to state whether the event repeats in a month, week or day. (Int) (1)
  • Period: Used to state the type of recurrence reptição: month, week or day. (Int) (1)

Note: If you have a field of type datetime in the database, you can list the options date and time using the same datetime field from the database. The application will take the two values and will concatenate them before saving in the database.

3. After compiling your new calendar application, you will see four types of display: month, week, day and agenda.

4. To add a record, click the area corresponding to the event date and time desired. Will open a simple form, either through inclusion in modal.

Tutorials in the same category

Calendar (Integration with Google Calendar)

1- First, you should activate the google API on this page: https://console.developers.google.co...

Simple Calendar

1. For this example we will use the following database table to create a Calendar application. C...

Tab application with Grid and Chart

In this example we will see the creation of an application tab type, where it can be opened on the s...

Tab application with Grid and Form

In this example we will see the creation of an application tab type, where it can be opened on the s...

Comment this post