|
=== Some example Scripts ===
Look in the Website Development section of the Cumulus support forum - '''Web general''' sub forum:
* Look at the Javascript and PHP scripts already listed for showing raw values, but some others present a summary view:
*[http://sandaysoft.com/forum/viewtopic.php?f=14&t=15983#p122552 SQL dayfile data Viewer] - This script by Kocher shows selected statistics, you can scroll up and down through all available days and for those days (or all days) see some summary statistics at the foot of each column.
**[http://sandaysoft.com/forum/viewtopic.php?f=14&t=1688010755#p129719p87081 MySQLTop code10 help]Records Page]- This showsscript aby snippetMark ofCrossley aruns PHPseveral scriptqueries byagainst SFWSthe fordaily creating asummary table that forof a particulardatabase criterionand picks various extremes showsdisplaying the valuetop withten allextremes the(e.g. years). as columnThe headerslatest andsource allphp thecan daysbe ofseen using a year[http://weather.wilmslowastro.com/top10s.php?view=sce (1query-string Janon toMark 31Crossley's Dec)web assite] rows.and there Thehave providedbeen scriptseveral usesupdates standardsince HTMLthe toforum show/hidethread eachwas monthcreated.
**[http://sandaysoft.com/forum/viewtopic.php?f=14&t=16534#p126964 What to do with data from MySQL] - This posting lists a number of web pages on PaulMy's web site where he presents statistics from the daily summary table of his database in different formats.
*[http://sandaysoft.com/forum/viewtopic.php?f=14&t=10755#p87081 Top 10 Records Page]- This script by Mark Crossley runs several queries against the daily summary table of a database and picks various extremes displaying the top ten extremes (e.g. ). The latest source php can be seen using a [http://weather.wilmslowastro.com/top10s.php?view=sce query-string on Mark Crossley's web site] and there have been several updates since the forum thread was created.
**[http://sandaysoft.com/forum/viewtopic.php?f=14&t=165347834#p126964p66013 WhatThis today dolast withyear data from MySQLpage] - This postingpost listshas a numberquery ofin weba pagesphp onfile PaulMy's(as webyou sitesave wherethe hedownload presentschange statistics'.txt' to '.php') that will extract from the daily summary table ofin hisa database, invalues for one year ago, two years ago to feed a web page that displays all the summary statistics for today and the corresponding ones for differentearlier formatsyears.
*[http://sandaysoft.com/forum/viewtopic.php?f=14&t=7834#p66013 This day last year page] - This post has a query in a php file (as you save the download change '.txt' to '.php') that will extract from the daily summary table in a database, values for one year ago, two years ago to feed a web page that displays all the summary statistics for today and the corrsponding ones for earlier years.
There are various scripts out there that output graphs from the values read, I have not identifedidentified a particular one to reference here yet. If you find a site dislaying a graph you would like to copy on your own site, you might be able to see the PHP source that is responsible, but as I have commented [http://sandaysoft.com/forum/viewtopic.php?f=14&t=16425&p=126065#p126065 elsewhere] most authors do not make it easy to see their code. Of course one of the reasons for using PHP script is that processing is done quickly on the web server and only the resulting HTML is passed onto the client browser and this does protect interlectual property and adds security by not showing the database access code.
=== Other jQuery approaches ===
| 