|
Server : Apache/2 System : Linux srv244.medyabim.com 4.18.0-553.89.1.el8_10.x86_64 #1 SMP Mon Dec 8 03:53:08 EST 2025 x86_64 User : lionbursa ( 1773) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory : /home/lionbursa/domains/lionuluslararasidanismanlik.com/private_html/sistem/ |
Upload File : |
<?php
unset($_SESSION['album']);
$sayfa = guvenlik($_GET['sayfa']);
$id = guvenlik($_GET['id']);
$kat = $db->prepare("SELECT * FROM album WHERE Id = ?");
$kat->execute(array(
$id
));
$bv = $kat->fetch(PDO::FETCH_ASSOC);
$kategoriadi = $bv["albumadi$dil2"];
?> <div class="main-content">
<section class="inner-header divider parallax layer-overlay overlay-dark-5" data-bg-img="style/images/ust-bg.jpg">
<div class="container pt-60 pb-60">
<!-- Section Content -->
<div class="section-content">
<div class="row">
<div class="col-sm-8 text-left flip xs-text-center">
<h2 class="title text-white"><span class="text-theme-white"><?php echo $kategoriadi; ?></span></h2>
</div>
<div class="col-sm-4">
<ol class="breadcrumb text-right sm-text-center mt-10">
<li class="white"><a href="index.php"> <?php echo $hdil["hanasayfa"]; ?></a></li>
<li class="active text-theme-colored"><a href="galeri-1.html"><?php echo $hdil["hresim"]; ?></a></li>
</ol>
</div>
</div>
</div>
</div>
</section>
<!-- Gallery Grid 3 -->
<section>
<div class="container">
<div class="section-content">
<div class="row">
<div class="col-md-12">
<!-- Portfolio Gallery Grid -->
<div id="grid" class="gallery-isotope default-animation-effect grid-4 gutter clearfix">
<!-- Portfolio Item Start -->
<?php
$ss = $kategoriadi;
if (empty($sayfa)) {
$sayfa = 1;
}
$limit = 16;
$sayfalik_kayit = $limit;
$baslangic1 = $sayfa * $sayfalik_kayit;
$baslangic = $baslangic1 - $sayfalik_kayit;
$genel_sorgu = $db->prepare("SELECT * FROM galeri WHERE album = ? ORDER BY Id ASC");
$genel_sorgu->execute(array(
$id
));
$genel_sorgu->fetch(PDO::FETCH_ASSOC);
$toplam_kayit = $genel_sorgu->rowCount();
$toplam_sayfa = ceil($toplam_kayit / $sayfalik_kayit);
$carp = $sayfa * $sayfalik_kayit;
$sql = $db->query("SELECT * FROM galeri WHERE album = '$id' ORDER BY Id ASC LIMIT $baslangic, $sayfalik_kayit", PDO::FETCH_ASSOC);
$ii = 4;
foreach ($sql as $a) {
if (empty($a["resimadi"])) {
$resim = "yok.gif";
} else {
$resim = $a["resimadi"];
}
$sql2 = $db->prepare("SELECT * FROM album WHERE Id = ?");
$sql2->execute(array(
$a["album"]
));
$b = $sql2->fetch(PDO::FETCH_ASSOC);
$album = $b["albumadi$dil2"];
$kategori = $b["Id"];
$seolu = "fotogaleri-".seo($a["albumadi$dil2"])."-".$a["Id"]."-sayfa-1.html";
echo '<div class="gallery-item '.$kategori.'">
<div class="thumb">
<img class="img-fullwidth" src="upload/galeri/' . $a["resimadi"] . '" height="200" style="max-height:200px; max-width:375px" alt="'.$album.'">
<div class="overlay-shade"></div>
<div class="icons-holder">
<div class="icons-holder-inner">
<div class="styled-icons icon-sm icon-dark icon-circled icon-theme-colored">
<a data-lightbox="image" href="upload/galeri/' . $a["resimadi"] . '"><i class="fa fa-search"></i></a>
</div>
</div>
</div>
</div>
</div>
<!-- Portfolio Item End -->
';
$s ++;
}
if ($sql->rowCount() < 1) {
echo ' </div>
<center><strong style="font-size:16px">Albüme Ait Resim Bulunmamaktadır.</strong></center>
';
} else {
echo ' </div>
<div class="col-md-12">
<nav>
<ul class="pagination theme-colored">';
$seolu = "fotogaleri-" . seo($kategoriadi) . "-" . $id . "-sayfa-1.html";
echo ' <li> <a aria-label="Previous" href="' . $seolu . '"><span aria-hidden="true"><i class="fa fa-angle-double-left"></i></span></a></li>';
if ($sayfa > 1) {
$sy = $sayfa - 1;
$seolu = "fotogaleri-" . seo($kategoriadi) . "-" . $id . "-sayfa-" . $sy . ".html";
echo ' <li class=""><a aria-label="Previous" href="' . $seolu . '"><span aria-hidden="true"><i class="fa fa-angle-left"></i></span></a></li>';
} else {
echo ' <li><a aria-label="Previous" href="javascript:onClick=alert(\'İlk Sayfadasınız!\')"><span aria-hidden="true"><i class="fa fa-angle-left"></i></span></a></li>';
}
echo ' ';
for ($i = 0; $i < $toplam_sayfa; $i++) {
$sayfa_no = $i + 1;
if ($sayfa == $sayfa_no) {
echo ' <li class="active"><a href="#"> <span>' . $sayfa_no . ' </span></a></li> ';
} else {
$seolu = "fotogaleri-" . seo($kategoriadi) . "-" . $id . "-sayfa-" . $sayfa_no . ".html";
echo '<li class=""><a href="' . $seolu . '">' . $sayfa_no . '</a></li>';
}
}
for ($d = 0; $d < $toplam_sayfa; $d++) {
$sf2 = $d + 1;
}
if ($sayfa < $sf2) {
$ysf = $sayfa + 1;
$seolu = "fotogaleri-" . seo($kategoriadi) . "-" . $id . "-sayfa-" . $ysf . ".html";
echo ' <li><a aria-label="Next" href="' . $seolu . '"><span aria-hidden="true"><i class="fa fa-angle-right"></i> </span></a></li>';
} else {
echo ' <li> <a aria-label="Next" href="javascript:onClick=alert(\'Son Sayfadasınız!\')"><span aria-hidden="true"><i class="fa fa-angle-right"></i></span></a></li> ';
}
$seolu = "fotogaleri-" . seo($kategoriadi) . "-" . $id . "-sayfa-" . $sf2 . ".html";
echo ' <li><a aria-label="Next" href="' . $seolu . '"><span aria-hidden="true"><i class="fa fa-angle-double-right"></i></span></a></li>';
echo '</ul></nav></div>';
}
?>
<!-- End Portfolio Gallery Grid -->
</div>
</div>
</div>
</div>
</section>
</div>
<!-- end main-content -->