D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
bambooinn.in
/
admin
/
Filename :
blog-list.php
back
Copy
<?php include'config.php'; $view_events = "select * from blogs"; $run_query = mysqli_query($conn, $view_events); ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8" /> <title>Admin, Blog List | <?php echo $company; ?></title> <?php include'style.php'; ?> </head> <body> <div id="layout-wrapper"> <?php include'header.php'; ?> <div class="main-content"> <div class="page-content"> <div class="container-fluid"> <div class="row"> <div class="col-12"> <div class="page-title-box d-sm-flex align-items-center justify-content-between"> <h4 class="mb-sm-0 font-size-18">Blog List</h4> <div class="page-title-right"> <ol class="breadcrumb m-0"> <li class="breadcrumb-item"><a href="javascript: void(0);">Admin</a></li> <li class="breadcrumb-item active">Blog List</li> </ol> </div> </div> </div> </div> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body"> <div class="table-responsive"> <table class='table table-editable table-nowrap align-middle table-edits' cellspacing="0"> <thead> <tr> <th>Blog ID</th> <th>Blog title</th> <th>Blog date</th> <th>Blog location</th> <th>Blog content</th> <th>Blog writer</th> <th>Blog Image</th> <th>Blog Status</th> <th>Action</th> </tr> </thead> <tbody> <?php $sn = 0; if($run_query-> num_rows > 0){ while($row = mysqli_fetch_assoc($run_query)) { $blog_id = $row['blog_id']; $blog_title = $row['blog_title']; $blog_date = $row['blog_date']; $blog_location = $row['blog_location']; $blog_content = $row['blog_content']; $blog_writer = $row['blog_writer']; $blog_img = $row['blog_img']; $blog_status = $row['blog_status']; $sn++; echo "<tr data-id='1'> <td data-field='banner_id' style='width: 80px'> ".$sn.".</td> <td data-field='banner_title' class='banner_title'>".$blog_title."</td> <td data-field='banner_title' class='banner_title'>".$blog_date."</td> <td data-field='banner_title' class='banner_title'>".$blog_location."</td> <td data-field='banner_title' class='banner_title'>".$blog_writer."</td> <td data-field='banner_content' class='banner_content'> <p>".$blog_content."</p> </td> <td data-field='banner_img' class='banner_img' cell-padding='0' cell-spacing='0'> <img src='blog-images/".$blog_img."'> </td> <td data-field='banner_title' class='banner_title'>".$blog_status."</td> <td style='width: 100px'> <a href='manage-blog.php?id=$blog_id&action=edit_blog' class='btn btn-outline-secondary btn-sm edit' title='Edit'> <i class='fas fa-pencil-alt'></i></a> <a href='manage-blog.php?id=$blog_id&action=delete_blog' class='btn btn-outline-secondary btn-sm edit' title='Delete'> <i class='fas fa-trash-alt'></i></a> </td> </tr>"; } } else{ echo "<span style='color:#fe0002;font-size:15px;'>Blog Item list is Empty.</span>"; } ?> </tbody> </table> </div> </div> </div> </div> <!-- end col --> </div> </div> </div> <?php include'right-sidebar.php'; ?> <?php include'script.php'; ?> </body> </html>