PHP MySQL Charts/Graphs - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=40466.0&return_msg=40466.9"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=40466.1">1–10</a><a href="lmessages.php?webtag=DEFAULT&msg=40466.11">11–20</a>…<a href="lmessages.php?webtag=DEFAULT&msg=40466.41">41–47</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=40466.9">PHP MySQL Charts/Graphs</a> </h3> <div id="messages" data-navigation="40466_9_47_10"> <a name="a40466_9"></a><div class="message" id="message_40466_9"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 5 May 2013 19:47</span> <div class="clearer"></div> </div><div class="message_to">To: af (CAER) <span><span class="image post_read" title="Read: 5 May 2013 20:42"></span></span> <span class="message_count">9 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.9">40466.9</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.8">40466.8</a></div> <div class="message_body"> Yeah, I'm currently working my way through monitor.js, hopefully won't take me too long to get something looking reasonable <span class="emoticon e_embarrassed" title=":$"><span class="e__">:$</span></span></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.9&return_msg=40466.9" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.9"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a40466_10"></a><div class="message" id="message_40466_10"> <div class="message_header"> <div class="message_from"> From: af (CAER)<span class="message_time"> 5 May 2013 20:44</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 5 May 2013 21:00"></span></span> <span class="message_count">10 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.10">40466.10</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.9#a40466_9" target="_self">40466.9</a></div> <div class="message_body"> The best thing about Flot, I reckon, is that it gives you a nice-looking graph pretty much by default.<br /><br /> I think the trickiest thing I did on my monitoring thing was the day/weekend shading, and maybe the smoothing, although that was more a case of me being slow to understand how <span style="white-space:pre-wrap;">Savitzky-Golay works (it's actually pretty simple).</span></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.10&return_msg=40466.9" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.10"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a40466_11"></a><div class="message" id="message_40466_11"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 5 May 2013 21:29</span> <div class="clearer"></div> </div><div class="message_to">To: af (CAER) <span><span class="image post_read" title="Read: 5 May 2013 21:46"></span></span> <span class="message_count">11 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.11">40466.11</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.9#a40466_10" target="_self">40466.10</a></div> <div class="message_body"> Well I seemed to have solved the major issue of being able to tell what the date/time is by using a proper time format in the database rather than doing conversions. All new entries are added with a unix time stamp.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.11&return_msg=40466.9" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.11"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a40466_12"></a><div class="message" id="message_40466_12"> <div class="message_header"> <div class="message_from"> From: af (CAER)<span class="message_time"> 5 May 2013 21:47</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 5 May 2013 21:54"></span></span> <span class="message_count">12 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.12">40466.12</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.9#a40466_11" target="_self">40466.11</a></div> <div class="message_body"> Heh yeah using a numeric timestamp makes things much easier, for one thing because that's what the Flot-time thing expects, and for another it makes it easier to do comparisons.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.12&return_msg=40466.9" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.12"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a40466_13"></a><div class="message" id="message_40466_13"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 5 May 2013 22:28</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 6 May 2013 06:59"></span></span> af (CAER) <span><span class="image post_read" title="Read: 6 May 2013 05:59"></span></span> <span class="message_count">13 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.13">40466.13</a></div> <div class="message_body"> Well that's definitely much better<br /><br /><img alt="" src="https://dl.dropboxusercontent.com/u/14641356/tempflot.png" /><br /> Now to make it look nicer. Thanks for suggesting Flot!<br /></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.13&return_msg=40466.9" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.13"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a40466_14"></a><div class="message" id="message_40466_14"> <div class="message_header"> <div class="message_from"> From: af (CAER)<span class="message_time"> 6 May 2013 06:41</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 6 May 2013 08:24"></span></span> <span class="message_count">14 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.14">40466.14</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.9#a40466_13" target="_self">40466.13</a></div> <div class="message_body"> One thing I did to make mine look slightly nicer is to trim the start to where the time is a whole number if minutes/hours – that way you get nice round "16:00" time labels, rather than "16:42" and such.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.14&return_msg=40466.9" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.14"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a40466_15"></a><div class="message" id="message_40466_15"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 6 May 2013 08:37</span> <div class="clearer"></div> </div><div class="message_to">To: af (CAER) <span><span class="image post_read" title="Read: 6 May 2013 09:10"></span></span> <span class="message_count">15 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.15">40466.15</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.9#a40466_14" target="_self">40466.14</a></div> <div class="message_body"> Good idea, that would make things look a bit better. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.15&return_msg=40466.9" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.15"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a40466_16"></a><div class="message" id="message_40466_16"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 6 May 2013 14:01</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">16 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.16">40466.16</a></div> <div class="message_body"> Looking much better<br /><br /><a href="http://antthomas.co.uk/temperature/">http://www.antthomas.co.uk/temperature/</a><br /><br /> Only real issue is that the database is on my home server so it's a bit slow, especially on the larger time periods.<br /><br /><div class="edit_text">EDITED: 6 May 2013 14:04 by ANT_THOMAS</div> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.16&return_msg=40466.9" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.16"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a40466_17"></a><div class="message" id="message_40466_17"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time"> 6 May 2013 17:07</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 6 May 2013 17:08"></span></span> <span class="message_count">17 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.17">40466.17</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.9#a40466_16" target="_self">40466.16</a></div> <div class="message_body"> Do you have indexes on the columns you are joining / sorting on in your database tables? </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.17&return_msg=40466.9" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.17"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a40466_18"></a><div class="message" id="message_40466_18"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 6 May 2013 17:09</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 6 May 2013 18:19"></span></span> <span class="message_count">18 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.18">40466.18</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.9#a40466_17" target="_self">40466.17</a></div> <div class="message_body"> Yeah, all have an id which is auto incremented. <br /> <br /> I did think of just getting odds or evens to half the data. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.18&return_msg=40466.9" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.18"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> <div class="message_page_footer"> <ul> <li class="right_col"><form accept-charset="utf-8" method="get" action="lmessages.php" target="_self"><input type="hidden" name="webtag" id="webtag" class="bhinputtext" value="DEFAULT" dir="ltr" /><input type="hidden" name="msg" id="msg" class="bhinputtext" value="40466.19" dir="ltr" /><input type="submit" name="submit" id="keep_reading" value="Keep reading…" class="button" /></form></li> </ul> </div> </div> </body>