1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / tapnaire.live / user /
Filename : posts.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('includes/checklogin.php');
check_login();
$title="Dashboard";
$uip=$_SERVER['REMOTE_ADDR'];
include 'includes/header.php'; 

$uid= $_SESSION['id'];
$username=$_SESSION['username'];
$sql = "SELECT * FROM `users` WHERE `id`=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);

$is_vendor=$user['is_vendor'];
$is_publisher=$user['is_publisher'];
$coupon_account=$user['coupon_account_bal'];
 
if($is_publisher == '0'){
    echo "<script>window.location.href='index.php';</script>";
}
?>

 <!-- Main Wrapper-->
 <main class="main-wrapper">
            <div class="container-fluid">
                <div class="inner-contents">
                    <div class="page-header d-flex align-items-center justify-content-between mr-bottom-30">
                        <div class="left-part">
                            <h2 class="text-dark">Sponsored Posts</h2>
                            <p class="text-gray mb-0"><label id="lblGreetings"></label></p>
                        </div>
                        <div class="right-part">
                        <form id="plan-form" onsubmit="generateCouponCode(event)">
                        
                        <select id="plan-select" name="plan" style="display:none">
                        </select>
                        <a href="add-post.php" class="btn btn-primary rounded-2 ff-heading fs-18 fw-bold py-4">
                        <i class="bi bi-plus  me-1"></i> New Post
                        </a>
                    </form>					
                        </div>
                    </div>

                    
                        <div class="col-xxl-6 col-lg-12">
                            <div class="row">
                                <div class="col col-12">
                                    <div class="card border-0 shadow-sm py-3">
                                        <div class="card-body py-4">
                                            <div class="d-flex align-items-center justify-content-between gap-2 flex-wrap">
                                                <div class="d-flex align-items-center gap-0 flex-wrap col-9">
                                                    <div class=""> 
                                                        <h4 class="mb-3">Total Posts Uploaded</h4>
                                                        <p class="text-gray mb-0">
                                                    <?php 
                                                $query="SELECT * FROM `tasks` WHERE `publisher_id`='$uid' ";
                                                $result=mysqli_query($con,$query);
                                                $num_rows = mysqli_num_rows($result);
                                                {
                                                    echo htmlentities($num_rows); 
                                                } 
                                                if($num_rows >1){
                                                    echo ' Posts';
                                                }else{
                                                echo ' Post';
                                                }
                                                ?> 	
														</p>
                                                    </div>
                                                </div>
                                                
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

							
			    <div class="nk-block nk-block-lg">
								<div class="nk-block-head-sm">
									<div class="nk-block-between">
										<div class="nk-block-head-content">
											<h5 class="nk-block-title">Uploaded Posts<span class="count text-base"></span></h5></div>
									</div>
								</div>
                                <div class="card border-0">
								<div class="dropdown-widget p-5">
                                                    <div class="dropdown-wrapper">
                                <ul class="notification-board list-unstyled">
                  <?php 
                    $query="SELECT * FROM `tasks` WHERE `publisher_id`='$uid' ORDER BY `id` DESC LIMIT 10";
                    $result=mysqli_query($con,$query);
                    $cnt=1;
                    if(mysqli_num_rows($result)>0){
                    while($row=mysqli_fetch_array($result)){
                    $title = $row['title'];
                    $description = $row['description'];
                    $image = $row['image'];
                    $status =$row['status'];

                    $date_string=$row['created_at'];// date retrieved from database
                    $timestamp = strtotime($date_string); // convert date string to Unix timestamp
                    $date = date("jS \of F Y", $timestamp);// format timestamp into words                   
             ?>

                                        <li class="author-online has-new-message">
											<div  href="#" class=" d-flex gap-3">
												<div class="media  d-sm-block">
													<img src="../admin/uploads/<?php echo $image;?>" alt="img" width="60" class="rounded-2">
												</div>
												<div class="user-message">
													<h6 class="message mb-1">Caption: <?php echo htmlentities($row['title']);?> <span class="fs-12 fw-normal text-gray float-end"> <?php echo htmlentities($date);?></span></h6>
													<p class="message-footer d-flex align-items-center justify-content-between"><?php echo htmlentities($description);?></p>
												</div>
                                            </div>
										</li>

		
                                    <?php } 
                    }else{

                      echo"
                      <div class='nk-block-des' style='text-align:center;margin-top:5vh;'>
                      <h4>Oops!</h4>
                      <p>You don't have any post history</p>
                  </div>
                     
                      ";
                    }
                    ?>

                </ul>			</div>
							</div>
						</div>
					</div>
				</div>
			</div>

                </main>


    <script src="assets/js/coupon-script.js"></script>
    <?php include 'bottom-tabs.php' ?>
<?php include 'includes/footer.php' ?>