Databases
StackOverflow2013
Postsdbo
POAnchor Cycler / Dropdown to import school class data periodically
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAnchor Cycler / Dropdown to import school class data periodically
    primarykey
    data
    text
    <p>SO, </p> <p>I've been working on some html/javascript/css recently to create an online table for my students to view details, scores and various bits of information but I've hit a brick wall and am unsure how to do what I'm trying to do.</p> <p>The reason I'm posting all of these in one thread is because several of these I think could conflict and cause the previous edit(s) to fail to function...</p> <p><strong>I realise that there are a lot of questions in one here and don't expect someone to code the entire thing, I'm just looking for some help / snippits / ideas and would greatly appreciate especially those with comments/descriptions so that I can continue to learn and improve :)</strong></p> <hr> <h1>Update 13/11/2013 @ 02:43 GMT</h1> <h3>LATEST: <a href="http://jsfiddle.net/pwv7u/" rel="nofollow">http://jsfiddle.net/pwv7u/</a></h3> <ul> <li>I'm trying to get <code>Next Class | Previous Class</code> to be cycle buttons to move to and from classes the same way the dropdown works.</li> <li>The scroll bar what used to be at the bottom of the page has disappeared because of the width has been changed...</li> <li>The footer at the bottom doesn't show correctly on mobile devices and the Scroll Left and Scroll buttons don't appear at all on mobile devices.</li> <li>The scroll left button is unable to be clicked</li> <li><p>Refreshing the page resets the horizontal scroll position to far left (I'm pretty sure this relates to the scroll bar)</p></li> <li><p>In regards to the loading/refreshing I guess I'll have to make another post as the current options are nearly there but not quite, I'll example below the way(s) that I ideally want it to work.</p> <ul> <li><code>main.html</code> will not contain any class details it would be: <a href="http://pastebin.com/raw.php?i=HwXM67up" rel="nofollow">http://pastebin.com/raw.php?i=HwXM67up</a></li> <li>The "option" (dropdown) would somehow poll a json file to gather a list of classes avaliable</li> <li>The "option" (dropdown) will have options for each individual school class aswell as "All Updating" and "All Non-Updating"</li> <li>Selecting an individual school class will import ONLY that specific school class into the page.</li> <li>Selecting a different individual school class will destory the old school class and import the newly selected school class.</li> <li>Individual school classes will periodically poll the json file to check for updates / changes to that school classes data and on a change/update it will re-draw/re-import.</li> <li>Selecting "All Updating" will import ALL school classes and periodically poll the json file to check for updates / changes to any school class (if possible only updating the school class what has changed/updated) but with all classes visible on the page.</li> <li>Selecting "All Non-Updating" will do the same as above but won't need to poll the json file to update.</li> </ul></li> <li>I can split the data into blocks like: <a href="http://pastebin.com/raw.php?i=MRpjvJp0" rel="nofollow">http://pastebin.com/raw.php?i=MRpjvJp0</a> (first block example) fairly easily and give them correct titles (titles that would be used in the Option dropdown), unsure how to put them into json format though</li> </ul>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDennis Sylvian
    1. USDennis Sylvian
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAnchor Cycler / Dropdown to import school class data periodically
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POAnchor Cycler / Dropdown to import school class data periodically
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POAnchor Cycler / Dropdown to import school class data periodically
      1. This table or related slice is empty.
      1. VTModeratorReview
    1. COI think it would be wise to put a fixed width on the container and to use `overflow-x:scroll` to handle scrolling in the table
      singulars
      1. POAnchor Cycler / Dropdown to import school class data periodically
      1. USDanny
    2. CO@Danny It is already in a container and has a scroll bar but I'm trying to get some buttons working correctly, they scroll at the moment but too far (as shown: http://i.imgur.com/4YBHXgs.png)
      singulars
      1. POAnchor Cycler / Dropdown to import school class data periodically
      1. USDennis Sylvian
    3. CO@DennisSylvian Please See my updated answer
      singulars
      1. POAnchor Cycler / Dropdown to import school class data periodically
      1. USSijav
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload