sorgular mysli ile değil pdo ile yazılmış
mesela fotoğraflar şöyle bir kod ile çekilmiş
div class="col-sm-12 col-md-2 title_h">
<div class="title"><?= $_SESSION['lang'] == 'tr' ? 'GALERİ' : false ?> <?= $_SESSION['lang'] == 'en' ? 'GALERY' : false ?> <?= $_SESSION['lang'] == 'ar' ? 'معرض الصور' : false ?></div>
<div class="text"><?= $_SESSION['lang'] == 'tr' ? 'Kuruçeşme ile ilgili fotoğraf galerimiz.' : false ?> <?= $_SESSION['lang'] == 'en' ? 'Our photo gallery on Kuruçeşme Kahvesi' : false ?> <?= $_SESSION['lang'] == 'ar' ? 'لدينا معرض للصور على Kuruçeşme.' : false ?></div>
</div>
<div class="col-sm-12 col-md-10">
<div class="content wow fadeInRight">
<?php
$gNum = 0;
foreach ($galleries as $gallery) {
$images = DB::query("SELECT * FROM db_galeri_resim WHERE kat_id=" . $gallery['id']);
if ($images->rowCount()) {
$gNum++;
echo '<div class="item' . ($gNum == 1 ? ' active' : '') . '">';
foreach ($images->fetchAll(PDO::FETCH_ASSOC) as $image) {
?>
<a href="uploads/images/<?= $image['resim'] ?>" class="fancybox" rel="gallery_<?= $gNum ?>" title="<?= $image['resim_alt'] ?>">
<div class="col-xs-6 col-sm-4 col-md-15">
<img src="uploads/images/<?= $image['resim'] ?>" alt="<?= $image['resim_alt'] ?>">
<span><?= $_SESSION['lang'] == 'tr' ? $image['resim_alt'] : $image['resim_' . $_SESSION['lang'] . '_alt'] ?></span>
</div>
</a>
<?php
}
echo '</div>';
}
}
?>
<div class="reset"></div>
<?php
if (count($galleries) > 0) {
?>
<div class="navigator">
<ul>
<?php
for ($i = 1; $i <= count($galleries); $i++) {
?>
<li<?= $i == 1 ? ' class="active"' : '' ?>> </li>
<?php
}
?>
</ul>
</div>
<?php
}
?>
</div>
</div>
</div>