PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- <?PHP require('includes/config.php'); ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <title>Blog</title>
- <link rel="stylesheet" href="style/normalize.css">
- <link rel="stylesheet" href="style/main.css">
- </head>
- <body>
- <div id="wrapper">
- <h1>Blog</h1>
- <hr />
- <div id='main'>
- <?PHP
- try {
- $pages = new Paginator('10','p');
- $stmt = $db->query('SELECT postID FROM blog_posts_seo');
- //pass number of records to
- $pages->set_total($stmt->rowCount());
- $stmt = $db->query('SELECT postID, postTitle, postSlug, postDesc, postDate FROM blog_posts_seo ORDER BY postID DESC '.$pages->get_limit());
- while($row = $stmt->fetch()){
- echo '<h1><a href="'.$row['postSlug'].'">'.$row['postTitle'].'</a></h1>';
- $stmt2 = $db->prepare('SELECT catTitle, catSlug FROM blog_cats, blog_post_cats WHERE blog_cats.catID = blog_post_cats.catID AND blog_post_cats.postID = :postID');
- $catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC);
- foreach ($catRow as $cat)
- {
- $links[] = "<a href='c-".$cat['catSlug']."'>".$cat['catTitle']."</a>";
- }
- echo '</p>';
- echo '<p>'.$row['postDesc'].'</p>';
- echo '<p><a href="'.$row['postSlug'].'">Read More</a></p>';
- }
- echo $pages->page_links();
- } catch(PDOException $e) {
- echo $e->getMessage();
- }
- ?>
- </div>
- <div id='sidebar'>
- <?PHP require('sidebar.php'); ?>
- </div>
- <div id='clear'></div>
- </div>
- </body>
- </html>