PHP Dosya Yöneticisi

<?php
// +------------------------------------------------------------------------+
// | @author Ercan Agkaya (Themerig)
// | @author_url 1: https://www.themerig.com
// | @author_url 2: https://codecanyon.net/user/themerig
// | @author_email: support@themerig.com
// +------------------------------------------------------------------------+
// | Techno Cms - E-Commerce Script
// | Copyright (c) 2018 Techno CMS. All rights reserved.
// +------------------------------------------------------------------------+

include ('includes/head.php');
include ('includes/header.php');

$ara = $_GET['search'];

echo '
<main id="shop" class="style3">
<div class="container">
<div class="row">
<div class="col-md-12">
<div class="main-shop  urun-carousel">
<div class="wrap-imagebox">
<div class="flat-row-title style1">
';

$say = $db->prepare("SELECT id FROM itemsy WHERE title like '%".$ara ."%' ");
$say->execute();

echo '
<h3>Arama Sonuçları: "'.$ara.'"</h3>
<span>
Toplam '.$say->rowCount().' ürün listelendi
</span>
<div class="clearfix"></div>
</div>
<div class="sort-product style1" style="display:none;">
<ul class="icons">
<li>
<img src="images/icons/list-1.png" alt="">
</li>
<li>
<img src="images/icons/list-2.png" alt="">
</li>
</ul>

<div class="sort">
<div class="popularity">
<select name="popularity">
<option value="">Gelişmiş sıralama</option>
</select>
</div>
</div>
<div class="clearfix"></div>
</div>
<div class="row">
';

$sira = 0;

$item = $db->prepare("SELECT * FROM itemsy WHERE title like '%".$ara ."%' ");
$item->execute();

if ($item->rowCount()) {
    foreach ($item as $row) {

$new_price = number_format($row['new_price'], 2, ',', '.');
        $old_price = number_format($row['old_price'], 2, ',', '.');

if (strlen($row['title']) > 63) {
            $title = substr($row['title'], 0, 33) . '<a>...</a>';
        } else {
            $title = $row['title'];
        }

$kat = $db->prepare("SELECT * FROM category where id=?  ");
        $kat-> execute(array($row['category']));
        $kat= $kat->fetch(PDO::FETCH_OBJ);

$anakat = $db->prepare("SELECT * FROM category where id=?  ");
        $anakat-> execute(array($kat->parent));
        $anakat= $anakat->fetch(PDO::FETCH_ASSOC);

$gallery = $db -> query("SELECT * FROM gallery WHERE `item_id` = '{$row['id']}' ORDER BY rand()")->fetch();

$url= seo($anakat['category_name']) . '/'. seo($kat->category_name) . '/' . seo($row['title'] . "-e" . $row['id']);
        $category = $kat->category_name;

echo '
        <div class="col-md-4 col-sm-6">
        <div class="product-box">
        <div class="imagebox style8">
        <div class="box-image owl-carousel-1">
        ';

$gallery = $db->prepare("SELECT * FROM gallery where item_id=?  ORDER BY que");
        $gallery-> execute(array($row['id']));
        $gallery= $gallery->fetchAll(PDO::FETCH_ASSOC);

for ($i=0; $i <2 ; $i++) {  ?>

<a href="<?=$url?>" title="" id="gallery-<?=$gallery["id"]?>">

<img src="<?=$row["foto_url"]?>" alt="" id="gallery-<?=$gallery["id"]?>-img">

</a>
            <?php

}

echo '
        </div>
        <div class="box-content">
        <div class="cat-name">
        <a href="#" title="">' . $category . '</a>
        </div>
        <div class="product-name">
        <a href="' . $url . '" title="">' . $title . '<br />#' . $row['id'] . $row['code'] . '</a>
        </div>
        <div class="price">
        ';

if ($new_price != "") {
            echo '
            <span class="regular">
            ' . $old_price . ' TL
            </span><br>
            <span class="sale">
            ' . $new_price . ' TL
            </span>
            ';
        } else {
            echo '                         
            <span class="sale" style="margin-top:14px;display:block;">
            ' . $old_price . ' TL
            </span>
            ';
        }

echo '
        </div>
        </div>
        <div class="box-bottom">

</form>

<input type="text" hidden="" value="'.$row["id"].'" name="item_id"/>
        <div id="result_spin_a_sepet_'.$row['id'].'"></div> <img src="images/icons/add-cart.png" alt="" >Sepete Ekle

</a>

</div>

$sira++;

}

echo '

</div>
</div>
<br><br><br><br>
</div>
</div>
</div>
</div>
</main>

include ('includes/footer.php');

İptal

📁 PHP Dosya Yöneticisi

📝 ara.php

📝 ara.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)