Advertisement
kotvalera83

table ajax

Jan 15th, 2013
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 2.71 KB | None | 0 0
  1. <!DOCTYPE HTML>
  2. <head>
  3.     <meta http-equiv="content-type" content="text/html" />
  4.     <title>test</title>
  5.     <script src="http://code.jquery.com/jquery-latest.js"></script>
  6.  
  7. </head>
  8.  
  9. <body>
  10. <?php
  11. $db_host = "127.0.0.1";
  12. $db_user = 'root';
  13. $db_password = '';
  14. $db_name = '3';
  15.  
  16. mysql_connect($db_host, $db_user, $db_password) or die (mysql_error());
  17. mysql_select_db($db_name) or die (mysql_error());
  18. mysql_query("SET NAMES 'utf8'");
  19.  
  20. $num_elements = 20;
  21. $total = mysql_result(mysql_query("SELECT COUNT(*) FROM articles"),0,0);
  22. $num_pages = ceil($total / $num_elements);
  23.  
  24. if(!isset($_GET['page'])){
  25.  $p = 1;
  26. }
  27. else{
  28.  $p = addslashes(strip_tags(trim($_GET['page'])));
  29.  if($p < 1) $p = 1;
  30. }
  31.  
  32. if ($p > $num_pages) $p = $num_pages;
  33.  
  34. $start = ($p - 1) * $num_elements;
  35.  
  36. $sql = mysql_query("SELECT * FROM articles ORDER BY id DESC LIMIT ".$start.", ".$num_elements);
  37.  
  38. function GetNav($p, $num_pages){
  39.  
  40.   if($p > 2){
  41.     $first_page = ' <a href="/index.php?page=1"><<</a> ';   //или просто $first_page = ' <a href="/index.php"><<</a> ';
  42.   }
  43.   else{
  44.     $first_page = '';
  45.  }
  46.  
  47.   if($p < ($num_pages - 2)){
  48.    $last_page = ' <a href="/index.php?page='.$num_pages.'">>></a> ';
  49.   }
  50.   else{
  51.     $last_page = '';
  52.   }
  53.  
  54.   if($p > 1){
  55.     $prev_page = ' <a href="/index.php?page='.($p - 1).'"><</a> ';
  56.   }
  57.   else{
  58.     $prev_page = '';
  59.   }
  60.  
  61.   if($p < $num_pages){
  62.    $next_page = ' <a href="/index.php?page='.($p + 1).'">></a> ';
  63.   }
  64.   else{
  65.     $next_page = '';
  66.   }
  67.  
  68.   if($p - 2 > 0){
  69.     $prev_2_page = ' <a href="/index.php?page='.($p - 2).'">'.($p - 2).'</a> ';
  70.   }
  71.   else{
  72.     $prev_2_page = '';
  73.   }
  74.   if($p - 1 > 0){
  75.     $prev_1_page = ' <a href="/index.php?page='.($p - 1).'"> '.($p - 1).' </a> ';
  76.   }
  77.   else{
  78.     $prev_1_page = '';
  79.   }
  80.   if($p + 2 <= $num_pages){
  81.    $next_2_page = ' <a href="/index.php?page='.($p + 2).'"> '.($p + 2).' </a> ';
  82.   }
  83.   else{
  84.     $next_2_page = '';
  85.   }
  86.   if($p + 1 <= $num_pages){
  87.    $next_1_page = ' <a href="/index.php?page='.($p + 1).'">'.($p + 1).'</a> ';
  88.   }
  89.   else{
  90.     $next_1_page = '';
  91.   }
  92.   $nav = $first_page.$prev_page.$prev_2_page.$prev_1_page.$p.$next_1_page.$next_2_page.$next_page.$last_page;
  93.   return $nav;
  94. }
  95.  
  96. ?>
  97. <div id="load">
  98. <div class="posts"><?php while ($sql_data = mysql_fetch_array($sql)) {
  99.    echo $sql_data['title'];
  100.    echo '<br />';
  101.     echo $sql_data['text'];
  102.     echo '<br /><br />';
  103. }?></div>
  104. <div class="nav"><?php echo GetNav($p, $num_pages);?></div>
  105. </div>
  106. <script type="text/javascript">
  107. <!--
  108. $(function() {
  109.  $(".nav a").click(function() {
  110.    var link = $(this).attr("href");
  111.    $("#load").hide();
  112.    $("body").load(link);
  113.    
  114.    return false;
  115.  });
  116. });
  117. -->
  118. </script>
  119. </body>
  120. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement