Calendar Application.
1. The table that will be used for the calendar implementation must be created previously by the manager of your database.
CREATE TABLE `calendario` (
`chave` int(11) NOT NULL default '0',
`titulo` varchar(50) default NULL,
`descricao` text,
`inicio` datetime default NULL,
`final_data` date default NULL,
`final_hora` time default NULL,
`recorrencia` char(1) default NULL,
`periodo` char(1) default NULL,
PRIMARY KEY (`chave`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2. Select which fields of the table stored items used by the application.
Items with * are required to create the application. The others are used only if you want the calendar application has resource agenda.
-
Option:
- Id: Used to identify the record, select the field that table's primary key. (Int (11))
- Title: Used to store the subject of each activity that will be displayed in the application. ((Varchar (50))
- Start Date: It will be recorded the date of the activity, if you use notebook, record the beginning of it. * (Or datetime)
- Start time: Is the time recorded the activity, use the event calendar, write the beginning of it. * (Time or datetime)
- End Date: Is the end date of recorded activity registered on the agenda. * (Or datetime)
- End Time: ending time will be recorded in the activity registered in the schedule. * (Time or datetime)
- Recurrence: This is used when an application has repeated a month, week or day. (Int) (1)
- Period: Will be used when an application has repeated a month, week or day. (Int) (1) ยท If you have a base camp date / time, you can select the option date and time the same field. The framework will take both reports and concatenate them before saving the base.
3. After compiling your new calendar application, you will see three types of display: month, week and day.
3. 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..
| Rate this Tutorial | |||||||
|
|||||||
|
