
   <div class="tp-page-title-area pt-60 pb-60 position-relative fix" data-background="<?php echo $pageDataCheck['banner']; ?>">
            <div class="tp-custom-container">
                <div class="row">
                    <div class="col-12">
                        <div class="tp-page-title z-index">
                            <div class="breadcrumb-menu">
                                <nav class="breadcrumb-trail breadcrumbs">
                                    <ul class="trail-items">
                                        <li class="trail-item trail-begin"><a href="<?php echo $generalSettingCheck['site_url']; ?>"><?php echo $langArray['LINK_HOME']; ?></a>
                                        </li>
                                       
        <li class="trail-item trail-end"><?php echo $pageDataCheck['title']; ?></li>
                                    </ul>
                                </nav>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
 
           <div class="tp-prjects-area pt-120 pb-120">
            <div class="container">
                <div class="row">
                    <div class="col-12">
                        <div class="tp-prjects-tab-menu mb-60">
                            <ul class="nav justify-content-center" id="myTab" role="tablist">

                                       <?php

                $allCategoriesAsk->execute(array(

                  'categories_type' => "project_categories",

                  'language'        => $getLangCheck['language_id']

                ));

                while ($postCatCheck=$allCategoriesAsk->fetch(PDO::FETCH_ASSOC)){ ?>

                                <li class="nav-item" role="presentation">
                                  <button class="nav-link" type="button"><a href="<?php echo $generalSettingCheck['site_url'] . $postCatCheck['seo_url']; ?>"><?php echo $postCatCheck['title']; ?></a></button>
                               </li>  <?php } ?> 
                                
                              </ul>
                        </div>
                    </div>
                </div>
                <div class="row pb-50">
                    <div class="col-12">
                        <div class="tp-prjects-tab-content">
                            <div class="tab-content" id="myTabContent">
                                <div >
                                    <div class="row">
                                        <?php

          $totalData = $db->query("SELECT COUNT(*) FROM posts WHERE post_type='post_projects' AND status=1 AND language={$getLangCheck['language_id']}")->fetchColumn();

          $show = 9999;

          $totalPage = ceil($totalData / $show);

          $page = @$_GET["p"];

          if($page < 1) $page = 1;

          if($page > $totalPage){

            $page = (int)$totalPage;

          }

          $limit = ($page - 1) * $show;

          $data = $db->prepare("SELECT * FROM posts WHERE post_type='post_projects' AND status=1 AND language={$getLangCheck['language_id']} LIMIT :basla, :bitir");

          $data->bindValue(":basla",$limit,PDO::PARAM_INT);

          $data->bindValue(":bitir",$show,PDO::PARAM_INT);

          $data->execute();

          $sequence = $data->fetchAll(PDO::FETCH_OBJ);

          if ($sequence == null) {

           echo '

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

             <span class="alert alert-danger block">'.$langArray['NO_CONTENT'].'</span>

           </div>

           ';

          }

          foreach ($sequence as $item){

            $x = explode("/", $item->banner);

            $y = explode('.', $x[1]);

        ?>
                                        <div class="col-lg-4 col-md-6">
                                            <div class="tp-project z-index mb-30">
                                                <div class="tp-project-img">
                                                    <img src="<?php echo $item->banner;?>" class="img-fluid" alt="<?php echo $item->title;?>">
                                                </div>
                                                <div class="tp-project-text">
                                                    <div class="tp-project-text-content">
                                                        <h4 class="tp-project-title"><a href="<?php echo $item->seo_url;?>"><?php echo $item->title;?></a></h4>
                                                    </div>
                                                    <div class="tp-project-text-icon">
                                                        <a href="<?php echo $item->seo_url;?>"><i class="fal fa-plus"></i></a>
                                                    </div>
                                                </div>
                                            </div>
                                        </div> <?php } ?>
                                       
                                    </div>
                                </div>
                           
                              </div>
                        </div>
                    </div>
                </div>
             
            </div>
        </div>