Reply to thread

Message

<blockquote data-quote="vaulient2" data-source="post: 199981" data-attributes="member: 29433">Ok I followed the tut properly , the page works fine and the table within the table problem is fixedc , but now it still would not paginate&nbsp;[code]&lt;?php/*Place code to connect to your DB here.*/include('config.php');// include your code to connect to DB.$tbl_name=&quot;cms_comments&quot;;//your table name// How many adjacent pages should be shown on each side?$adjacents = 6;/* &nbsp; First get total number of rows in data table. &nbsp; If you have a WHERE clause in your query, make sure you mirror it here.*/$query = &quot;SELECT COUNT(*) as num FROM $tbl_name&quot;;$total_pages = mysql_fetch_array(mysql_query($query));$total_pages = $total_pages[num];&nbsp;/* Setup vars for query. */$targetpage = &quot;news.php&quot;;//your file name&nbsp; (the name of this file)$limit = 5;//how many items to show per page$page = $_GET['page'];if($page) $start = ($page - 1) * $limit;//first item to display on this pageelse$start = 0;//if no page var is given, set start to 0/* Get data. */$sql = &quot;SELECT comment FROM $tbl_name LIMIT $start, $limit&quot;;$result = mysql_query($sql);/* Setup page vars for display. */if ($page == 0) $page = 1;//if no page var is given, default to 1.$prev = $page - 1;//previous page is page - 1$next = $page + 1;//next page is page + 1$lastpage = ceil($total_pages/$limit);//lastpage is = total pages / items per page, rounded up.$lpm1 = $lastpage - 1;//last page minus 1/* Now we apply our rules and draw the pagination object. We're actually saving the code to a variable in case we want to draw it more than once.*/$pagination = &quot;&quot;;if($lastpage &gt; 1){$pagination .= &quot;&lt;div class=\&quot;pagination\&quot;&gt;&quot;;//previous buttonif ($page &gt; 1) $pagination.= &quot;&lt;a href=\&quot;$targetpage?page=$prev\&quot;&gt;? previous&lt;/a&gt;&quot;;else$pagination.= &quot;&lt;span class=\&quot;disabled\&quot;&gt;? previous&lt;/span&gt;&quot;;&nbsp;//pagesif ($lastpage &lt; 7 + ($adjacents * 2))//not enough pages to bother breaking it up{for ($counter = 1; $counter &lt;= $lastpage; $counter++){if ($counter == $page)$pagination.= &quot;&lt;span class=\&quot;current\&quot;&gt;$counter&lt;/span&gt;&quot;;else$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=$counter\&quot;&gt;$counter&lt;/a&gt;&quot;;}}elseif($lastpage &gt; 5 + ($adjacents * 2))//enough pages to hide some{//close to beginning; only hide later pagesif($page &lt; 1 + ($adjacents * 2)){for ($counter = 1; $counter &lt; 4 + ($adjacents * 2); $counter++){if ($counter == $page)$pagination.= &quot;&lt;span class=\&quot;current\&quot;&gt;$counter&lt;/span&gt;&quot;;else$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=$counter\&quot;&gt;$counter&lt;/a&gt;&quot;;}$pagination.= &quot;...&quot;;$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=$lpm1\&quot;&gt;$lpm1&lt;/a&gt;&quot;;$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=$lastpage\&quot;&gt;$lastpage&lt;/a&gt;&quot;;}//in middle; hide some front and some backelseif($lastpage - ($adjacents * 2) &gt; $page &amp;&amp; $page &gt; ($adjacents * 2)){$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=1\&quot;&gt;1&lt;/a&gt;&quot;;$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=2\&quot;&gt;2&lt;/a&gt;&quot;;$pagination.= &quot;...&quot;;for ($counter = $page - $adjacents; $counter &lt;= $page + $adjacents; $counter++){if ($counter == $page)$pagination.= &quot;&lt;span class=\&quot;current\&quot;&gt;$counter&lt;/span&gt;&quot;;else$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=$counter\&quot;&gt;$counter&lt;/a&gt;&quot;;}$pagination.= &quot;...&quot;;$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=$lpm1\&quot;&gt;$lpm1&lt;/a&gt;&quot;;$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=$lastpage\&quot;&gt;$lastpage&lt;/a&gt;&quot;;}//close to end; only hide early pageselse{$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=1\&quot;&gt;1&lt;/a&gt;&quot;;$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=2\&quot;&gt;2&lt;/a&gt;&quot;;$pagination.= &quot;...&quot;;for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter &lt;= $lastpage; $counter++){if ($counter == $page)$pagination.= &quot;&lt;span class=\&quot;current\&quot;&gt;$counter&lt;/span&gt;&quot;;else$pagination.= &quot;&lt;a href=\&quot;$targetpage?page=$counter\&quot;&gt;$counter&lt;/a&gt;&quot;;}}}&nbsp;//next buttonif ($page &lt; $counter - 1) $pagination.= &quot;&lt;a href=\&quot;$targetpage?page=$next\&quot;&gt;next ?&lt;/a&gt;&quot;;else$pagination.= &quot;&lt;span class=\&quot;disabled\&quot;&gt;next ?&lt;/span&gt;&quot;;$pagination.= &quot;&lt;/div&gt;\n&quot;;}?&gt;&lt;?phpwhile($row = mysql_fetch_array($result)){echo '&lt;table width=&quot;528px&quot;&gt;';&nbsp; &nbsp; &nbsp; &nbsp; while($Comments = mysql_fetch_array($getComments)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getUserInfo = mysql_query(&quot;SELECT * FROM users WHERE username = '&quot;.$Comments['author'].&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $userInfo = mysql_fetch_array($getUserInfo);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;90px&quot; valign=&quot;top&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;height: 65px;width: 50px;float: left;overflow: hidden;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;float:left&quot;&gt;&lt;img position:absolute; src=&quot;http://www.habbo.fr/habbo-imaging/avatarimage?figure='.$userInfo['look'].'&amp;size=s&amp;direction=2&amp;head_direction=3&amp;gesture=sml&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;427px&quot; valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;i&gt;&lt;a href=&quot;/me&quot;&gt;'.$userInfo['username'].' &lt;/a&gt;&lt;/i&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&lt;br /&gt;'.$Comments['comment'].'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;80px&quot; valign=&quot;top&quot;&gt;&lt;/td&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td width=&quot;400px&quot; align=&quot;right&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br/&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;width:125%; height:1px; background-color:#ccc; margin-top:-17px;&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; echo '&lt;/table&gt;';}?&gt;&nbsp;&lt;?=$pagination?&gt;[/code]&nbsp;<a href="http://prntscr.com/11o8od" target="_blank">http://prntscr.com/11o8od</a></blockquote>

[QUOTE="vaulient2, post: 199981, member: 29433"] Ok I followed the tut properly , the page works fine and the table within the table problem is fixedc , but now it still would not paginate [code]<?php /* Place code to connect to your DB here. */ include('config.php');// include your code to connect to DB. $tbl_name="cms_comments";//your table name // How many adjacent pages should be shown on each side? $adjacents = 6; /* First get total number of rows in data table. If you have a WHERE clause in your query, make sure you mirror it here. */ $query = "SELECT COUNT(*) as num FROM $tbl_name"; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages = $total_pages[num]; /* Setup vars for query. */ $targetpage = "news.php";//your file name (the name of this file) $limit = 5;//how many items to show per page $page = $_GET['page']; if($page) $start = ($page - 1) * $limit;//first item to display on this page else $start = 0;//if no page var is given, set start to 0 /* Get data. */ $sql = "SELECT comment FROM $tbl_name LIMIT $start, $limit"; $result = mysql_query($sql); /* Setup page vars for display. */ if ($page == 0) $page = 1;//if no page var is given, default to 1. $prev = $page - 1;//previous page is page - 1 $next = $page + 1;//next page is page + 1 $lastpage = ceil($total_pages/$limit);//lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1;//last page minus 1 /* Now we apply our rules and draw the pagination object. We're actually saving the code to a variable in case we want to draw it more than once. */ $pagination = ""; if($lastpage > 1) { $pagination .= "<div class=\"pagination\">"; //previous button if ($page > 1) $pagination.= "<a href=\"$targetpage?page=$prev\">? previous</a>"; else $pagination.= "? previous"; //pages if ($lastpage < 7 + ($adjacents * 2))//not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } } elseif($lastpage > 5 + ($adjacents * 2))//enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } $pagination.= "..."; $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>"; $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>"; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "<a href=\"$targetpage?page=1\">1</a>"; $pagination.= "<a href=\"$targetpage?page=2\">2</a>"; $pagination.= "..."; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } $pagination.= "..."; $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>"; $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>"; } //close to end; only hide early pages else { $pagination.= "<a href=\"$targetpage?page=1\">1</a>"; $pagination.= "<a href=\"$targetpage?page=2\">2</a>"; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } } } //next button if ($page < $counter - 1) $pagination.= "<a href=\"$targetpage?page=$next\">next ?</a>"; else $pagination.= "next ?"; $pagination.= "</div>\n"; } ?> <?php while($row = mysql_fetch_array($result)) { echo '<table width="528px">'; while($Comments = mysql_fetch_array($getComments)){ $getUserInfo = mysql_query("SELECT * FROM users WHERE username = '".$Comments['author']."'"); $userInfo = mysql_fetch_array($getUserInfo); echo '<tr> <td width="90px" valign="top"></div> <div style="height: 65px;width: 50px;float: left;overflow: hidden;"> <div style="float:left"><img position:absolute; src="http://www.habbo.fr/habbo-imaging/avatarimage?figure='.$userInfo['look'].'&size=s&direction=2&head_direction=3&gesture=sml"></div> </td> <td width="427px" valign="top"> <a href="/me">'.$userInfo['username'].' </a> '.$Comments['comment'].' </td> </tr> <tr> <td width="80px" valign="top"></td> <td width="400px" align="right"> </div></div></div></div> <div style="width:125%; height:1px; background-color:#ccc; margin-top:-17px;"></div> </td> </tr>'; } echo '</table>'; } ?> <?=$pagination?>[/code] [url]http://prntscr.com/11o8od[/url] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members