<?php

include "php/header.php";
?>
<div class="contents">
    <div class="custom-container">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <ol class="breadcrumb">
                    <li><a href="<?= $siteUrlMain; ?>">Home</a></li>
                    <li class="active">Magazines</li>
                </ol>
            </div>
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 equalcol conentsection">
                <div class="sections">
                    <h2 class="heading">Magazines</h2>
                    <div class="clearfix"></div>
                    <div class="row">
                        <?php
                        if (isset($_GET["page"]))
                            $page = (int)$_GET["page"];
                        else
                            $page = 1;
                        $setLimit = 999;
                        $pageLimit = ($page * $setLimit) - $setLimit;

                        $sql = "select id,mpImg,cateName,issueDate,pdfFile 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) {
                            while ($rows = mysqli_fetch_array($query)) {
                                $sgnr = "";
                                echo '<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">
<div class="blogposttwo">
<figure>
<a href="' . magazineUrl($rows['id']) . '">
<img src="' . $siteUrlMain . 'img/' . (($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"><a href="' . magazineUrl($rows['id']) . '">' . stringTxtLimit($rows['cateName'], 33) . '</a></h4>
<a href="' . magazineUrl($rows['id']) . '" class="btn btn-primary btn-xs backcolor text-center">Read More</a>

<a  download href="' . $siteUrlMain . 'img/' . (($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 class="clearfix"></div>
</div>';
                            }
                            echo '</div>
</div>
<div class="clearfix"></div>
' . tablePaging($pgSql, $setLimit, $page) . '
<ul class="pagination" style="display:none">
<li><a href="blog-fullwidth.html#"><i class="fa fa-angle-left"></i></a></li>
<li><a href="blog-fullwidth.html#">1</a></li>
<li class="disabled"><a href="blog-fullwidth.html#">2</a></li>
<li><a href="blog-fullwidth.html#">3</a></li>
<li class="active"><a href="blog-fullwidth.html#">4</a></li>
<li><a href="blog-fullwidth.html#">5</a></li>
<li><a href="blog-fullwidth.html#"><i class="fa fa-angle-right"></i></a></li>
</ul>
<div class="clearfix"></div>';
                        } else {
                            echo '<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="blogposttwo">
<div class="text">
<div class="cateDesc">
No data found.
</div>
</div>
</div>
<div class="clearfix"></div>
</div>
</div>
</div>';
                        }
                        ?>
                        <div class="clearfix"></div>
                    </div>
                </div>
            </div>
        </div>
        <?php include "php/footer.php"; ?>