BlogPlus/author_post.php at master · aliasgar12/BlogPlus · 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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
<?php include "includes/db.php";?>
<?php include "includes/header.php";?>


    <!-- Navigation -->

    <?php include "includes/navigation.php";?>

    <!-- Page Content -->
    <div class="container">

        <div class="row">

            <!-- Blog Entries Column -->
            <div class="col-md-8">

            <?php


                if(isset($_GET['p_id'])){

                    $the_post_id= $_GET['p_id'];
                    $the_post_author= $_GET['post_author'];


                $query = "SELECT * from posts WHERE post_author= '$the_post_author'";
                $post_selected = mysqli_query($connection, $query);

                while($row = mysqli_fetch_assoc($post_selected)){

                    $p_id= $row['post_id'];
                    $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'];


                    ?>

                <h1 class="page-header">
                    Page Heading
                    <small>Secondary Text</small>
                </h1>

                <!-- First Blog Post -->
                <h2>
                    <a href="post.php?p_id=<?php echo $p_id;?>"><?php echo $post_title?></a>
                </h2>
                <p class="lead">
                    by <?php echo $post_author ?>
                </p>
                <p><span class="glyphicon glyphicon-time"></span> Posted on <?php echo $post_date ?></p>
                <hr>
                <img class="img-responsive" src="images/<?php echo $post_image?>" alt="">
                <hr>
                <p><?php echo $post_content ?></p>

                <hr>

            <?php
                }
                }
                ?>

                <hr>
      </div>


          <?php include "includes/sidebar.php";?>

        </div>
        <!-- /.row -->


        <hr>

        <!-- Footer -->

        <?php include "includes/footer.php";?>