5,838
edits
Daily Summary: Difference between revisions
m
→Some example Scripts: Updated source reference to Mark's top ten script
m (→PHP scripts: Added introductory caution) |
m (→Some example Scripts: Updated source reference to Mark's top ten script) |
||
|
=== Some example Scripts ===
As for the [[#PHP_scripts|PHP daily summary scripts section]] - ''Be aware if you use PHP scripts written by someone else .... These scripts may use "include ..." or "require ..." to bring in variables (such as those for accessing the database) or functions (to do standard actions) or templates (shared headers, navigation menus and footers) or text (any other common content) that is used with a number of pages on author's site. If you don't comment out those references to external scripts, or replace the references with your equivalents, the PHP parser may fail to produce a HTML page and nothing will be available to the browser. Thus you do need a simple understanding of PHP, a PHP book, or the ability to look up PHP instructions on the web if you are to be successful with tailoring these scripts to your site.''
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=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://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=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 corresponding ones for earlier years.
| |||