Databases
StackOverflow2013
Postsdbo
POCould somebody help me to make pagination?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCould somebody help me to make pagination?
    text
    copied!<p>edited>> Your posts don't help me at all I made this </p> <pre><code>function lgsl_query_css_all($request) { global $lgsl_config; lgsl_database(); $eiluciu_psl = 2; $psl_num = 1; if (isset($_GET['puslapis'])) { $psl_num = $_GET['puslapis']; } $offset = ($psl_num-1)* $eiluciu_psl; $mysql_query = "SELECT `type`,`ip`,`c_port`,`q_port`,`s_port` FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` WHERE `disabled`=0 ORDER BY `cache_time` ASC LIMIT $offset,$eiluciu_psl"; $mysql_result = mysql_query($mysql_query) or die(mysql_error()); $server_list = array(); while ($mysql_row = mysql_fetch_array($mysql_result, MYSQL_ASSOC)) { if (strpos($request, "c") === FALSE &amp;&amp; lgsl_timer("check")) { $request .= "c"; } $server = lgsl_query_cached($mysql_row['type'], $mysql_row['ip'], $mysql_row['c_port'], $mysql_row['q_port'], $mysql_row['s_port'], $request); if ($lgsl_config['hide_offline'][0] &amp;&amp; !$server['b']['status']) { continue; } $server_list[] = $server; } $query_count = "SELECT COUNT(id) AS numrows FROM lgsl"; $result_count = mysql_query($query_count) or die (mysql_error()); $row = mysql_fetch_array($result_count,MYSQL_ASSOC); $numrows = $row['numrows']; $max_psl = ceil($numrows/$eiluciu_psl); $self = $_SERVER['PHP_SELF']; $nav = ''; for($puslapis = 1; $puslapis &lt;= $max_psl; $puslapis++) { if ($puslapis == $psl_num) { $nav .= " $puslapis "; } else { $nav .= " &lt;a href=\"$self?puslapis=$puslapis\"&gt;$puslapis&lt;/a&gt; "; } } if ($psl_num &gt; 1) { $puslapis = $psl_num - 1; $prev = " &lt;a href=\"$self?puslapis=$puslapis\" class=\"prevnext\"&gt;« &lt;&lt;&lt;/a&gt; "; $first = " &lt;a href=\"$self?puslapis=1\" class=\"currentpage\"&gt;1&lt;/a&gt; "; } else { $prev = '&amp;nbsp;'; $first = '&amp;nbsp;'; } if ($psl_num &lt; $max_psl) { $puslapis = $psl_num + 1; $next = " &lt;a href=\"$self?puslapis=$puslapis\" class=\"prevnext\"&gt;&gt;&gt;&lt;/a&gt; "; $last = " &lt;a href=\"$self?puslapis=$max_psl\" class=\"currentpage\"&gt;$max_psl&lt;/a&gt; "; } else { $next = '&amp;nbsp;'; $last = '&amp;nbsp;'; } // 1-4 $vienas = $psl_num + 1; if($vienas &lt; $max_psl) { $vienas_echo = "&lt;a href=\"$self?puslapis=$vienas\"&gt;$vienas&lt;/a&gt;"; } else { $vienas_echo = "&amp;nbsp;"; } $du = $psl_num + 2; if($du &lt; $max_psl) { $du_echo = "&lt;a href=\"$self?puslapis=$du\"&gt;$du&lt;/a&gt;"; } else { $du_echo = "&amp;nbsp;"; } $trys = $psl_num + 3; if($trys &lt; $max_psl) { $trys_echo = "&lt;a href=\"$self?puslapis=$trys\"&gt;$trys&lt;/a&gt;"; } else { $trys_echo = "&amp;nbsp;"; } $keturi = $psl_num + 4; if($keturi &lt; $max_psl) { $keturi_echo = "&lt;a href=\"$self?puslapis=$keturi\"&gt;$keturi&lt;/a&gt;"; } else { $keturi_echo = "&amp;nbsp;"; } // 10-40 $desimt = $psl_num + 10; if($desimt &lt; $max_psl) { $desimt_echo = "&lt;a href=\"$self?puslapis=$desimt\"&gt;$desimt&lt;/a&gt;"; } else { $desimt_echo = "&amp;nbsp;"; } $dvim = $psl_num + 20; if($dvim &lt; $max_psl) { $dvim_echo = "&lt;a href=\"$self?puslapis=$dvim\"&gt;$dvim&lt;/a&gt;"; } else { $dvim_echo = "&amp;nbsp;"; } $trim = $psl_num + 30; if($trim &lt; $max_psl) { $trim_echo = "&lt;a href=\"$self?puslapis=$trim\"&gt;$trim&lt;/a&gt;"; } else { $trim_echo = "&amp;nbsp;"; } $kiam = $psl_num + 40; if($kiam &lt; $max_psl) { $kiam_echo = "&lt;a href=\"$self?puslapis=$kiam\"&gt;$kiam&lt;/a&gt;"; } else { $kiam_echo = "&amp;nbsp;"; } $be = $puslapis -1; $dabar = "&lt;a href=\"$self?puslapis=$be\"&gt;" . $be . "&lt;/a&gt;"; echo "&lt;div class=\"pagination\" align=\"center\"&gt;&lt;ul&gt;&lt;li&gt;" . $prev . "&lt;/li&gt;&lt;li&gt;" . $first . "&lt;/li&gt;&lt;li&gt;$dabar&lt;/li&gt;&lt;li&gt; &lt;/li&gt;&lt;li&gt;" . $vienas_echo . "&lt;/li&gt;&lt;li&gt;" . $du_echo . "&lt;/li&gt;&lt;li&gt;" . $trys_echo . "&lt;/li&gt;&lt;li&gt;" . $keturi_echo . "&lt;/li&gt;&lt;li&gt; &lt;strong&gt;...&lt;/strong&gt; &lt;/li&gt;&lt;li&gt;" . $desimt_echo . "&lt;/li&gt;&lt;li&gt;" . $dvim_echo . "&lt;/li&gt;&lt;li&gt;" . $trim_echo . "&lt;/li&gt;&lt;li&gt;" . $kiam_echo . "&lt;/li&gt;&lt;li&gt;" . $last . "&lt;/li&gt;&lt;li&gt;" . $next . "&lt;/li&gt;&lt;/ul&gt;&lt;/div&gt;"; return $server_list; } $output .= " &lt;div style='text-align:center; font-size:10px; font-face:arial'&gt; &lt;table id='myTable' cellpadding='3' cellspacing='1' style='margin:auto' class='boxes' &gt; &lt;thead&gt; &lt;tr class='lgsl'&gt; &lt;th class='lgsl' style='width:20px;' title='Server Status'&gt;On/Off&lt;/th&gt; &lt;th class='lgsl' style='width:25px;' title='Game'&gt;Gra&lt;/th&gt; &lt;th class='lgsl' style='width:150px;' title='IP address and Port'&gt;IP Serwera&lt;/th&gt; &lt;th class='lgsl' style='width:200px;' title='Server Name'&gt;Nazwa Serwera&lt;/th&gt; &lt;th class='lgsl' style='width:85px;' title='Current Map'&gt;Mapa&lt;/th&gt; &lt;th class='lgsl' style='width:60px;' title='Players online'&gt;Graczy&lt;/th&gt; &lt;th class='lgsl' style='width:100px;' title='User Rating'&gt;Szczegoly&lt;/th&gt; &lt;/tr&gt; &lt;/thead&gt;"; foreach ($server_list as $server) { $misc = lgsl_server_misc($server); $server = lgsl_server_html($server); $output .= " &lt;tr style='".lgsl_bg().";table-layout:fixed'&gt; &lt;td&gt; &lt;img alt='' src='{$misc['icon_status']}' title='{$misc['text_status']}' /&gt; &lt;/td&gt; &lt;td&gt; &lt;img alt='' src='{$misc['icon_game']}' title='{$misc['text_type_game']}' /&gt; &lt;/td&gt; &lt;td title='{$lgsl_config['text']['slk']}' style='text-align:center'&gt; &lt;a href='steam://{$misc['software_link']}' class='Tips1' title=' Connect {$server['b']['ip']}:{$server['b']['c_port']}'&gt; {$server['b']['ip']}:{$server['b']['c_port']} &lt;/a&gt; &lt;/td&gt; &lt;td title='{$server['s']['name']}' style='text-align:center'&gt; &lt;div style='width:100%; overflow:hidden; height:1.3em'&gt; {$misc['name_filtered']} &lt;/div&gt; &lt;/td&gt; &lt;td style='white-space:nowrap; text-align:center'&gt; {$server['s']['map']} &lt;/td&gt; &lt;td style='white-space:nowrap; text-align:center'&gt; {$server['s']['players']} / {$server['s']['playersmax']} &lt;/td&gt; &lt;td style='white-space:nowrap; text-align:center'&gt; &lt;a href='".lgsl_link($server['o']['id'])."'&gt; &lt;img alt='' src='{$misc['icon_details']}' style='border:none' title='{$lgsl_config['text']['vsd']}' /&gt; &lt;/a&gt; &lt;/td&gt; &lt;/tr&gt;"; } $output .= " &lt;/table&gt; &lt;/div&gt;"; </code></pre> <p>But it looks ugly so i thought someone has better solution</p> <p><a href="http://img851.imageshack.us/img851/820/unledoxy.png" rel="nofollow">http://img851.imageshack.us/img851/820/unledoxy.png</a> and i need somehow to place it under the server list</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