Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- try {
- $conn = new PDO('mysql:host=127.0.0.1;dbname=laikrodis24_funny', 'root', '');
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- } catch (PDOEexception $e) {
- echo $e->getMessage();
- die();
- }
- $page = (isset($_GET['page']) ? $_GET['page'] : "1");
- $max = 5;
- $all = $numRows = $conn->query("SELECT COUNT(*) FROM picture")->fetchColumn();
- $start = ($max * $page) - $max;
- if ($all <= $max) {
- $num_page = 1;
- } else {
- if (($all % $max) == 0) {
- $num_page = $all / $max;
- } else {
- $num_page = $all / $max + 1;
- }
- }
- $sth = $conn->prepare("SELECT * FROM picture WHERE category = 'chill'");
- $sth->execute();
- $for = $numRows = $conn->query("SELECT COUNT(*) FROM picture WHERE category = 'chill'")->fetchColumn();
- if ($for > 0) {
- while($row = $sth->fetch())
- {
- 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>';
- }}
- echo "Page: ";
- for ($i=1; $i<=$num_page; $i++) {
- if ($i != $page) { echo "<a href=\"index.php?page=chill=$i\">$i</a>"; }
- else { echo "<b>$i</b>"; }
- };
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement