1. <html>
  2. <head>
  3. <link rel="stylesheet" type="text/css" media="all" href="css/jquery.ias.css" />
  4. <script type='text/javascript' src='http://code.jquery.com/jquery-1.4.4.js'></script>
  5. <script type="text/javascript" src="jquery.ias.js"></script>
  6. <script type="text/javascript">
  7. jQuery.ias({
  8. scrollContainer:'#container',
  9. container : '#container',
  10. item: '.item',
  11. pagination: '.pagination',
  12. next: '.nextpage',
  13. loader: '<img src="images/loader.gif"/>'
  14. });
  15. </script>
  16. <style>
  17. div.pagination {
  18. padding: 3px;
  19. margin: 3px;
  20. }
  22. div.pagination a {
  23. padding: 2px 5px 2px 5px;
  24. margin: 2px;
  25. border: 1px solid #AAAADD;
  27. text-decoration: none; /* no underline */
  28. color: #000099;
  29. }
  30. div.pagination a:hover, div.pagination a:active {
  31. border: 1px solid #000099;
  33. color: #000;
  34. }
  35. div.pagination span.current {
  36. padding: 2px 5px 2px 5px;
  37. margin: 2px;
  38. border: 1px solid #000099;
  40. font-weight: bold;
  41. background-color: #000099;
  42. color: #FFF;
  43. }
  44. div.pagination span.disabled {
  45. padding: 2px 5px 2px 5px;
  46. margin: 2px;
  47. border: 1px solid #EEE;
  49. color: #DDD;
  50. }
  53. </style>
  55. </head>
  57. <body>
  62. <?php
  64. $con = mysql_connect("hostname","database","password");
  65. if (!$con)
  66. {
  67. die('Could not connect: ' . mysql_error());
  68. }
  69. mysql_select_db("database", $con);
  72. /*include 'pag.php'; //pagination script and styling is located here.*/
  74. $tbl_name="ticka_data"; //your table name
  75. // How many adjacent pages should be shown on each side?
  76. $adjacents = 3;
  78. /*
  79. First get total number of rows in data table.
  80. If you have a WHERE clause in your query, make sure you mirror it here.
  81. */
  82. $query = "SELECT COUNT(*) as num FROM $tbl_name";
  83. $total_pages = mysql_fetch_array(mysql_query($query));
  84. $total_pages = $total_pages[num];
  86. /* Setup vars for query. */
  87. $targetpage = "pagination2.php"; //your file name (the name of this file)
  88. $limit = 10; //how many items to show per page
  89. $page = $_GET['page'];
  90. if($page)
  91. $start = ($page - 1) * $limit; //first item to display on this page
  92. else
  93. $start = 0; //if no page var is given, set start to 0
  95. /* Get data. */
  96. $sql = "SELECT title FROM $tbl_name LIMIT $start, $limit";
  97. $result = mysql_query($sql);
  99. /* Setup page vars for display. */
  100. if ($page == 0) $page = 1; //if no page var is given, default to 1.
  101. $prev = $page - 1; //previous page is page - 1
  102. $next = $page + 1; //next page is page + 1
  103. $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
  104. $lpm1 = $lastpage - 1; //last page minus 1
  106. /*
  107. Now we apply our rules and draw the pagination object.
  108. We're actually saving the code to a variable in case we want to draw it more than once.
  109. */
  110. $pagination = "";
  111. if($lastpage > 1)
  112. {
  113. $pagination .= "<div class=\"pagination\">";
  114. //previous button
  115. if ($page > 1)
  116. $pagination.= "<a href=\"$targetpage?page=$prev\"> &lsaquo;&lsaquo; previous</a>";
  117. else
  118. $pagination.= "<span class=\"disabled\"> &lsaquo;&lsaquo; previous</span>";
  120. //pages
  121. if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
  122. {
  123. for ($counter = 1; $counter <= $lastpage; $counter++)
  124. {
  125. if ($counter == $page)
  126. $pagination.= "<span class=\"current\">$counter</span>";
  127. else
  128. $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
  129. }
  130. }
  131. elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
  132. {
  133. //close to beginning; only hide later pages
  134. if($page < 1 + ($adjacents * 2))
  135. {
  136. for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
  137. {
  138. if ($counter == $page)
  139. $pagination.= "<span class=\"current\">$counter</span>";
  140. else
  141. $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
  142. }
  143. $pagination.= "...";
  144. $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
  145. $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
  146. }
  147. //in middle; hide some front and some back
  148. elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
  149. {
  150. $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
  151. $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
  152. $pagination.= "...";
  153. for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
  154. {
  155. if ($counter == $page)
  156. $pagination.= "<span class=\"current\">$counter</span>";
  157. else
  158. $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
  159. }
  160. $pagination.= "...";
  161. $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
  162. $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
  163. }
  164. //close to end; only hide early pages
  165. else
  166. {
  167. $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
  168. $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
  169. $pagination.= "...";
  170. for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
  171. {
  172. if ($counter == $page)
  173. $pagination.= "<span class=\"current\">$counter</span>";
  174. else
  175. $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
  176. }
  177. }
  178. }
  180. //next button
  181. if ($page < $counter - 1)
  182. $pagination.= "<div class=\"nextpage\"><a href=\"$targetpage?page=$next\">next &rsaquo;&rsaquo;</a></div>";
  183. else
  184. $pagination.= "<span class=\"disabled\">next &rsaquo;&rsaquo;</span>";
  185. $pagination.= "</div>\n";
  186. }
  188. ?>
  190. <div id="container" style="height: 100px;
  191. overflow: scroll;">
  192. <?php
  193. while($row = mysql_fetch_array($result))
  194. {
  196. echo "<div class='item'><li>".$row[0]."</li></div>";
  198. // Your while loop here
  200. }
  202. ?>
  205. </div>
  207. <?=$pagination?>
  209. </body>
  210. </html>