D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
ipuco
/
public_html
/
superadmin
/
Filename :
list-of-adpostdata.php
back
Copy
<?php ob_start(); session_start(); include('include/connection.php'); $emailid=$_SESSION['emailid']; $adminid=$_SESSION['id']; $per=mysqli_query($conn,"select * from admin where id='".$adminid."'"); $perq1=mysqli_fetch_array($per); if (!(isset($_SESSION['emailid']) && $_SESSION['emailid'] != '')) { header ("Location: index.php"); } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width,initial-scale=1,user-scalable=0,minimal-ui"> <title>IPU - Ad Post Data </title> <meta content="Admin Dashboard" name="description"> <meta content="Themesbrand" name="author"> <link rel="shortcut icon" href="assets/images/favicon.ico"> <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css"> <link href="assets/css/metismenu.min.css" rel="stylesheet" type="text/css"> <link href="assets/css/icons.css" rel="stylesheet" type="text/css"> <link href="assets/css/style.css" rel="stylesheet" type="text/css"> </head> <body> <!-- Begin page --> <div id="wrapper"> <!-- Top Bar Start --> <?php include('include/top-header.php');?> <!-- Top Bar End --> <!-- ========== Left Sidebar Start ========== --> <div class="left side-menu"> <?php include('include/left-menu.php');?> <!-- Sidebar -left --> </div> <!-- Left Sidebar End --> <!-- ============================================================== --> <!-- Start right Content here --> <!-- ============================================================== --> <div class="content-page"> <!-- Start content --> <div class="content"> <div class="container-fluid"> <div class="page-title-box"> <div class="row align-items-center"> <div class="col-sm-10"> <h4 class="page-title">Ad Post Data Management</h4> <ol class="breadcrumb"> <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li> <li class="breadcrumb-item active">List Of Ad Post Data</li> </ol> </div> <div class="col-sm-2"> </div> </div> </div> <!-- end row --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body"> <h4 class="mt-0 header-title"><i class="ti-agenda text-primary mr-2"></i>List Of Ad Post Data (<?php $result = mysqli_query($conn,"SELECT * FROM posr_free_add"); $num_rows = mysqli_num_rows($result); echo "$num_rows"; ?>)</h4> <p class="text-muted m-b-30"></p> <p class="text-muted m-b-30"></p> <div class="table-responsive"> <table class="table table-bordered mb-0"> <thead> <tr> <th># </th> <th>Category </th> <th>Sub Category </th> <th>Company Name </th> <th>Status </th> <th>Action </th> </tr></thead><tbody> <?php $i=1; $select=mysqli_query($conn,"SELECT * FROM posr_free_add order by posr_free_add_id DESC"); while($result=mysqli_fetch_array($select)) { ?> <tr> <th scope="row"><?php echo $i; ?></th> <td> <?php $category_id=$result['category_id']; $cat=mysqli_query($conn,"SELECT * FROM category where category_id='$category_id'"); $cat1=mysqli_fetch_array($cat); echo $category_name=$cat1['category_name']; ?> </td> <td><?php $subcategory_id=$result['subcategory_id']; $subcat=mysqli_query($conn,"SELECT * FROM subcategory where subcategory_id='$subcategory_id'"); $subcat1=mysqli_fetch_array($subcat); echo $subcategory_name=$subcat1['subcategory_name']; ?></td> <td><?php echo $result['company_name']; ?></td> <td> <?php $status=$result['status']; if($status !='0') { ?> <button class="btn btn-success" type="submit">Approved</button> <?php } else { ?> <button class="btn btn-danger" type="submit">Not Approved</button> <?php } ?> </td> <td> <a href="adpostdata_edit.php?id=<?php echo $result['posr_free_add_id'];?>"> <i class="far fa-edit"></i> </a> <a href="adpostdata_delete.php?status1=<?php echo $result['posr_free_add_id'];?>"onclick="return confirm('Are you sure you want to delete this College Listing ?');"> <i class="far fa-trash-alt"></i> </a> </td> </tr> <?php $i++; } ?> </tbody> </table> </div> </div> </div> </div> <!-- end col --> </div> <!-- end row --> </div> <!-- container-fluid --> </div> <!-- content --> <?php include_once('include/admin-footer.php'); ?> </div> <!-- ============================================================== --> <!-- End Right content here --> <!-- ============================================================== --> </div> <!-- END wrapper --> <!-- jQuery --> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/bootstrap.bundle.min.js"></script> <script src="assets/js/metisMenu.min.js"></script> <script src="assets/js/jquery.slimscroll.js"></script> <script src="assets/js/waves.min.js"></script> <!-- App js --> <script src="assets/js/app.js"></script> </body> </html>