CMS/function.php at master · alexroden/CMS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<?php
    function entries() {
        global $db;
        $query = "SELECT * FROM posts";
        $select_all_posts = mysqli_query($db, $query);

        while($row = mysqli_fetch_assoc($select_all_posts)) {
            $post_title = $row['post_title'];
            $post_author = $row['post_author'];
            $post_date = $row['post_date'];
            $post_image = $row['post_image'];
            $post_content = $row['post_content'];

            echo "<h2>
                    <a href='#'>{$post_title}</a>
                </h2>";
            echo "<p class='lead'>
                    by <a href='index.php'>{$post_author}</a>
                </p>";
            echo "<p>
                    <span class='glyphicon glyphicon-time'></span>
                    Posted on {$post_date}
                </p>";
            echo "<hr>
                    <img class='img-responsive' src='imgs/{$post_image}' alt=''>
                <hr>";
            echo "<p>
                    {$post_content}
                </p>";
            echo "<a class='btn btn-primary' href='#'>
                    Read More <span class='glyphicon glyphicon-chevron-right'></span>
                </a>
                <hr>";
        }
    }

    function cat_side_loop() {
        global $db;
        $query = "SELECT * FROM categories LIMIT 4";
        $select_cat_sidebar = mysqli_query($db, $query);
        while($row = mysqli_fetch_assoc($select_cat_sidebar)) {
            $cat_title = $row['cat_title'];
            echo "<li><a href=''>{$cat_title}</a></li>";
        }
    }

?>