{"id":1479,"date":"2018-01-19T19:22:53","date_gmt":"2018-01-19T19:22:53","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/html_graphs-page-3\/"},"modified":"2018-01-19T19:24:49","modified_gmt":"2018-01-19T19:24:49","slug":"html_graphs-page-3","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/html_graphs-page-3\/","title":{"rendered":"HTML_Graphs Page 3"},"content":{"rendered":"
\n
\n
By Tim Perdue<\/div>\n
on July 30, 2000<\/div>\n<\/p><\/div>\n
\n
\nThat function is quite simple. Hand it a result set, it checks for the length,
\n then turns that result set into a set of arrays to pass into my other general function,
\nGraphIt().<\/b> GraphIt() can be called directly if you already have an array, or you
\nneed to do some custom stuff with it that cannot be done with straight SQL.<\/div>\n
\nNotice that GraphIt() will determine scale for you. It iterates through the values[] array
\nand finds the biggest value. It also builds an appropriate array of colors for the bars
\n on the graph.<\/div>\n
\n<\/p>\n

<?php
\n
<\/span>Function\u00a0<\/span>GraphIt<\/span>(<\/span>$names<\/span>,<\/span>$values<\/span>,<\/span>$title<\/span>)\u00a0{<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$counter<\/span>=<\/span>count<\/span>(<\/span>$names<\/span>);<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/*
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Can\u00a0choose\u00a0any\u00a0color\u00a0you\u00a0wish
\n
\u00a0\u00a0\u00a0\u00a0*\/
\n
\u00a0\u00a0\u00a0\u00a0<\/span>for\u00a0(<\/span>$i\u00a0<\/span>=\u00a0<\/span>0<\/span>;\u00a0<\/span>$i\u00a0<\/span><\u00a0<\/span>$counter<\/span>;\u00a0<\/span>$i<\/span>++)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$bars<\/span>[<\/span>$i<\/span>]=<\/span>\"#DEDEEE\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0}<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$counter<\/span>=<\/span>count<\/span>(<\/span>$values<\/span>);<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/*
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Figure\u00a0the\u00a0max_value\u00a0passed\u00a0in,\u00a0so\u00a0scale\u00a0can\u00a0be\u00a0determined
\n
\u00a0\u00a0\u00a0\u00a0*\/<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$max_value<\/span>=<\/span>0<\/span>;<\/p>\n

\u00a0\u00a0\u00a0\u00a0for\u00a0(<\/span>$i\u00a0<\/span>=\u00a0<\/span>0<\/span>;\u00a0<\/span>$i\u00a0<\/span><\u00a0<\/span>$counter<\/span>;\u00a0<\/span>$i<\/span>++)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if\u00a0(<\/span>$values<\/span>[<\/span>$i<\/span>]\u00a0>\u00a0<\/span>$max_value<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$max_value<\/span>=<\/span>$values<\/span>[<\/span>$i<\/span>];
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}
\n
\u00a0\u00a0\u00a0\u00a0}<\/p>\n

\u00a0\u00a0\u00a0\u00a0if\u00a0(<\/span>$max_value\u00a0<\/span><\u00a0<\/span>1<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$max_value<\/span>=<\/span>1<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0}<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/*
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0I\u00a0want\u00a0my\u00a0graphs\u00a0all\u00a0to\u00a0be\u00a0800\u00a0pixels\u00a0wide,\u00a0so\u00a0that\u00a0is\u00a0my\u00a0divisor
\n
\u00a0\u00a0\u00a0\u00a0*\/<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$scale\u00a0<\/span>=\u00a0(int)\u00a0(<\/span>800<\/span>\/<\/span>$max_value<\/span>);<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/*
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0I\u00a0create\u00a0a\u00a0wrapper\u00a0table\u00a0around\u00a0the\u00a0graph\u00a0that\u00a0holds\u00a0the\u00a0title
\n
\u00a0\u00a0\u00a0\u00a0*\/<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>echo\u00a0<\/span>\"<TABLE\u00a0BGCOLOR=\"NAVY\"\u00a0CELLSPACING=2\u00a0CELLPADDING=3>\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"<TR><TD\u00a0BGCOLOR=\"NAVY\"><FONT\u00a0COLOR=WHITE><B>$title<\/TD><\/TR><TR><TD>\"<\/span>;<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/*
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Create\u00a0an\u00a0associatve\u00a0array\u00a0to\u00a0pass\u00a0in.\u00a0I\u00a0leave\u00a0most\u00a0of\u00a0it\u00a0blank
\n
\u00a0\u00a0\u00a0\u00a0*\/<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$vals\u00a0<\/span>=\u00a0\u00a0array(
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"vlabel\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"hlabel\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"type\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"cellpadding\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"cellspacing\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"border\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"width\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"background\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"vfcolor\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"hfcolor\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"vbgcolor\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"hbgcolor\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"vfstyle\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"hfstyle\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"noshowvals\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"scale\"<\/span>=><\/span>\"$scale\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"namebgcolor\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"valuebgcolor\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"namefcolor\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"valuefcolor\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"namefstyle\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"valuefstyle\"<\/span>=><\/span>\"\"<\/span>,
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"doublefcolor\"<\/span>=><\/span>\"\"<\/span>);<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/*
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0This\u00a0is\u00a0the\u00a0actual\u00a0call\u00a0to\u00a0the\u00a0HTML_Graphs\u00a0class
\n
\u00a0\u00a0\u00a0\u00a0*\/<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>html_graph<\/span>(<\/span>$names<\/span>,<\/span>$values<\/span>,<\/span>$bars<\/span>,<\/span>$vals<\/span>);<\/p>\n

\u00a0\u00a0\u00a0\u00a0echo\u00a0<\/span>\"<\/TD><\/TR><\/TABLE>\"<\/span>;
\n
}
\n
<\/span>?><\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

\nSo those two functions really do the heavy lifting for you. Determing scale was always a headache until
\nI built the wrapper classes, and sometimes the graph would be so large it would go off the page.<\/div>\n<\/div>\n

<\/p>\n

\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

By Tim Perdue on July 30, 2000 That function is quite simple. Hand it a result set, it checks for the length, then turns that result set into a set of arrays to pass into my other general function, GraphIt(). GraphIt() can be called directly if you already have an… <\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1479","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1479"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1479\/revisions"}],"predecessor-version":[{"id":3328,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1479\/revisions\/3328"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}