5,838
edits
Weather Diary: Difference between revisions
m
→Accessing MX diary outside MX
m (Resequence existing content (previously C1 and MX were in turn, now each section covers both)) |
|||
| Line 143: | Line 143: | ||
== Accessing MX diary outside MX == | == Accessing MX diary outside MX == | ||
The weather diary is stored in [[diary.db|a sqLite database]] and that can be easily accessed by any ODBC software e.g. Libre Office. It can also be accessed using PDO instructions in PHP Hypertext Preprocessor. | The weather diary is stored in [[diary.db|a sqLite database]] and that can be easily accessed by any ODBC software e.g. Libre Office Base. It can also be accessed using PDO instructions in PHP Hypertext Preprocessor. | ||
Here is an example in a PHP 7.3 (please note, this script will not work without changes for PHP 7.4, and PHP 8.x) script (modification of script available in [[File:Snow diary.zip]]) of accessing any one day ($rowMetDayStamp in yyyy-mm-dd format): | Here is an example in a PHP 7.3 (please note, this script will not work without changes for PHP 7.4, and PHP 8.x) script (modification of script available in [[File:Snow diary.zip]]) of accessing any one day ($rowMetDayStamp in yyyy-mm-dd format): | ||