Preview: blog.php
Size: 10.11 KB
/home/ostadcom/public_html/blog.php
<?php
session_start();
include "management/php/functions.php";
$menu = "blog";
?>
<!doctype html>
<html lang="fa">
<head>
<title>مقالات تخصصی دکوراسیون و مبلمان چوبی | گروه کارآفرینان استاد</title>
<meta name="description" content="مطالب آموزشی و مقالات تخصصی درباره دکوراسیون داخلی، انتخاب جاکفشی، میز تلویزیون، آینه کنسول و مبلمان چوبی را در گروه کارآفرینان استاد بخوانید.">
<?php include 'head.php'; ?>
</head>
<body style="direction: rtl;text-align: right">
<header class="header-area">
<?php include "menu.php"; ?>
</header>
<?php include "modals.php"; ?>
<div class="page-title-area">
<div class="container">
<div class="page-title-content">
<h1>مقالات</h1>
<ul>
<li>
<a href="index.php">صفحه اصلی
</a>
</li>
<li class="active">مقالات</li>
</ul>
</div>
</div>
</div>
<section id="blog" class="blog-area ptb-100">
<div class="container">
<div class="row">
<?php
$firstArticle = $connect -> prepare("select * from `tbl_article` where `delete_flag` = 0 and `show_first` = 1");
$firstArticle -> execute();
if($firstArticle -> rowCount() > 0){
while($firstArticleRows = $firstArticle -> fetch(PDO::FETCH_ASSOC)){
$updateDate0 = explode(" ",$firstArticleRows['update_date']);
$date0 = miladiToJalali2($updateDate0[0]);
?>
<div class="col-lg-4 col-md-6">
<div class="single-blog" style="padding: 5px; border-radius: 10px;">
<div class="blog-img">
<a href="blog-details.php?id=<?php echo $firstArticleRows['id']; ?>">
<img src="<?php echo $firstArticleRows['image']; ?>" alt="<?php echo $firstArticleRows['title']; ?>">
</a>
</div>
<div class="blog-content pt-2">
<ul>
<li>
<i class="bx bx-calendar"></i>
<a><?php echo $date0; ?></a>
</li>
</ul>
<a href="blog-details.php?id=<?php echo $firstArticleRows['id']; ?>">
<h3><?php echo $firstArticleRows['title']; ?></h3>
</a>
<a href="blog-details.php?id=<?php echo $firstArticleRows['id']; ?>" class="read-more">
ادامه مطلب
<i class="bx bx-left-arrow-alt"></i>
</a>
</div>
</div>
</div>
<?php
}
}
$per_page = 10;
if(isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
$start = $per_page * $page;
$start = $start - $per_page;
if(isset($_GET['search'])){
$search = input_test($_GET['search']);
$selectArticleSql = "select * from `tbl_article` where `delete_flag` = 0 and `show_first` = 0 and `title` like '%".$search."%' order by `id` desc limit ".$start.",".$per_page." ";
}elseif(isset($_GET['g'])){
$g = intval($_GET['g']);
$selectArticleSql = "select * from `tbl_article` where `delete_flag` = 0 and `show_first` = 0 and `group_id` = ".$g." order by `id` desc limit ".$start.",".$per_page." ";
}else{
$selectArticleSql = "select * from `tbl_article` where `delete_flag` = 0 and `show_first` = 0 order by `id` desc limit ".$start.",".$per_page." ";
}
$selectArticlePrepare = $connect -> prepare($selectArticleSql);
$selectArticlePrepare -> execute();
if($selectArticlePrepare -> rowCount() > 0){
while($selectArticleRows = $selectArticlePrepare -> fetch(PDO::FETCH_ASSOC)){
$updateDate = explode(" ",$selectArticleRows['update_date']);
$date = miladiToJalali2($updateDate[0]);
?>
<div class="col-lg-4 col-md-6">
<div class="single-blog" style="padding: 5px; border-radius: 10px;">
<div class="blog-img">
<a href="blog-details.php?id=<?php echo $selectArticleRows['id']; ?>">
<img src="<?php echo $selectArticleRows['image']; ?>" alt="<?php echo $selectArticleRows['title']; ?>">
</a>
</div>
<div class="blog-content pt-2">
<ul>
<li>
<i class="bx bx-calendar"></i>
<a><?php echo $date; ?></a>
</li>
</ul>
<a href="blog-details.php?id=<?php echo $selectArticleRows['id']; ?>">
<h3><?php echo $selectArticleRows['title']; ?></h3>
</a>
<a href="blog-details.php?id=<?php echo $selectArticleRows['id']; ?>" class="read-more">
ادامه مطلب
<i class="bx bx-left-arrow-alt"></i>
</a>
</div>
</div>
</div>
<?php
}
}else{
?>
<div class="text-center">
<p>مقاله ای یافت نشد!</p>
</div>
<?php
}
?>
<div class="col-12">
<div class="pagination-area text-center">
<?php
if(isset($_GET['search'])){
$search2 = $_GET['search'];
$sql1 = "SELECT * FROM `tbl_article` WHERE `delete_flag` = 0 and `title` like '%".$search2."%' ";
$query = $connect->query($sql1);
$number = $query->rowCount();
if($number > 9) {
$total_page = (ceil($number / $per_page));
if ($total_page > 1) {
for ($i = 1; $i <= $total_page; $i++) {
if ($i == $page) {
echo "<span class='page-numbers current' aria-current='page'>$i</span>";
} else {
echo "<a class='page-numbers' href=\"?search=" . $search2 . "&page=" . $i . "\">" . $i . "</a>";
}
}
}
}
}elseif(isset($_GET['g'])){
$g2 = intval($_GET['g']);
$sql1 = "SELECT * FROM `tbl_article` WHERE `delete_flag` = 0 and `group_id` =".$g2;
$query = $connect->query($sql1);
$number = $query->rowCount();
if($number > 9) {
$total_page = (ceil($number / $per_page));
if ($total_page > 9) {
for ($i = 1; $i <= $total_page; $i++) {
if ($i == $page) {
echo "<span class='page-numbers current' aria-current='page'>$i</span>";
} else {
echo "<a class='page-numbers' href=\"?g=" . $g2 . "&page=" . $i . "\">" . $i . "</a>";
}
}
}
}
}else{
$sql1 = "SELECT * FROM `tbl_article` WHERE `delete_flag` = 0";
$query = $connect->query($sql1);
$number = $query->rowCount();
if($number > 9) {
$total_page = (ceil($number / $per_page));
if ($total_page > 1) {
for ($i = 1; $i <= $total_page; $i++) {
if ($i == $page) {
echo "<span class='page-numbers current' aria-current='page'>$i</span>";
} else {
echo "<a class='page-numbers' href=\"?page=" . $i . "\">" . $i . "</a>";
}
}
}
}
}
?>
</div>
</div>
</div>
</div>
</section>
<?php include "footer.php"; ?>
<div class="go-top">
<i class="bx bx-chevrons-up"></i>
<i class="bx bx-chevrons-up"></i>
</div>
<script data-cfasync="false" src="/cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script>
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.bundle.min.js"></script>
<script src="assets/js/meanmenu.min.js"></script>
<script src="assets/js/owl.carousel.min.js"></script>
<script src="assets/js/wow.min.js"></script>
<script src="assets/js/form-validator.min.js"></script>
<script src="assets/js/contact-form-script.js"></script>
<script src="assets/js/ajaxchimp.min.js"></script>
<script src="assets/js/range-slider.min.js"></script>
<script src="assets/js/custom.js"></script>
</body>
</html>
Directory Contents
Dirs: 22 × Files: 54