<?php require_once('header.php'); ?>

<section class="content-header">
    <div class="content-header-left">
        <h1>View Blog</h1>
    </div>

    <div class="content-header-right">
        <a href="blog-add.php" class="btn btn-primary btn-sm">Add New</a>
    </div>
</section>

<section class="content">

    <div class="row">

        <div class="col-md-12">

            <div class="box box-info">

                <div class="box-body table-responsive">

                    <table id="example1" class="table table-bordered table-hover table-striped">

                        <thead>

                            <tr>
                                <th width="30">#</th>
                                <th>Title</th>
                                <th>Category</th>
                                <th>Date</th>
                                <th>Status</th>
                                <th width="100">Action</th>
                            </tr>

                        </thead>

                        <tbody>

                            <?php

                            $i=0;

                            $statement=$pdo->prepare("
                                SELECT *
                                FROM blogs
                                ORDER BY id DESC
                            ");

                            $statement->execute();

                            $result=$statement->fetchAll(PDO::FETCH_ASSOC);

                            foreach($result as $row){

                                $i++;

                            ?>

                            <tr>

                                <td><?php echo $i; ?></td>

                                <td>
                                    <?php echo htmlspecialchars(
                                        $row['title'],
                                        ENT_QUOTES,
                                        'UTF-8'
                                    ); ?>
                                </td>

                                <td>
                                    <?php echo htmlspecialchars(
                                        $row['category'] ?? '',
                                        ENT_QUOTES,
                                        'UTF-8'
                                    ); ?>
                                </td>

                                <td>
                                    <?php
                                    if(!empty($row['date'])){
                                        echo date(
                                            'd-m-Y',
                                            strtotime($row['date'])
                                        );
                                    }
                                    ?>
                                </td>

                                <td>

                                    <?php if($row['status']==1): ?>

                                        <span class="label label-success">
                                            Active
                                        </span>

                                    <?php else: ?>

                                        <span class="label label-danger">
                                            Deactive
                                        </span>

                                    <?php endif; ?>

                                </td>

                                <td>

                                    <a
                                        href="blog-edit.php?id=<?php echo (int)$row['id']; ?>"
                                        class="btn btn-primary btn-xs">
                                        Edit
                                    </a>

                                    <a
                                        href="#"
                                        class="btn btn-danger btn-xs"
                                        data-href="blog-delete.php?id=<?php echo (int)$row['id']; ?>"
                                        data-toggle="modal"
                                        data-target="#confirm-delete">
                                        Delete
                                    </a>

                                </td>

                            </tr>

                            <?php } ?>

                        </tbody>

                    </table>

                </div>

            </div>

        </div>

    </div>

</section>


<div
    class="modal fade"
    id="confirm-delete"
    tabindex="-1"
    role="dialog"
    aria-labelledby="myModalLabel"
    aria-hidden="true">

    <div class="modal-dialog">

        <div class="modal-content">

            <div class="modal-header">

                <button
                    type="button"
                    class="close"
                    data-dismiss="modal"
                    aria-hidden="true">
                    &times;
                </button>

                <h4
                    class="modal-title"
                    id="myModalLabel">
                    Delete Confirmation
                </h4>

            </div>

            <div class="modal-body">

                <p>
                    Are you sure want to delete this blog?
                </p>

            </div>

            <div class="modal-footer">

                <button
                    type="button"
                    class="btn btn-default"
                    data-dismiss="modal">
                    Cancel
                </button>

                <a
                    class="btn btn-danger btn-ok">
                    Delete
                </a>

            </div>

        </div>

    </div>

</div>

<?php require_once('footer.php'); ?>