5,838
edits
Daily Summary: Difference between revisions
→PHP scripts
| Line 199: | Line 199: | ||
=== PHP scripts === | === PHP scripts === | ||
Look in the Website Development section of the Cumulus support forum - '''Web general''' sub forum: | Look in the Website Development section of the Cumulus support forum - '''Web general''' sub forum: | ||
* [http://saratoga-weather.org/legacy-scripts/dayfile.txt Parse dayfile.txt PHP no database] - This script by the late Kevin Reed | * [http://saratoga-weather.org/legacy-scripts/dayfile.txt Parse dayfile.txt PHP no database] - This script by the late Kevin Reed who ran the web site TNETweather.com is discussed in [http://sandaysoft.com/forum/viewtopic.php?f=14&t=2419 forum], it is a no frills reader written in PHP (change '.txt' into '.php' when you download it) that parses dayfile.txt and produces an output table with headings. The script can be downloaded on Ken True's site from the link quoted, but with the closure of the original web site there is no further information still available. | ||
*[http://sandaysoft.com/forum/viewtopic.php?f=14&t=5319 'Annual Data Summary - Coloured Values'] - An extensively coloured version of David's original script with some useful discussion on the trade-off between testing values and efficient code here. | *[http://sandaysoft.com/forum/viewtopic.php?f=14&t=5319 'Annual Data Summary - Coloured Values'] - An extensively coloured version of David's original script with some useful discussion on the trade-off between testing values and efficient code here. | ||
*[http://sandaysoft.com/forum/viewtopic.php?f=14&t=11133 'Annual data Summary (DAJ script) - show day-of-week'] - This is just one of several places on the forum where further ideas are explored by Mark Crossley and beteljuice. | *[http://sandaysoft.com/forum/viewtopic.php?f=14&t=11133 'Annual data Summary (DAJ script) - show day-of-week'] - This is just one of several places on the forum where further ideas are explored by Mark Crossley and beteljuice. | ||
*[http://sandaysoft.com/forum/viewtopic.php?f=14&t=11397 'Yet Another Dayfile Reader (PHP)'] - | *[http://sandaysoft.com/forum/viewtopic.php?f=14&t=11397&start=405#p91488 'Yet Another Dayfile Reader (PHP)'] - Download from here the ultimate PHP parsing dayfile.txt version that has progressed a long way from David's original, it incorporates all the ideas discussed in earlier forum topics, some of the features are: the highlighting makes day of week appear in row headers, you can swap between daily and seasonal views and there is a table summary including averages. See that forum url for links to some of the many sites that have adopted this version, if you do not have a database, but do have PHP, then this is version for you. Mark Crossley has his own offshoot of this script, [https://weather.wilmslowastro.com/datasummary.php?view=getorfmiland data summary], that reads a database table, but uses much of the same script so produces a similar summary. | ||
* [http://sandaysoft.com/forum/viewtopic.php?f=14&t=16891#p130117 'Re: New Script that displays a selected daily statistic for every day'] - In 'alternative JavaScript version' above, SFWS refers to a pure PHP version that reads data from a database table. That version is now available in the linked paragraph, but using a site specific schema. | |||
* [http://sandaysoft.com/forum/viewtopic.php?f=14&t=16891#p129796 'New Script that displays a selected daily statistic for every day'] - Download from here, in the above topic, the newest (at time of writing) way to display daily statistics. This is the "daily pick" script where you select one criterion and all the daily values available are output, for ease of display there is a separate table for each month with HTML <detail> tags to show/hide. Both this and previous scripts were written for a schema that is different to the David Jamieson/Mark Crossley/Cumulus MX standard, but the daily pick script has both schemas available, comment out the one you don't want and remove comments round the one you do want. See further information in posts in the topic and the topic that it follows on from, at [http://sandaysoft.com/forum/viewtopic.php?f=14&t=16880 MySQL Code Help]. | |||
*[http://sandaysoft.com/forum/viewtopic.php?f=14&t=15983 'SQL dayfile data Viewer'] - This is another (widely adopted) PHP script for reading daily values from a database. It displays a number of key statistics, and you can order the results by the contents of any column. Read the forum topic for more information. You can scroll through the days or set a filter to only show certain days. There is a summary line, but because some columns include units, the calculation of the summary for those columns fails. It is quite simple to edit out the units, so all columns show a summary, but most users adopt the script as published and just accept that some summary figures are replaced by text. | |||
== Displaying daily statistics from a database table == | == Displaying daily statistics from a database table == | ||