PHP Dosya Yöneticisi

<?php
$seo=1;

include ('includes/head.php');

include ('includes/header.php');

include ('includes/slider.php');

include ('includes/flat_banner.php');

$ayars = $db->query("SELECT * FROM general_settings WHERE id = 1 ", PDO::FETCH_ASSOC);
if ($ayars->rowCount()) {
  foreach ($ayars as $ayars) {
  }
}

if($ayars['page_title']){ ?>
    <head>
        <title><?=$ayars['page_title']?></title>
        <meta name="description" content="<?=$ayars['page_description']?>">
        <meta name="keywords" content="<?=$ayars['page_keywords']?>">

</head>
<?php }else{ ?>

<?php }

<li class="active">Yeni Ürünler</li>

<li>Öne Çıkanlar</li>

<li>Çok Satanlar</li>

</ul>

</div>

</div>

</div>

<?php
                $sira = 0;

$item = $db->prepare("SELECT * FROM itemsy WHERE category != ''  order by id desc LIMIT 4");
                $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']) > 33) {
                            $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;

<?php  if($new_price != "") { ?>
                                    <span class="item-sale">İNDİRİM</span>
                                <?php  } ?>

<?php

$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

}?>

</div>

<!--   <div class="cat-name">

</div> -->

<a href="<?=$url?>" title=""><?=$title?><br /></a>

</div>

<?php if($new_price != "") { ?>
                                            <span class="sale">
                                                <?=$new_price?> TL
                                            </span>

<?php   }else { ?>

<?php } ?> 
                                    </div>

</div>

<input type="hidden" value="<?=$row['id']?>" name="item_id">
                                            <input type="hidden" value="<?=$_COOKIE['COOKIE_KEY']?>" name="cookies_rand_id">
                                            <input type="hidden" value="<?=$new_price?>" name="new_price">
                                            <input type="hidden" value="<?=$row['old_price']?>" name="old_price">

</form>

<?php

if($row['sale_status']>0){?>

<a href="javascript:void(0);" onclick="to_cart_manual(<?=$row['id']?>);" title="">

<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>

<?php }else{?>
                                       <a href="javascript:void(0);" title="">

<input type="text" hidden=""  name="item_id"/>
                                        <div id="result_spin_a_sepet_<?=$row['id']?>"></div> Tükenmiş

</a>

<?php }?>
                            </div>

</div>

</div>

</div>

</div>

</div>
            <?php  $sira++;

}

</div>

<?php
    $sira = 0;
    $vitrinurun = $db->prepare("SELECT * FROM vitrin_urun where vitrin_id=?  order by sira  ");
    $vitrinurun-> execute(array(1));
    $vitrinurun= $vitrinurun->fetchAll(PDO::FETCH_ASSOC);

$item = $db->prepare("SELECT * FROM itemsy WHERE category != ''  order by id desc LIMIT 4");
    $item->execute();

if($item->rowCount()) {
        foreach($vitrinurun as $viu){

$row = $db->prepare("SELECT * FROM itemsy where id=?  ");
            $row-> execute(array($viu['urun_id']));
            $row= $row->fetch(PDO::FETCH_ASSOC);

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

if (strlen($row['title']) > 33) {
                $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;

<?php  if($new_price != "") { ?>
                        <span class="item-sale">İNDİRİM</span>
                    <?php  } ?>

<?php

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

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

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

</a>

<!--    <div class="cat-name">

</div> -->

<a href="<?=$url?>" title=""><?=$title?><br /></a>

</div>

<?php if($new_price != "") { ?>
                                        <span class="sale">
                                            <?=$new_price?> TL
                                        </span>

<?php   }else { ?>

<?php } ?> 
                                </div>

</div>

<input type="hidden" value="<?=$row['id']?>'" name="item_id">
                                        <input type="hidden" value="<?=$_COOKIE['COOKIE_KEY']?>" name="cookies_rand_id">
                                        <input type="hidden" value="<?=$new_price?>" name="new_price">
                                        <input type="hidden" value="<?=$old_price?>" name="old_price">

</form>

<?php

if($row['sale_status']>0){?>

<a href="javascript:void(0);" onclick="to_cart_manual(<?=$row['id']?>);" title="">

<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>

<?php }else{?>
                                   <a href="javascript:void(0);" title="">

<input type="text" hidden=""  name="item_id"/>
                                    <div id="result_spin_a_sepet_<?=$row['id']?>"></div> Tükenmiş

</a>

<?php }?>

</div>

</div>

</div>

</div>

</div>

</div>
        <?php  $sira++;

}

</div>

<?php
    $sira = 0;

$vitrinurun = $db->prepare("SELECT * FROM vitrin_urun where vitrin_id=?  order by sira  ");
    $vitrinurun-> execute(array(2));
    $vitrinurun= $vitrinurun->fetchAll(PDO::FETCH_ASSOC);