PHP Dosya Yöneticisi

<?php
@$page = 'firsatlar';
require_once('header.php');

/************** GET PARAMETRE ******************/
$il		= intval($_GET['il']);
$ilce	= intval($_GET['ilce']);
$kat	= intval($_GET['kat']);
$Key	= guvenlik($_GET['Key']);
/************** #GET PARAMETRE ******************/

if ($il !="") {
	$detays .= " AND firsat_il='".$il."'";
}
if ($ilce !="") {
	$detays .= " AND firsat_ilce='".$ilce."'";
}
if ($kat !="") {
	$detays .= " AND firsat_kategori='".$kat."'";
}
if ($Key !="") {
	$detays .= " AND (firsat_adi LIKE '%$Key%') OR (firsat_aciklama LIKE '%$Key%')";
}
?>

<title>Şehir Fırsatları | <?=ayar('site_baslik')?></title>
<meta name="keywords" content="<?=ayar('site_meta')?>" />
<meta name="description" content="<?=ayar('site_aciklama')?>">

<div>
			<div class="banner-1 cover-image bg-background" data-image-src="assets/images/banners/business.jpg" style="padding-bottom:15px; padding-top:15px;">
				<div class="container">
                    <div class="row">
                        <div id="ustbilgi" class="col-md-12" style="font-size:35px; color:#FFFFFF; z-index:10;"><i class="fa fa-tags" aria-hidden="true"></i> Fırsat & İndirimler</div>
                    </div>
                </div>
			</div>
		</div>

<div class="bg-white border-bottom">
			<div class="container">
				<div class="page-header">
					<h4 class="page-title">Fırsat & İndirimler</h4>
					<ol class="breadcrumb">
						<li class="breadcrumb-item"><a href="<?=$site?>">Ana Sayfa</a></li>
						<li class="breadcrumb-item active" aria-current="page">Fırsat & İndirimler</li>
					</ol>
				</div>
			</div>
		</div>

<section class="sptb">
			<div class="container">
				<div class="row">
					<div class="col-xl-9 col-lg-9 col-md-12">
						<div class="row" style="margin-bottom:15px;">
                        <div class="col-md-12"><?php advert('FIRSAT1', '874', '90'); ?></div>
                        </div>
						
                        	<?php
							$limit = 10;
							$sql_text = "SELECT * FROM dbo_firsat WHERE firsat_durum = 'Aktif' $detays ORDER BY FirsatID DESC";
							$sayfa_get = guvenlik($_GET['sayfa']);
							if(!empty($sayfa_get) and is_numeric($sayfa_get)){
							$sayfa=($sayfa_get-1)*$limit;
							}else{
							$sayfa=0;
							}
							$sql = $db->customQuery($sql_text." LIMIT $sayfa, ".$limit)->getAll();
							
							$sayfa = $db->customQuery($sql_text)->getAll();
							$topla = $db->numRows();
							$toplam_kayit=$topla;
							if ($db->numRows() == 0){
									echo bilgi('danger','<i class="fa fa-exclamation-triangle"></i> Üzgünüz! kayıtlı fırsat bulunamadı!');
							}else{
								foreach($sql as $liste){
									
							$belirliGun = strtotime($liste->firsat_tarih_bitis.'23:59:59');
							$suan=strtotime(date("j-n-Y H:i:s"));
							?>
                            <div class="card overflow-hidden">
                                <div class="row no-gutters">
                                    <div class="col-xl-4 col-lg-12 col-md-12">
                                    <?php if($liste->firsat_ozel == 'E'){ ?>
                                    <div class="arrow-ribbon bg-purple">ÖZEL FIRSAT</div>
                                    <?php } ?>
                                        <div class="item7-card-img" style="height:200px; background:url(uploads/firsatlar/<?=$liste->firsat_resim?>); background-repeat: no-repeat; background-position: center; background-size: cover;">
                                            <div class="item7-card-text">
                                                <span class="badge badge-success"><?=$liste->sektor_adi?></span>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-8 col-lg-12 col-md-12">
                                        <div class="card-body">
                                            <div class="item7-card-desc d-flex mb-1">
                                                <a href="firsat/<?=$liste->FirsatID?>/<?=seo($liste->firsat_adi)?>/"><i class="fa fa-calendar-o text-muted mr-2"></i><?=sureHesapla($belirliGun,$suan,5)?></a>

<div class="ml-auto">
                                                    <a href="firsat/<?=$liste->FirsatID?>/<?=seo($liste->firsat_adi)?>/"><i class="fa fa-user text-muted mr-2"></i> <?=$liste->firsat_goruntulenme?> inceleme</a>
                                                </div>
                                            </div>
                                            <a href="firsat/<?=$liste->FirsatID?>/<?=seo($liste->firsat_adi)?>/" class="text-dark"><h4 class="font-weight-semibold"><?=$liste->firsat_adi?></h4></a>
                                            <p class="mb-1"><?=kisalt($liste->firsat_desc,165)?></p>
                                            <a href="firsat/<?=$liste->FirsatID?>/<?=seo($liste->firsat_adi)?>/" class="btn btn-primary btn-sm mt-4" style="float:right;">Detaylar</a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        <?php }} ?>
						
						<div class="center-block text-center">
							<ul class="pagination mb-lg-0">
								<?php
								require_once('system/class.paginate.php');
								$sayfalama= new paginate();
								$sayfalama->sayfa=intval($_GET['sayfa']);
								$sayfalama->toplam=$toplam_kayit;
								$sayfalama->sayfa_basina=$limit;
								$sayfalama->type=0;
								$sayfalama->degisken='sayfa';
								$sayfalama->hazirla();
								echo $sayfalama->sayfala();
								unset($sayfalama); 
								?>
							</ul>
						</div>
						
					</div>

