Advertisement
Guest User

Error

a guest
Sep 22nd, 2014
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.21 KB | None | 0 0
  1. <?php
  2.      
  3.     try {
  4.         $conn = new PDO('mysql:host=127.0.0.1;dbname=laikrodis24_funny', 'root', '');
  5.         $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  6.     } catch (PDOEexception $e) {
  7.         echo $e->getMessage();
  8.         die();
  9.     }
  10.      
  11.     $page = (isset($_GET['page']) ? $_GET['page'] : "1");
  12.    
  13.     $max = 5;
  14.     $all = $numRows = $conn->query("SELECT COUNT(*) FROM picture")->fetchColumn();
  15.    
  16.     $start = ($max * $page) - $max;
  17.    
  18.     if ($all <= $max) {
  19.         $num_page = 1;
  20.     } else {
  21.         if (($all % $max) == 0) {
  22.             $num_page = $all / $max;
  23.         } else {
  24.             $num_page = $all / $max + 1;
  25.         }
  26.     }
  27.    
  28.    
  29. $sth = $conn->prepare("SELECT * FROM picture WHERE category = 'chill'");
  30. $sth->execute();
  31.  
  32. $for = $numRows = $conn->query("SELECT COUNT(*) FROM picture  WHERE category = 'chill'")->fetchColumn();
  33.  
  34. if ($for  > 0) {
  35.  
  36.     while($row = $sth->fetch())
  37.     {
  38.         print '<p>"'.$row['title'].'"</p><br><img src="'.$row['img'].'" width="651" height="215" id="img" /><br><h1><a href="'.$row['img'].'" download="'.$row['img'].'"/>Download Cover</a></h1> <hr>';
  39.     }}
  40.      
  41.  
  42.     echo "Page: ";
  43.     for ($i=1; $i<=$num_page; $i++) {
  44.         if ($i != $page) { echo "<a href=\"index.php?page=chill=$i\">$i</a>"; }
  45.         else { echo "<b>$i</b>"; }
  46.     };
  47. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement