<?php include "php/header.php"; ?>

<div class="contents">
    <div class="custom-container">
        <div class="row">
            <div class="col-lg-12">
                <ol class="breadcrumb">
                    <li><a href="<?= $siteUrlMain; ?>">Home</a></li>
                    <li class="active">Magazines</li>
                </ol>
            </div>

            <div class="col-lg-12 conentsection">
                <div class="sections">
                    <h2 class="heading">Magazines</h2>
                    <div class="row d-flex flex-wrap">
                        <?php
                        $page = isset($_GET["page"]) ? (int)$_GET["page"] : 1;
                        $setLimit = 999;
                        $pageLimit = ($page * $setLimit) - $setLimit;

                        $sql = "SELECT id, mpImg, cateName, issueDate, pdfFile, bookViewURL FROM product_mapping_cate ORDER BY issueDate DESC LIMIT $pageLimit, $setLimit";
                        $pgSql = "SELECT id FROM product_mapping_cate ORDER BY issueDate DESC";

                        $query = mysqli_query($conn, $sql);
                        $numRow = mysqli_num_rows($query);

                        if ($numRow > 0) {
                            $counter = 0;
                            while ($rows = mysqli_fetch_array($query)) {
                                echo '<div class="col-lg-3 col-md-4 col-sm-6 col-xs-12 mb-4">'
                                    . '<div class="blogposttwo">'
                                    . '<figure>'
                                    . '<a target="_blank" href="' . $rows["bookViewURL"] . '">'
                                    . '<img src="' . $siteUrlMain . 'img/' . (!empty($rows['mpImg']) ? $rows['mpImg'] : 'noImg.jpg') . '" class="img-responsive hovereffect" alt="' . stringTxtLimit($rows['cateName'], 33) . '" />'
                                    . '</a>'
                                    . '</figure>'
                                    . '<div class="text text-center">'
                                    . '<h4 class="text-center" style="margin:0px;"><a target="_blank" href="' . $rows["bookViewURL"] . '">' . stringTxtLimit($rows['cateName'], 33) . '</a></h4>'
                                    . '<a target="_blank" href="' . $rows["bookViewURL"] . '" class="btn btn-primary btn-xs backcolor text-center">Read More</a>'
                                    . '<a download href="' . $siteUrlMain . 'img/' . (!empty($rows['pdfFile']) ? $rows['pdfFile'] : 'noImg.jpg') . '" class="btn btn-success btn-xs text-center">Download <i class="fa fa-download"></i></a>'
                                    . '</div>'
                                    . '</div>'
                                    . '</div>';

                                $counter++;
                                // Add clearfix after every 4 items
                                if ($counter % 4 == 0) {
                                    echo '<div class="clearfix"></div>';
                                }
                            }

                            echo '<div class="clearfix"></div>'
                                . tablePaging($pgSql, $setLimit, $page);
                        } else {
                            echo '<div class="col-12 text-center">'
                                . '<div class="blogposttwo">'
                                . '<div class="text">'
                                . '<div class="cateDesc">No data found.</div>'
                                . '</div>'
                                . '</div>'
                                . '</div>';
                        }
                        ?>
                        <div class="clearfix"></div>
                    </div>
                </div>
            </div>
        </div>
        </div>
        </div>

        <?php include "php/footer.php"; ?>