<div class="col-xl-3 col-lg-4 col-md-12">
						<div class="card">
							<div class="card-header">
								<h3 class="card-title"><i class="fa fa-list" aria-hidden="true"></i> Kategoriler</h3>
							</div>
							<div class="card-body">
								<div id="container">
									<div class="item-list">
										<ul class="list-group mb-0">
											<?php
											$sektor = $db->table('dbo_sektorler')
														 ->where('sektor_tip','=','FIRSAT')
														 ->orderBy('sektor_sira','asc')
														 ->getAll();
												
											foreach($sektor as $listele){
											?>
                                            <li class="list-group-item" style="padding: 0.75rem 0rem;">
												<a href="c/<?=$listele->sektor_id?>/<?=seo($listele->sektor_adi)?>/" <?php if($duzenid == $listele->sektor_id){ echo ' style="color:#000000; font-weight:bold;"'; } ?>>
													<?=$listele->sektor_adi?>
													<span class="badgetext badge badge-pill badge-secondary mb-0"><?=FirKatSay($listele->sektor_id,'Aktif')?></span>
												</a>
											</li>
											<?php } ?>
										</ul>
									</div>
								</div>
							</div>
							<div class="card-header border-top">
								<h3 class="card-title"><i class="fa fa-search"></i> Arama Daraltma</h3>
							</div>
							<div class="card-body">
								<form method="get" action="firsatlar/" />
                                <div class="row">
                                <div class="col-md-12">
                                    <select id="il" name="il" class="form-control" style="border-radius:0px; height:40px;" required>
                                    <option value="">Şehir Seçin.</option>
                                    <?php
                                    $sehir = $db->table('dbo_il')->select('*')->orderBy('il_id')->getAll();
                                    foreach($sehir as $sehirget){
                                    ?>
                                    <option value="<?=$sehirget->il_id?>"><?=$sehirget->il_ad?></option>
                                    <?php } ?>
                                    </select>
                                </div>
                                <div class="col-md-12">
                                    <select id="ilce" name="ilce" class="form-control" style="border-radius:0px; height:40px;" required>
                                    <option value="">Önce Şehir Seçin.</option>
                                    </select>
                                </div>
                                <div class="col-md-12">
                                    <select name="kat" class="form-control" style="border-radius:0px; height:40px;" required>
                                    <option value="">Kategori Seçin.</option>
                                    <?php
                                    $sektor = $db->table('dbo_sektorler')
                                                 ->where('sektor_tip','=','FIRSAT')
                                                 ->orderBy('sektor_sira','asc')
                                                 ->getAll();
                                        
                                    foreach($sektor as $listele){
                                    ?>
                                    <option value="<?=$listele->sektor_id?>"><?=$listele->sektor_adi?></option>
                                    <?php } ?>
                                    </select>
                                </div>
                                <div class="col-md-12">
                                    <input type="text" name="Key" placeholder="Anahtar Kelime" style="border-radius:0px; height:40px;" class="form-control" />
                                </div>
                                <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js" type="text/javascript"></script>
                                <script src="js/selectchained.js"></script>
                                <script>
                                $("#ilce").remoteChained("#il", "ajax/il-ilce.html");
                                </script>
                                <div class="col-md-12">
                                    <button type="submit" class="btn btn-pink btn-block" style="width:100%;">Fırsat Bul</button>
                                </div>
                            </div>
                            </form>
							</div>
						</div>
                        <div class="row" style="margin-bottom:15px;">
                        <div class="col-md-12"><?php advert('FIRSAT2', '274', '274'); ?></div>
                        </div>
					</div>
					
				</div>
			</div>
		</section>

<?php require_once('footer.php'); ?>

İptal

📁 PHP Dosya Yöneticisi

📝 firsatlar.php

📝 firsatlar.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)