Notes on the event calendar (SQLite) - Translated by Thomas Frei-Herrmann Version dated: 08/09/2022 The event calendar allows you to store events in a DB table (SQLite database file). The events are clearly displayed in a calendar.The calendar is navigating completely via JavaScript (Ajax), so no page change is necessary. The calendar shows all days of a month in the form of an HTML table. You can use buttons to previous month / previous year or next month / year can be navigated.The events can be viewed directly in the calendar enter (edit, move, copy or delete). Requirements: Web server with PHP 7.4 (or higher). A current browser (for example: Microsoft Edge, Mozilla Firefox or Google Chrome). Installation instructions: Execute the following instructions one after the other: Enter your access data (name and password) in the file: kalender.php. Upload all files to your web server. Call the file: "demo.htm" in your browser. Tips: - Make a regular backup copy of the file: "datenbank.db", this protects against data loss. - Please do not edit the file: "datenbank.db" with a text editor, this can render the file unusable! The file: "datenbank.db" can be edited with the program: 'DB Browser for SQLite'. The program is free and can be found at: https://sqlitebrowser.org/ Info about SQLite: https://www.sqlitetutorial.net - Day, week or day of the week can be highlighted using CSS directives. Examples can be found in the file: "style.css". - There shouldn't be any other forms on the event calendar page, because this can negatively affect the functionality of the calendar. - Set internal reference (link) to the calendar: Go to the calendar Keyboard layout (T1/QWERTZ): With forms, the functionality via the keyboard is deactivated, only the [ESC] key works! [CTRL] + [Left arrow key] - One month back [CTRL] + [right arrow key] - One month further [CTRL] + [Down arrow key] - One year back (on the laptop also: CTRL+Fn + down arrow key) [CTRL] + [Up arrow key] - One year further (on the laptop also: CTRL+Fn + up arrow key) [ESC] - Close the display (also works within forms) [A] - Registration and Deregistration [D] - Print (open print preview) [K] - prompt (month / year) [N] - Enter new event [O] - Scroll to the calendar [W] - Display week numbers [X] - Show current calendar The following BBCodes can be used in the text field: [b]Bold[/b], [i]Italic[/i], [s]Strikethrough[/s] [q]Quote[/q], [u]Underline[/u] [c=red]color[/c], [bc=blue]background color[/bc] [z]Center[/z], [g=image.jpg][/g] [a=audio.mp3][/a], [v=video.mp4][/v] URL and line breaks are formatted. Automatically send notifications by email: Call the PHP file via: "kalender.php?cron" with a cron 1 time a day. A cron job must be created at the provider (http://en.wikipedia.org/wiki/Cron). Requirements: Web server (Linux) with PHP 7.4 or higher with the PDO SQLite extensions, and knowledge of HTML, CSS, JavaScript and PHP for the scripts to adapt to your own wishes. Terms of Use By using the scripts you accept my terms of use without restrictions. The scripts are free for private use. I do not assume any liability with regard to the functionality or any damage or compensation claims that arise when using the scripts. There will be no support for problems that arise when adapting the scripts. "Calendars show the days to create such calendar shorten these days" ;) Have fun with it! W. Zenk For the numerous suggestions, hints and error messages, my best thanks to: Thomas Frei-Herrmann - https://www.mobirise-tutorials.com/ Versions (history) Version: 08/09/2022 Removed loop (PHP: collect events for each day) PHP: 30 lines shortened compared to the old version! CSS: Removed --highlight-outlinecolor. JavaScript bug fixed! Version: 07/04/2022 Events can be selected with the tab key. Minor adjustments to the design. Key: [N] - "Enter new event" - functionality has been added back (by user request). Error saving the date in the DB table has been fixed. JavaScript, CSS and PHP code have been improved. Added code descriptions. Version: 05/20/2022 BBCode changes, some code tags ([img],[video], [center]) adjusted. Optimization of the displayed HTML source text in the browser. The color values are now uniformly specified in CSS as RGB(A) format. Key: [N] - "Enter new event" functionality has been removed. The table row (CSS) selected with mouseover is now better highlighted. Version: 04/15/2022 Key: [O] - scroll up to calendar. Minor changes in CSS to various browsers. Highlight weekday name (see file: style.css). Version: 03/26/2022 The days of the week are fixed at the top when scrolling, so that they are always in the visible area. Version: 03/07/2022 The JavaScript has been adjusted so that there are no more script warnings on the mobile phone. A checked checkbox is now better highlighted. Minor adjustments in HTML, PHP and CSS. Version: 02/28/2022 Checkbox (message) - send notification by email (optional). Password protection for multiple users. Key: [D] - Print (opens the print preview). Version: 02/20/2022 Checkbox (Holiday) - A fixed day of the year, for birthdays, holidays, etc. (optional). Version: 02/13/2022 Checkbox (Private) - Private events (optional). The selected event is highlighted in the calendar. Minor adjustments (icon and color) in the title bar. Version: 01/31/2022 The window can be moved in the mobile view. After logging in or out, the current calendar selection is retained. Version: 01/26/2022 Key: [W] - Display week numbers. The week numbers at the end of the year are now displayed correctly according to ISO 8601. The month and year are clickable to select a different calendar. Show monthly pictures (optional). Various CSS and JavaScript optimizations. Version: 01/22/2022 The position of the window is automatically adjusted when the smartphone is rotated. The area of the links has been increased to make it easier to hit them with your finger on the smartphone. An operating system font is used. An option in a selection list can be selected with the mouse wheel. Version: 01/16/2022 Highlight day, week, day of the week with CSS directives. Examples in the file: style.css Version: 01/15/2022 A drop-down list for the month to show a different calendar. The attribute: 'alt' was added to images formatted with BBCode. When you hover over with the mouse pointer, further details about the event are displayed. Version: 01/09/2022 HTML tags have been deactivated, use BBCodes! Various display errors corrected. Version: 03.01.2022 HTML input field: Clock, for the end of an event. A function to move the window has been added. Fixed various bugs. Version: 02.01.2022 Navigate with the keyboard. Light and dark mode. Numerous changes in the script. Version: 12/29/2021 First version with the basic functions.