PHP Dosya Yöneticisi

<?php 
@$page = 'firmalar';
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 firma_il='".$il."'";
}
if ($ilce !="") {
	$detays .= "AND firma_ilce='".$ilce."'";
}
if ($kat !="") {
	$detays .= ' AND firma_ana_kat_id IN ('.$kat.')';
}
if ($Key !="") {
	$detays .= " AND (firma_adi LIKE '%$Key%') OR (firma_aciklama LIKE '%$Key%') OR (firma_meta LIKE '%$Key%')";
}
?>

<title>Firma Haritalar | <?=ayar('site_baslik')?></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 class="d-md-flex">
			<div class="map-width">
				<div class="axgmap" data-latlng="<?=ayar('harita_konum')?>" data-zoom="6">
					<?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' $detays 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 $harita){
					
					?>
					<div class="axgmap-img" data-latlng="<?=$harita->firma_lat?>,<?=$harita->firma_lng?>" data-marker-image="assets/images/marker.png" data-title="<?=$liste->firma_adi?>">
						<h4><?=$harita->firma_adi?></h4>
						<img src="uploads/firmalogo/<?=$harita->firma_logo?>" alt="img" class="w-150 h100 mb-3 mt-2">
						<p class="fs-16"><i class="fa fa-phone mr-2"></i> <?=$harita->firma_sabit?></p>
						<a href="firma/<?=$harita->FirmaID?>/<?=seo($harita->firma_adi)?>/" class="btn btn-sm btn-primary btn-pill">Firma Detay</a>
					</div>
					<?php }} ?>
				</div>
			</div>
			<div class="map-content-width vscroll card mb-0 br-0 mh-500">
				<div class="p-4">
					<?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' $detays 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 id="mobres" src="uploads/firmalogo/<?=$liste->firma_logo?>" alt="<?=$liste->firma_adi?>" class="cover-image">
                                </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="bg-white">
			<div class="banner-1 pt-5 pb-5">
				<div class="header-text1 mb-0">
					<div class="container">
						<div class="row">
							<div class="col-xl-12 col-lg-12 col-md-12 d-block mx-auto">
								<div class="search-background mb-0">
									<form method="get" action="firma-harita/" />
                                    <div class="form row no-gutters">
										<div class="form-group col-md-3">
											<select id="il" name="il" class="form-control" style="height:46px;">
                                                <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="form-group col-md-3">
											<select id="ilce" name="ilce" class="form-control" style="height:46px;">
                                                <option value="">Önce Şehir Seçin.</option>
											</select>
										</div>
                                        <div class="form-group col-md-3">
											<select class="form-control" style="height:46px;">
                                                <?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 class="col-xl-2 col-lg-3 col-md-12 mb-0">
                                            <button type="submit" class="btn btn-lg btn-block btn-pink" style="width:100%;"><i class="fa fa-search"></i> Firma Bul</button>
										</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>
                                    </form>
								</div>
							</div>
                            <div class="center-block text-center" style="text-align: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>
		</div>
		
        
<?php require_once('footer.php'); ?>
<script src="https://maps.googleapis.com/maps/api/js?key=<?=ayar('googlemap_key')?>&libraries=places"></script>

İptal

📁 PHP Dosya Yöneticisi

📝 firma-harita.php

📝 firma-harita.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)