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.36"> <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.21">21–30</a><a href="lmessages.php?webtag=DEFAULT&msg=40466.31">31–40</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.36">PHP MySQL Charts/Graphs</a> </h3> <div id="messages" data-navigation="40466_36_47_10"> <a name="a40466_36"></a><div class="message" id="message_40466_36"> <div class="message_header"> <div class="message_from"> From: CHYRON (DSMITHHFX)<span class="message_time"> 8 May 2013 09:57</span> <div class="clearer"></div> </div><div class="message_to">To: Drew (X3N0PH0N) <span><span class="image post_read" title="Read: 8 May 2013 10:19"></span></span> <span class="message_count">36 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.36">40466.36</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.34">40466.34</a></div> <div class="message_body"> That choked my dual core 2.5g.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.36&return_msg=40466.36" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.36"> <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_37"></a><div class="message" id="message_40466_37"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 8 May 2013 10:29</span> <div class="clearer"></div> </div><div class="message_to">To: CHYRON (DSMITHHFX) <span><span class="image post_read" title="Read: 8 May 2013 12:26"></span></span> <span class="message_count">37 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.37">40466.37</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.35">40466.35</a></div> <div class="message_body"> There isn't really any developing/debugging as such. I've been playing with temperature sensors with my RPis and I wanted to put one outdoors and I decided it would be nice to look at the data in a graph. Every minutes is definitely overkill but it's very quick when I access the data locally, I think it would be slow even if the data was held on the hosting server, especially when it gets to weeks and months worth of data.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.37&return_msg=40466.36" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.37"> <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_38"></a><div class="message" id="message_40466_38"> <div class="message_header"> <div class="message_from"> From: af (CAER)<span class="message_time"> 8 May 2013 18:22</span> <div class="clearer"></div> </div><div class="message_to">To: CHYRON (DSMITHHFX) <span><span class="image post_read" title="Read: 8 May 2013 19:35"></span></span> <span class="message_count">38 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.38">40466.38</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.35">40466.35</a></div> <div class="message_body"> At that rate, 24 hours' worth is only 60k or so – 1440 data points per series, which is not a huge amount, and like I said earlier, even my phone can handle that with no noticeable slowing.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.38&return_msg=40466.36" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.38"> <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_39"></a><div class="message" id="message_40466_39"> <div class="message_header"> <div class="message_from"> From: koswix<span class="message_time"> 8 May 2013 22:29</span> <div class="clearer"></div> </div><div class="message_to">To: Drew (X3N0PH0N) <span><span class="image post_read" title="Read: 9 May 2013 03:05"></span></span> <span class="message_count">39 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.39">40466.39</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.34">40466.34</a></div> <div class="message_body"> No drop shadow! <span class="emoticon e_shock" title=":O"><span class="e__">:O</span></span></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.39&return_msg=40466.36" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.39"> <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_40"></a><div class="message" id="message_40466_40"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 8 May 2013 23:46</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 9 May 2013 05:51"></span></span> <span class="message_count">40 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.40">40466.40</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.20">40466.20</a></div> <div class="message_body"> A MySQL question.<br /><br /> Due to there being missing parts on the chart for the shorter readings because of the missing entries I've changed how the data is pulled from the database by calculating the current time minus the length of time required then only fetching the rows that are greater than this calculated time. It works nicely and gives a proper day, week length etc.<br /><br /> My question is should I be indexing my "unixtime" column to make it easier on the DB? <br /><br /> New code is...<br /><br /><div class="quotetext"> <b>code: </b></div> <pre class="code"> $currtime = time();<br /> $newlimit = $currtime - $limit;<br /> SELECT * FROM outside WHERE unixtime > $newlimit ORDER BY id DESC<br /></pre> <div> With $limit now being the length of time in seconds.<br /> edit: I think that looks better. </div> <br /><div class="edit_text">EDITED: 8 May 2013 23:48 by ANT_THOMAS</div> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.40&return_msg=40466.36" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.40"> <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_41"></a><div class="message" id="message_40466_41"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 8 May 2013 23:47</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">41 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.41">40466.41</a></div> <div class="message_body"> I suck at using the new editor.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.41&return_msg=40466.36" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.41"> <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_42"></a><div class="message" id="message_40466_42"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time"> 9 May 2013 05:57</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 9 May 2013 06:36"></span></span> <span class="message_count">42 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.42">40466.42</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.36#a40466_40" target="_self">40466.40</a></div> <div class="message_body"> Yes, an index would be useful there.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.42&return_msg=40466.36" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.42"> <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_43"></a><div class="message" id="message_40466_43"> <div class="message_header"> <div class="message_from"> From: af (CAER)<span class="message_time"> 9 May 2013 10:07</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 9 May 2013 10:32"></span></span> <span class="message_count">43 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.43">40466.43</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.36#a40466_41" target="_self">40466.41</a></div> <div class="message_body"> The editor sucks at being used, more like.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.43&return_msg=40466.36" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.43"> <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_44"></a><div class="message" id="message_40466_44"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 9 May 2013 10:34</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 9 May 2013 12:15"></span></span> <span class="message_count">44 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.44">40466.44</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.36#a40466_42" target="_self">40466.42</a></div> <div class="message_body"> Is it a cache issue that is causing no grey box to appear when I want to add code in the new editor? Only "code:" appears I end up having to go in to the HTML and put things between the pre tags but there's divs all over the place. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.44&return_msg=40466.36" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.44"> <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_45"></a><div class="message" id="message_40466_45"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time"> 9 May 2013 12:17</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 9 May 2013 12:35"></span></span> <span class="message_count">45 of 47</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=40466.45">40466.45</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=40466.36#a40466_44" target="_self">40466.44</a></div> <div class="message_body"> Could be a cache issue, it's showing here on both "Teh Forum" and "Yellow" themes.<br /></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=40466.45&return_msg=40466.36" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="40466.45"> <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.46" dir="ltr" /><input type="submit" name="submit" id="keep_reading" value="Keep reading…" class="button" /></form></li> </ul> </div> </div> </body>