TurkShell v1.0

Owner : www-data

PHP Version

5.6.40-0+deb8u12

Disk Space

41.06 GB

Server Addr

19-www4

Your IP

10.10.10.40

Edit File

File:

<?php
require_once("admin/conexao/conecta.php");
require("admin/functions/limita-texto.php");
?>
<!DOCTYPE html>
<html lang="pt-br">
<link rel="icon" href="img/icone.ico"" type="image/x-icon" />
    <?php
      $sql = "SELECT * from tb_site ";
        try {
            $resultado = $conexao->prepare($sql);
            $resultado->execute();
            $contar = $resultado->rowCount();
                  
        if ($contar > 0) {
                while ($exibe = $resultado->fetch(PDO::FETCH_OBJ)) {                              
    ?>  
    <link rel="shortcut icon" href="img/<?php echo $exibe->logo; ?>" type="image/x-icon" />     
    <?php
                }//while
            } 
        } catch (PDOException $erro) {
            echo $erro;
        }
    ?>
  <header>

<?php 
    //TITULO NO BROWSER ID
    if(isset($_GET['post'])){
      $id = $_GET['post'];
      $sql = "SELECT * from tb_galeria where id = $id ";
        try {
          $resultado = $conexao->prepare($sql);
          $resultado->execute();
          $contar = $resultado->rowCount();
                      
          if ($contar > 0) {
            while ($mostra = $resultado->fetch(PDO::FETCH_OBJ)) {
              $titulo = $mostra->titulo;
              echo "<title>Blog GeoClimaMT - " . $titulo . "</title>";
            }//while
          } 
        } catch (PDOException $erro) {
          echo $erro;
        }
    }else 
    //TITULO NO BROWSER CATEGORIA
    if(isset($_GET['categoria'])){
      $cat = $_GET['categoria'];
      $sql = "SELECT * from tb_galeria where categoria = '".$cat."' ";
      echo "<title>Blog GeoClimaMT - " . $cat . "</title>";

}else{ ?>
      <title>Blog GeoClimaMT</title>
    <?php } ?>

<?php include("includes/head.php");?>

</header>

<?php include("includes/menus_pages.php");?>

<div class="container">

<div class="row">

<?php
                //FILTRAR PELO ID DO POST
                  if(isset($_GET['post'])){
                    $id = $_GET['post'];
                    $sql = "SELECT * from tb_galeria where id = $id ";
                        try {
                            $resultado = $conexao->prepare($sql);
                            $resultado->execute();
                            $contar = $resultado->rowCount();
                      
                            if ($contar > 0) {
                                while ($mostra = $resultado->fetch(PDO::FETCH_OBJ)) {
                                $titulo = $mostra->titulo;                                    
                        ?>

<div class="row">
        <div class="gallery col-lg-12" align="center">            
            <h4 class="gallery-title"><?php echo $mostra->titulo; ?></h4>
            <img width="400" height="300" src="upload/postagens/<?php echo $mostra->capa; ?>" />
            <p align="center"><?php echo $mostra->descricao; ?></p>
            <?php if($mostra->data != NULL){ ?>
            <p align="center">Publicado em: <?php echo $mostra->data; ?></p>
            <?php } ?>
        </div>

<?php
                                }//while
                            } else {
                                echo '<li>Não existe post cadastrados no sistema</li>';
                            }
                            } catch (PDOException $erro) {
                                 echo $erro;
                         }

<?php
        $itemmodal=0;
        $sql = "SELECT * from tb_galeria_item i left join tb_galeria g on (i.idgaleria=g.id) where i.exibir = 'Sim' and g.id=$id order by i.ordem";
                        try {
                            $resultado = $conexao->prepare($sql);
                            $resultado->execute();
                            $contar = $resultado->rowCount();
                      
                            if ($contar > 0) {
                                while ($exibeitem = $resultado->fetch(PDO::FETCH_OBJ)) {
                                $itemmodal += 1;                                    
                        ?>

<div class="col-md-4 col-sm-6 portfolio-item">
            <a class="portfolio-link" data-toggle="modal" href="#modal<?php echo $itemmodal?>">
              <div class="portfolio-hover">
              </div>
              <div align="center">
                <img class="img-fluid" title="Clique para acessar" src="upload/postagens/<?php echo $exibeitem->foto; ?>" style="width:250px;height:150px">
              </div>
            </a>
          </div>

<div class="portfolio-modal modal fade" id="modal<?php echo $itemmodal?>" tabindex="-1" role="dialog" aria-hidden="true">
      <div class="modal-dialog">
        <div class="modal-content">
          <div class="close-modal" data-dismiss="modal">
            <div class="lr">
              <div class="rl"></div>
            </div>
          </div>
          <div class="container">
            <div class="row">
              <div class="col-lg-8 mx-auto">
                <div class="modal-body">
                  
                  
                  <img class="img-fluid d-block mx-auto" src="upload/postagens/<?php echo $exibeitem->foto; ?>" alt="" width="500">
                  <p><?php echo $exibeitem->descricaoimg?></p>
                  <button class="btn btn-primary" data-dismiss="modal" type="button">
                    <i class="fa fa-times"></i>
                    Fechar</button>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>

<?php
                                }//while
                            } 
                            } catch (PDOException $erro) {
                                 echo $erro;
                         }

?>
    
            
        </div>

<?php //FILTRAR TUDO
                  } else {
                         $sql = "SELECT * from tb_galeria WHERE exibir = 'Sim' order by id desc";

//FILTRAR PELA CATEGORIA
                         if(isset($_GET['categoria'])){
                            $cat = $_GET['categoria'];
                            $sql = "SELECT * from tb_galeria WHERE exibir = 'Sim' and categoria = '".$cat."' order by id desc";
                         }

try {
                            $resultado = $conexao->prepare($sql);
                            $resultado->execute();
                            $contar = $resultado->rowCount();
                      
                            if ($contar > 0) {
                                while ($exibe = $resultado->fetch(PDO::FETCH_OBJ)) {                                    
                ?>
                    
                <div class="firma-card row">
                    <div class="col-md-5 img-padding-no">

<div>
                            <a href="blog.php?post=<?php echo $exibe->id;?>">
                            <img width="210" height="150" src="upload/postagens/<?php echo $exibe->capa; ?>" /></a>
                        </div>
                    </div>
                    <div class="col-md-7">
                        <a href="blog.php?categoria=<?php echo $exibe->categoria;?>" rel="category tag"><?php echo $exibe->categoria;?></a>
                        <div class="firma-aciklama card-body">
                            <a href="blog.php?post=<?php echo $exibe->id;?>">
                                <h5><?php echo $exibe->titulo;?></h5>
                            </a>
                           
                        </div>
                    </div>
                </div>
                <?php
                                }//while
                            } else {
                                echo '<li>Não existe postagens disponíveis</li>';
                            }
                            } catch (PDOException $erro) {
                                 echo $erro;
                         }
                  }//if(isset($_GET['post']))
                         ?>

</div>
            <div class="col-md-2"></div>
        </div>
    </div>
    </div>

</div>
      
         
        </div>
        
        <?php include("includes/menus_blog.php");?>
      </div>

</div>

<footer>
      <?php include("includes/footer.php");?>     
    </footer>

<script src="vendor/jquery/jquery.min.js"></script>
    <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

<script src="vendor/jquery-easing/jquery.easing.min.js"></script>

<script src="js/jqBootstrapValidation.js"></script>
    <script src="js/contact_me.js"></script>

<script src="js/agency.min.js"></script>

</body>

</html>