1#@!#!123s

https 1#@!#!123s
: / home / u565127238 / domains / stjamesion.edu.pk / public_html / admin /
Filename : magazine.php
back
<?php
session_start();
include("config.php");
if(isset($_SESSION['admin']))
{
    include("header.php");

    if(isset($_GET['magazine_delete']))
    {
        $id = $_GET['magazine_delete'];
        $delete=mysqli_query($con,"delete from magazine where id='$id'");
        $_SESSION['message'] = "magazine delete Successfully";
    }
?>

    <!-------- breadcrumbs----->
    <header class="page-header">
        <h2>Magazine</h2>

        <div class="right-wrapper text-right">
            <ol class="breadcrumbs">
                <li>
                    <a href="index.php">
                        <i class="fas fa-home"></i>
                    </a>
                </li>
                <li><span>Magazine</span></li>
            </ol>

            <a class="sidebar-right-toggle" data-open=""><i class="fas fa-chevron-left"></i></a>
        </div>
    </header>
    <!------------end ----->
    <!-- start: page -->
    <div class="row">
        <div class="col">
            <section class="card">
                <header class="card-header">
                    <div class="card-actions">
                        <a href="#" class="card-action card-action-toggle" data-card-toggle></a>
                    </div>

                    <h2 class="card-title">Magazine</h2>
                </header>
                <div class="card-body">
                    <?php if(isset($_SESSION['error'])){ ?>
                        <div class="alert alert-danger">
                            <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                            <strong>Oh snap!</strong><?php echo @$_SESSION['error']; unset($_SESSION['error']); ?>
                        </div>
                    <?php } if(isset($_SESSION['message'])){?>
                        <div class="alert alert-success">
                            <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                            <strong>Congrats!</strong><?php echo @$_SESSION['message']; unset($_SESSION['message']); ?>
                        </div>
                    <?php }?>
                    <a href="magazine_add.php"><button class="btn btn-primary" style="width:170px;">Add magazine</button></a>
                    <table class="table table-bordered table-striped mb-0" id="datatable-tabletools">
                        <thead>
                        <tr>
                            <!-- <th>Name</th> -->
                            <th>Id</th>
                            
                            <th>Cover</th>
                            <th>Title</th>
                            <th>Pdf</th>
                            <th>About</th>
                            <th>Date</th>
                            <th>Action</th>
                        </tr>
                        </thead>
                        <tbody>
                        <?php
                        $result = mysqli_query($con,"Select * from magazine order by id DESC");
                        foreach($result as $data){ ?>
                            <tr>
                                                   
                                <td><?php echo $data['id']; ?></td> 
                                <td><a href="<?php echo $data['cover']; ?>" target="_blank"><img src="<?php echo $data['cover']; ?>" height="50px" width="60px" class="rounded-circle"></a></td> 
                                <td><?php echo $data['title']; ?></td> 
                                <td>
                                   <a href="<?php echo $data['pdf_file']; ?>" download>Download pdf</a>                                
                               </td>  
                                <td><?php echo $data['des']; ?></td> 
                                 <td><?php echo $data['date']; ?></td> 
                                <td>
                                    <div class="btn-group flex-wrap">
                                        <button type="button" class="mb-1 mt-1 mr-1 btn btn-default dropdown-toggle" data-toggle="dropdown" aria-expanded="false">Action <span class="caret"></span></button>
                                        <div class="dropdown-menu" role="menu" x-placement="bottom-start" style="position: absolute; will-change: transform; top: 0px; left: 0px; transform: translate3d(0px, 42px, 0px);">
                                            <a class="dropdown-item text-1" href="?magazine_delete=<?php echo $data['id']; ?>">Delete</a>
                                            <a class="dropdown-item text-1" href="magazine_add.php?edit_magazine=<?php echo $data['id']; ?>">Edit</a>
                                        </div>
                                    </div>

                                </td>
                            </tr>
                        <?php } ?>

                        </tbody>
                    </table>


                </div>
            </section>
        </div>
    </div>

    <!-- end: page -->
    <?php include("footer.php");}
else{
    header("location:index.php");
} ?>
<script>
    $(document).ready(function()
    {
        $(".buttons-print").hide();
        $(".buttons-pdf").hide();
    });
</script>