PHP Dosya Yöneticisi

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

$duzenid = intval($_GET["id"]);
$oku = $db->table('dbo_sektorler_alt')->where('sektoralt_id','=',$duzenid)->getRow();
if(!$oku){
	yonver($site);
	exit();
}

$ust = $db->table('dbo_sektorler')->where('sektor_id','=',$oku->sektoralt_ust)->getRow();
?>

<title><?=$oku->sektoralt_adi?> Firmaları</title>
<meta name="keywords" content="firma rehber, şehir firmaları, firma rehberleri, faaliyet firmaları, profesyonel firmalar, acil hizmet firmaları, onaylanmış firmalar, doğrulanmış firmalar" />
<meta name="description" content="Aradığınız tüm firmalar burada, faaliyet gösteren tüm firmaları bir araya toplayarak sizin için derledik, doğru ve onaylanmış firmaları hemen inceleyin.">

<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-building-o" aria-hidden="true"></i> <?=$oku->sektoralt_adi?></div>
                    </div>
                </div>
			</div>
		</div>

<div class="bg-white border-bottom">
			<div class="container">
				<div class="page-header">
					<h4 class="page-title"><?=$oku->sektoralt_adi?></h4>
					<ol class="breadcrumb">
						<li class="breadcrumb-item"><a href="<?=$site?>">Ana Sayfa</a></li>
						<li class="breadcrumb-item active" aria-current="page"><?=$oku->sektoralt_adi?></li>
					</ol>
				</div>
			</div>
		</div>

<section class="sptb">
			<div class="container">
				<div class="row">
					<div class="col-xl-9 col-lg-8 col-md-12">
                    <div class="row" style="margin-bottom:15px;">
                    <div class="col-md-12"><?php advert('SEKTRA1', '874', '90'); ?></div>
                    </div>
						
						<div class="card mb-lg-0">
							<div class="card-body">
								<div class="item2-gl ">
									<div class="tab-content" style="padding-top:0px;">
										<div class="tab-pane active" id="tab-11">
											<?php
											$limit = 10;
											$sql_text = "SELECT * FROM dbo_firma AS firma
														 LEFT JOIN dbo_il as il ON il.il_id = firma.firma_il
														 LEFT JOIN dbo_ilce as ilce ON ilce.ilce_id = firma.firma_ilce
														 WHERE firma.firma_durum = '1' AND FIND_IN_SET(".$duzenid.", firma.firma_ana_kat_id) ORDER BY firma.FirmaID 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ı firma bulunamadı!');
											}else{
												foreach($sql as $liste){
											
											?>
											<div class="card overflow-hidden">
												<?php if($liste->firma_vitrin == 'E'){ ?>
                                                <div class="ribbon ribbon-top-left text-danger"><span class="bg-danger">Vitrin Firma</span></div>
                                                <?php } ?>
												<div class="d-md-flex">
													<div class="item-card9-img">
														<div class="item-card9-imgs">
															<a href="firma/<?=$liste->FirmaID?>/<?=seo($liste->firma_adi)?>/"></a>
															<img src="uploads/firmalogo/<?=$liste->firma_logo?>" alt="<?=$liste->firma_adi?>" class="cover-image" style="background:#FFFFFF;height:197px;width:auto;margin-left:auto;margin-right:auto;display:block;">
														</div>
													</div>
													<div class="card mb-0 border-0">
														<div class="card-body ">
															<div class="item-card9">
																<a href="firma/<?=$liste->FirmaID?>/<?=seo($liste->firma_adi)?>/" class="text-dark"><h4 class="font-weight-semibold mt-1"><?=$liste->firma_adi?></h4></a>
																<p class="mb-0 leading-tight"><?=kisalt($liste->firma_desc,100)?></p>
															</div>
														</div>
														<div class="card-footer pt-4 pb-4">
															<div class="item-card9-footer d-flex">
																<div class="item-card9-cost">
																	<h6 class="text-dark font-weight-semibold mb-0 mt-0"><i class="fa fa-map-marker"></i> <?=$liste->il_ad?>/<?=$liste->ilce_ad?></h6>
																</div>
																<div class="ml-auto">
																	<div class="rating-stars block">
																		<?=oysonuc($liste->FirmaID,'FIRMA')?>
																	</div>
																</div>
															</div>
														</div>
													</div>
												</div>
											</div>
											<?php }} ?>
										</div>
									</div>
								</div>
								<div class="center-block text-center">
									<ul class="pagination mb-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>
						
					</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>
                            <style>
							.custom-control-label::after {
								
							}
							</style>
							<div class="card-body">
								<div id="container">
									<div class="item-list">
										<ul class="list-group mb-0">
											<?php
											$firma = $db->table('dbo_sektorler_alt')
														->where('sektoralt_ust','=',$ust->sektor_id)
														->orderBy('sektoralt_adi','asc')
														->getAll();
											foreach($firma as $liste){
											?>
                                            <li class="list-group-item" style="padding: 0.75rem 0rem;">
												<a href="alt-sektor/<?=$liste->sektoralt_id?>/<?=seo($liste->sektoralt_adi)?>/" <?php if($duzenid == $liste->sektoralt_id){ echo ' style="font-weight:bold;"'; } ?>>
													<?=$liste->sektoralt_adi?>
													<span class="badgetext badge badge-pill badge-secondary mb-0"><?=KatAltSay($liste->sektoralt_id)?></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="firmalar/" />
                                    <div class="row">
                                        <div class="col-12" style="margin-bottom:15px;">
                                            <select id="il" name="il" class="form-control" 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-12" style="margin-bottom:15px;">
                                            <div class="input-wrap">
                                                <select id="ilce" name="ilce" class="form-control">
                                                <option value="">Önce Şehir Seçin.</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-12" style="margin-bottom:15px;">
                                            <div class="input-wrap">
                                                <select id="il" name="kat" class="form-control">
                                                <option value="">Kategori Seçin.</option>
                                                <?php
                                                $sektor = $db->table('dbo_sektorler')
                                                             ->where('sektor_tip','=','SEKTOR')
                                                             ->where('sektor_acil','!=','E')
                                                             ->orderBy('sektor_sira','asc')
                                                             ->getAll();
                                                    
                                                foreach($sektor as $listele){
                                                ?>
                                                <option value="<?=$listele->sektor_id?>"><?=$listele->sektor_adi?></option>
                                                <?php } ?>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-12" style="margin-bottom:15px;">
                                            <div class="input-wrap">
                                                <input type="text" name="Key" class="form-control" placeholder="Anahtar Kelime" />
                                            </div>
                                        </div>
                                        <div class="col-12">
                                            <button type="submit" class="btn btn-pink btn-block" style="width:100%;"><i class="fa fa-search"></i> Firma Bul</button>
                                        </div>
                                    </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>
                                </form>
							</div>
						</div>
                        <div class="row" style="margin-bottom:15px;">
                        <div class="col-md-12"><?php advert('SEKTRA2', '274', '274'); ?></div>
                        </div>
					</div>
					
				</div>
			</div>
		</section>

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

İptal

📁 PHP Dosya Yöneticisi

📝 firma-alt-kategori.php

📝 firma-alt-kategori.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)