Server status page, Multiple pages

**Nikki** · 06-16-2009, 03:31 AM

If a page has more than 20 SQL results how would i make it make a new page with the next set of results? im not really familiar with SQL querys, i use this code to print each Query to the table.

Code:

if ($Result) {
while ($Row = mysql_fetch_array ($Result)) {
@mysql_connect($Host, $User, $Password) or die(mysql_error());
@mysql_select_db ($DBName) or die(mysql_error());
$checkCurr = @fsockopen("$Row[IP]", "$Row[Port]", $ERRNO, $ERRSTR, 1);
$total = "$Row[Total] + 1";

echo ('<tr>');
echo ('<td class="lista">');
echo ("<a href=serverstatus.php?server=$Row[IP]><b>$Row[Name]</b></a>");
echo ('</td>');
echo ('<td class="lista">');
print ("$Row[IP]");
echo ('</td>');

The $Row is the query, So im wondering how after a certain number it puts the next set to next page?

John Doe · 06-16-2009, 05:24 AM

Use some form of offset, and then on the main page display where the offset starts.

Example:

Code:


status.php?offset=20;

Would start at #20

Get it?

**Nikki** · 06-16-2009, 05:27 AM

Originally Posted by John Doe

Use some form of offset, and then on the main page display where the offset starts.

Example:

Code:


status.php?offset=20;

Would start at #20

Get it?

or use a While statement like that, But add in there if($count=0 && $count <= 20? Idk rly I mean like how to start the Querys at 20, i know the methods, just need to know how to make the row start at 20

**king free** · 06-16-2009, 07:55 PM

[Only registered and activated users can see links. ]

That should help you.

EDIT:

Code:

if ($Result) {

Don't do that. Read up on what mysql_query() returns, a resource id doesn't evaluate back to true, which means that statement should never complete. But if the query failed it would return false, and then it still wouldn't complete...

**Nikki** · 06-16-2009, 11:38 PM

Originally Posted by king free

[Only registered and activated users can see links. ]

That should help you.

EDIT:

Code:

if ($Result) {

Don't do that. Read up on what mysql_query() returns, a resource id doesn't evaluate back to true, which means that statement should never complete. But if the query failed it would return false, and then it still wouldn't complete...

That would be when the Page returns a Mysql error i guess, Thanks that should help, so far page is looking good
Unless i re do the whole page, i cant get it working. for some reason the page messes up

**DJ Dan** · 06-24-2009, 11:11 PM

Cleaned for you.

Also, look up LIMIT (sql)

e.g

Code:

$query = mysql_query("SELECT * FROM table ORDER BY id LIMIT 0,30");

Would display 30 rows.

Code:

$query = mysql_query("SELECT * FROM table ORDER BY id LIMIT 15,30");

Would display 15 rows.

Its hard to explain because ORDER BY id changes everything.

**Mortenrb** · 06-27-2009, 08:19 PM

Originally Posted by DJ Dan

Cleaned for you.

Also, look up LIMIT (sql)

e.g

Code:

$query = mysql_query("SELECT * FROM table ORDER BY id LIMIT 0,30");

Would display 30 rows.

Code:

$query = mysql_query("SELECT * FROM table ORDER BY id LIMIT 15,30");

Would display 15 rows.

Its hard to explain because ORDER BY id changes everything.

Code #1 would get the first 31 rows (0-30)
On code #1 you could do as easy as:

Code:

$query = mysql_query("SELECT * FROM table ORDER BY id LIMIT 30");

But that is what I would choose.

if you do:

Code:

$query = mysql_query("SELECT * FROM table LIMIT 30");

It will choose the 31 first row in the MySQL database that you input in it.

Code #2 would get the rows from 15 (16 acctually, because MySQL counts in 0) to 30

Order by is set to ASC as default, and by this I mean that it counts from bottom to top. (1, 2, 3, 4, 5, 6 etc.)

It is kindof hard to explain, but if you need some help, mail me on:
[Only registered and activated users can see links. ] <-- Not for chatting, only e-mail.
Don't bother pming me, I never checks pms anyway, and if you want my chatmail, mail me asking for it.

Brugerman · 06-27-2009, 08:35 PM

It's called pagination if i'm correct.
just google it if the posts before this one didn't help.
heaps of tutorials on how to use it.

**Graham** · 06-27-2009, 08:39 PM

Originally Posted by king free

Don't do that. Read up on what mysql_query() returns, a resource id doesn't evaluate back to true, which means that statement should never complete. But if the query failed it would return false, and then it still wouldn't complete...

It will check if the resource is valid so it will indeed work.

And you should note you can use a range in the LIMIT, so you probably want to do:

LIMIT offset, number of results

**king free** · 06-28-2009, 04:30 PM

Originally Posted by Graham

It will check if the resource is valid so it will indeed work.

And you should note you can use a range in the LIMIT, so you probably want to do:

LIMIT offset, number of results

Thinking about it, you're right, if($var) also does the same job pretty much as, if(isset($var)) as well as, if true etc.

Thread: Server status page, Multiple pages

Thread Tools

Users Browsing this Thread

User Tag List