Databases
StackOverflow2013
Postsdbo
POMySQL -> PHP -> JS/jQuery
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMySQL -> PHP -> JS/jQuery
    text
    copied!<p>I'm a bit confused about displaying data from a MySQL database. I would like to make a single <code>$.getScript('');</code> request to grab point values if possible, but my trouble is getting it to work with multiple members. I need to grab the point values for each user by their ID number. (this is for a forum software- ZetaBoards.. basically a point system. Points are displayed below the users post count.) Here's my code so far.. can also post the PHP stuff if needed. +/- functions work flawlessly, although you don't see those options because you're not a moderator. :p I'm just stuck when it comes to displaying the data. D: Here's the main base of the code.. it's currently being tested on <a href="http://s1.zetaboards.com/RyJoe/index/" rel="nofollow noreferrer">this</a> board.</p> <p><code>http://209.85.62.24/212/175/0/p348841/main.js</code></p> <p>A similar system did something like this... although I don't exactly get how it works. The second link is for 2 users- making only one request like I said. I'm guessing this is what I'd need to do? but how.. that's the question. haha.</p> <p>Only allowed one hyperlink, sooo.. D:</p> <p><code>http://themeszetaboards.com/tokens/getpoints.php?uid=260836</code></p> <p><code>http://themeszetaboards.com/tokens/getpoints.php?uid=260836|195145</code></p> <p>I could probably do this with single requests to a php file, but I'd rather not fire 20+ requests on a single page. (one for each user) xD Any ideas? Thanks. (:</p> <p>Oh: In my MySQL database, I have two fields: 'uid' and 'points'. Sorry if this question is too difficult/specific.</p> <p><b>Edit:</b></p> <p>Alright, so- I figured it out for the most part. Instead of screwing around with the IDs, I just threw 'em all on the same page. Thanks for the help you three. ;D</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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