1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / rinkumehandiartist / public_html / backup / admin /
Filename : blog_list.php
back
<?php 

  include 'header.php'; 


$query = $conn->prepare("SELECT * FROM blog order by id desc");
$query->execute();
$result = $query->fetchAll();
$row = count($result);

?>





<style>

  .kbox{

    padding: 0 15px!important;

  }

</style>



<div class="content-wrapper">

    <section class="content-header">

      <?php

        if(isset($_SESSION['amsg'])) {

            echo $_SESSION['amsg'];

           unset($_SESSION['amsg']);

        }

      ?>

      <h3 class="box-title">Blog List</h3>              



    </section>



    <section class="content">
      <div class="row">    
        <div class="col-md-12">
          <div class="box kbox box-info">
            <!-- <div class="box-header with-border">
              <a href="gallery_add.php" class="btn btn-info">Add Image for Gallery</a>
            </div> -->
            <table id="" class="table table-bordered table-striped">
                <thead>
                <tr> 
                  <th>SNo.</th>
                  <th>Feature Img</th>
                  <th>Title</th>
                  <th>URL</th>
                  <th>Created Date</th>
                  <th>Action</th>
                </tr>
                </thead>
                <tbody>
                <?php 
                  if(isset($row)) {
                    if($row>0){
                       $i = 1;
                      foreach ($result as $value) {
                           $img = $value['img'];
                           $title = $value['title'];
                           $url = $value['url'];
                           $description = $value['description'];
                           $created_at = $value['created_at'];
                          ?>
                            <tr>
                              <td><?= $i; ?></td>
                              <td><img src="upload/blog/<?php echo $value['img'];  ?>" width="70px" height="27px" />  </td>
                              <td> <?php if(isset($title)){ echo $title; }  ?> </td>
                              <td> <?php if(isset($url)){ echo $url; }  ?> </td>
                              <td> <?php if(isset($created_at)){ echo $created_at; }  ?> </td>
                              <td>
                                 <a href="blog_edit.php?nid=<?php echo $value['id']; ?>" class="btn fa fa-edit actionEdit"></a> 
                                <a onclick="return confirm('Are you sure you want to delete this item?');" href="backend/blog_delete.php?cid=<?php echo $value['id']; ?>" class="btn fa fa-trash actionDelete"></a>
                              </td>
                            </tr>
                          <?php
                     $i++; }   
                    }
                  }
                ?>               
                </tbody> 
              </table>
          </div>
        </div>
      </div>
    </section>
  </div>































<?php include 'footer.php'; ?>