blogs/author.php at main · cvasingh/blogs · 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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<?php include 'header.php'; ?>
    <div id="main-content">

                 <!-- post-container -->
                <div class="post-container">
                  <?php

                        if(isset($_GET['aid'])){
                            $aut_id=$_GET['aid'];
                           }
                  $sql1 = "select * from post join user on post.author = user.user_id "
                          . "where post.author = {$aut_id}";
                  $result1 = mysqli_query($conn, $sql1);
                  $total_row= mysqli_fetch_assoc($result1);

                  ?>
                    <h2 class="page-heading"><?php echo $total_row['username'];?></h2>
                            <div class="container">
            <div class="row">
                <div class="col-md-8">
                    <!-- post-container -->
                    <div class="post-container">
                        <div class="post-sroll">
                        <?php
                        include 'common.php';

                        if(isset($_GET['aid'])){
                            $aut_id=$_GET['aid'];
                           }
                    //page
                        $limit = 5;
                        if(isset($_GET['page'])){
                            $page = $_GET['page'];
                        } else {
                            $page = 1;
                        }
                     $offset = ($page - 1) * $limit;
                     $sql = "select * from post "
                            . "left join category on post.category = category.category_id "
                            . "left join user on post.author = user.user_id "
                             . "where post.author ={$aut_id} "
                            . "order by post.post_id desc limit {$offset},{$limit} ";


                        $result = mysqli_query($conn,$sql) or die("query failed");
                           if(mysqli_num_rows($result)>0){
                               while ($row = mysqli_fetch_assoc($result)){

                        ?>
                        <div class="post-content">
                            <div class="row">
                                <div class="col-md-4">
                                    <a class="post-img" href="single.php?id=<?php echo $row['post_id']; ?>"><img src="admin/upload/<?php echo $row['post_img'];?>" alt=""/></a>
                                </div>
                                <div class="col-md-8">
                                    <div class="inner-content clearfix">
                                        <h3><a href='single.php?id=<?php echo $row['post_id']; ?>'><?php echo $row['title'];?></a></h3>
                                        <div class="post-information">
                                            <span>
                                                <i class="fa fa-tags" aria-hidden="true"></i>
                                                <a href='category.php?cid=<?php echo $row['category']; ?>'><?php echo $row['category_name'];?></a>
                                            </span>
                                            <span>
                                                <i class="fa fa-user" aria-hidden="true"></i>
                                                <a href='author.php?aid=<?php echo $row['author']; ?>'><?php echo $row['username'];?></a>
                                            </span>
                                            <span>
                                                <i class="fa fa-calendar" aria-hidden="true"></i>
                                                <?php echo $row['post_date'];?>
                                            </span>
                                        </div>
                                        <p class="description"><?php echo substr($row['description'],0,80)."..."; ?></p>
                                        <a class='read-more pull-right' href='single.php?id=<?php echo $row['post_id']; ?>'>read more</a>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <?php
                               }
                           } else {
                                   echo 'NO POST FOUND!!';
                               }?>
                        </div>
                                   <?php

                     if(mysqli_num_rows($result1) >0){
                        $total_record = mysqli_num_rows($result1);
                        $total_page = ceil($total_record / $limit);

                         echo "<ul class='pagination admin-pagination'>";
                         if($page > 1){
                            echo '<li><a href="index.php?aid='.$aut_id.'&page='.($page-1).'"<i class="fa fa-arrow-left "></a></li>';
                         }
                         for($i=1;$i<=$total_page;$i++){
                            if($i == $page){
                                $active ="background-color:#000;";
                            }else{
                                $active = "";
                            }
                            echo '<li style="'.$active.'"><a href="index.php?aid='.$aut_id.'&page='.$i.'">'.$i.'</a></li>';
                      }
                        if($total_page > $page){
                            echo '<li><a href="index.php?aid='.$aut_id.'&page='.($page+1).'" <i class="fa fa-arrow-right "></a></li>';
                         }
                      echo "</ul>";
                  }

                  ?>
                    </div><!-- /post-container -->
            </div>
            <?php include 'sidebar.php'; ?>
        </div>
      </div>
    </div>
    </div>
<?php include 'footer.php'; ?>