|
|
Line 144: |
Line 144: |
| goto snowDone; | | goto snowDone; |
| }// end snow diary file processing</pre> | | }// end snow diary file processing</pre> |
|
| |
|
| |
| == 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 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):
| |
| <pre>$diary = 'sqlite:' . $snowDiary; // Parameter to identify a SQLite database puts a prefix in front of file path
| |
| $dbhandle = new PDO($diary); // connect to db
| |
| if($dbhandle === false)
| |
| {
| |
| $liteError = sqlite_last_error ($dbhandle );
| |
| echo ' Error: ' . sqlite_error_string ($liteError);
| |
| }else{
| |
| if($debug) echo $lf . '============================' . $lf . 'Success, database ' . $diary . ' is open' . $lf;
| |
| $queryRead = "SELECT ALL * FROM " . "'DiaryData'";
| |
| $statement = $dbhandle -> query($queryRead);
| |
| if($statement === false)
| |
| {
| |
| $liteError = sqlite_last_error ($dbhandle );
| |
| echo ' Error: ' . sqlite_error_string ($liteError);
| |
| }else{
| |
| $jump = false;
| |
| foreach ($statement as $row)
| |
| {
| |
| foreach($row as $key => $value )
| |
| {
| |
| if($key == 'Timestamp')
| |
| {
| |
| $keyDate = substr($value, 0, 10);
| |
| }
| |
| if($keyDate != $rowMetDayStamp) break;
| |
| if($key == 'snowFalling') $falling = $value;
| |
| if($key == 'snowLying') $lying = $value;
| |
| if($key == 'snowDepth') $depth = $value;
| |
| if($key == 'entry') $Entry = $value;
| |
| $jump = true;
| |
| }
| |
| if($jump)
| |
| {
| |
| $snowKnown = true;
| |
| goto snowDone;
| |
| }
| |
| }
| |
| }
| |
| }
| |
| </pre>
| |
|
| |
|
| |
|
| |
| [[Category: Terminology]]
| |
| [[Category:Log Files]]
| |
| [[Category:Cumulus 1]]
| |
| [[Category:Cumulus MX]]
| |