PHP Dosya Yöneticisi

<?php
include 'excel/PHPExcel.php';
include 'excel/PHPExcel/Writer/Excel2007.php';

if (!empty($_POST))
{

if($_POST['aktar']=='1'){

$objPHPExcel = new PHPExcel();	
	$objPHPExcel->getProperties()->setCreator("Ürünler");
    $objPHPExcel->getProperties()->setTitle("Ürünler");
	
	// Add data
    $objPHPExcel->setActiveSheetIndex(0);
	$objPHPExcel->getActiveSheet()->setCellValue("A1", "Ürün ID");
    $objPHPExcel->getActiveSheet()->setCellValue("B1", "Ürün Adı");
	$objPHPExcel->getActiveSheet()->setCellValue("C1", "Ürün Kodu");
	$objPHPExcel->getActiveSheet()->setCellValue("D1", "Seo Linki");
	$objPHPExcel->getActiveSheet()->setCellValue("E1", "Stok Sayısı");
	$objPHPExcel->getActiveSheet()->setCellValue("F1", "Ürün Fiyatı");
	$objPHPExcel->getActiveSheet()->setCellValue("G1", "İndirimli Fiyatı");
	$objPHPExcel->getActiveSheet()->setCellValue("H1", "Ürün Açıklaması");
	$objPHPExcel->getActiveSheet()->setCellValue("I1", "Ana Kategorisi");
	$objPHPExcel->getActiveSheet()->setCellValue("J1", "Alt Kategorisi");
	$objPHPExcel->getActiveSheet()->setCellValue("K1", "EnAlt Kategorisi");
	$objPHPExcel->getActiveSheet()->setCellValue("L1", "Özellik Adı");
	$objPHPExcel->getActiveSheet()->setCellValue("M1", "Ürün Durumu");
	$objPHPExcel->getActiveSheet()->setCellValue("N1", "Ürün Resmi");

$tur = 2;
	
    $uk = $DB->query("select * from urunler order by urunid desc")->fetchAll(PDO::FETCH_ASSOC); 
    foreach($uk as $urunlerim){
	$objPHPExcel->getActiveSheet()->setCellValue("A".$tur."", "".$urunlerim['urunid']."");	
    $objPHPExcel->getActiveSheet()->setCellValue("B".$tur."", "".$urunlerim['urunAdi']."");
	$objPHPExcel->getActiveSheet()->setCellValue("C".$tur."", "".$urunlerim['urunkodu']."");
	$objPHPExcel->getActiveSheet()->setCellValue("D".$tur."", "".$urunlerim['seo']."");
	$objPHPExcel->getActiveSheet()->setCellValue("E".$tur."", "".$urunlerim['stok']."");
	$objPHPExcel->getActiveSheet()->setCellValue("F".$tur."", "".$urunlerim['urunFiyati']."");
	$objPHPExcel->getActiveSheet()->setCellValue("G".$tur."", "".$urunlerim['ifiyat']."");
	$objPHPExcel->getActiveSheet()->setCellValue("H".$tur."", "".strip_tags($urunlerim['metin'])."");
	$objPHPExcel->getActiveSheet()->setCellValue("I".$tur."", "".$urunlerim['kategori']."");
	$objPHPExcel->getActiveSheet()->setCellValue("J".$tur."", "".$urunlerim['altkategori']."");
	$objPHPExcel->getActiveSheet()->setCellValue("K".$tur."", "".$urunlerim['baltkategori']."");
	$objPHPExcel->getActiveSheet()->setCellValue("L".$tur."", "".$urunlerim['ekad']."");
    $objPHPExcel->getActiveSheet()->setCellValue("M".$tur."", "".$urunlerim['durum']."");
    $objPHPExcel->getActiveSheet()->setCellValue("N".$tur."", "".$modul['url']."/images/urunler/".$urunlerim['resim']."");
    $tur++;
    }
	
	
    $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
    $objWriter->save("exceldosya/urunler.xlsx"); 
	header("Location: ".$modul['url']."/yonetim/exceldosya/urunler.xlsx");
	    $not = '<div class="alert alert-success">
		<button class="close" data-dismiss="alert"><i class="pci-cross pci-circle"></i></button>
		<strong>Tebrikler!</strong> Başarıyla Ürünler Dışa Aktardınız.
		</div>' ;

} elseif ($_POST['aktar']=='2') {
	
    $objPHPExcel = new PHPExcel();	
	$objPHPExcel->getProperties()->setCreator("Ürün Diğer Resimleri");
    $objPHPExcel->getProperties()->setTitle("Ürün Diğer Resimleri");
	
	// Add data
    $objPHPExcel->setActiveSheetIndex(0);
	$objPHPExcel->getActiveSheet()->setCellValue("A1", "Resim ID");
    $objPHPExcel->getActiveSheet()->setCellValue("B1", "Ürün Resmi");
    $objPHPExcel->getActiveSheet()->setCellValue("C1", "Ürün ID");
	$objPHPExcel->getActiveSheet()->setCellValue("D1", "");
    $tur = 2;
	
    $uk = $DB->query("select * from sayfa_resim where konu='urunler' order by id desc")->fetchAll(PDO::FETCH_ASSOC); 
    foreach($uk as $urunlerim){
	$objPHPExcel->getActiveSheet()->setCellValue("A".$tur."", "".$urunlerim['id']."");
	$objPHPExcel->getActiveSheet()->setCellValue("B".$tur."", "".$modul['url']."/images/diger/".$urunlerim['sayfaresim']."");
    $objPHPExcel->getActiveSheet()->setCellValue("C".$tur."", "".$urunlerim['resim_id']."");
    $objPHPExcel->getActiveSheet()->setCellValue("D".$tur."", "");
	$tur++;
    }
	
	
    $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
    $objWriter->save("exceldosya/urunresimleri.xlsx"); 
	header("Location: ".$modul['url']."/yonetim/exceldosya/urunresimleri.xlsx");
	
	    $not = '<div class="alert alert-success">
		<button class="close" data-dismiss="alert"><i class="pci-cross pci-circle"></i></button>
		<strong>Tebrikler!</strong> Başarıyla Ürün Resimlerini Dışa Aktardınız.
		</div>' ;

} elseif ($_POST['aktar']=='3') {

$objPHPExcel = new PHPExcel();	
	$objPHPExcel->getProperties()->setCreator("Ürün Kategorileri");
    $objPHPExcel->getProperties()->setTitle("Ürün Kategorileri");
	
	// Add data
    $objPHPExcel->setActiveSheetIndex(0);
	$objPHPExcel->getActiveSheet()->setCellValue("A1", "Kategori ID");
    $objPHPExcel->getActiveSheet()->setCellValue("B1", "Kategori Adı");
    $objPHPExcel->getActiveSheet()->setCellValue("C1", "Seo Linki");
	$objPHPExcel->getActiveSheet()->setCellValue("D1", "Kategori Resmi");
	$objPHPExcel->getActiveSheet()->setCellValue("E1", "Kategori İkonu");
    $tur = 2;
	
    $uk = $DB->query("select * from urunk order by id desc")->fetchAll(PDO::FETCH_ASSOC); 
    foreach($uk as $urunlerim){
	$objPHPExcel->getActiveSheet()->setCellValue("A".$tur."", "".$urunlerim['id']."");	
    $objPHPExcel->getActiveSheet()->setCellValue("B".$tur."", "".$urunlerim['baslik']."");
	$objPHPExcel->getActiveSheet()->setCellValue("C".$tur."", "".$urunlerim['seo']."");
    $objPHPExcel->getActiveSheet()->setCellValue("D".$tur."", "".$modul['url']."/images/urunk/".$urunlerim['resim']."");
	$objPHPExcel->getActiveSheet()->setCellValue("E".$tur."", "".$urunlerim['ititle']."");
    $tur++;
    }
	
	
    $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
    $objWriter->save("exceldosya/anakategoriler.xlsx");
    header("Location: ".$modul['url']."/yonetim/exceldosya/anakategoriler.xlsx");	
	
	    $not = '<div class="alert alert-success">
		<button class="close" data-dismiss="alert"><i class="pci-cross pci-circle"></i></button>
		<strong>Tebrikler!</strong> Başarıyla Ana Kategorileri Dışa Aktardınız.
		</div>' ;

} elseif ($_POST['aktar']=='4') {

$objPHPExcel = new PHPExcel();	
	$objPHPExcel->getProperties()->setCreator("Alt Kategoriler");
    $objPHPExcel->getProperties()->setTitle("Alt Kategoriler");
	
	// Add data
    $objPHPExcel->setActiveSheetIndex(0);
	$objPHPExcel->getActiveSheet()->setCellValue("A1", "Alt Kategori ID");
    $objPHPExcel->getActiveSheet()->setCellValue("B1", "Alt Kategori Adı");
	$objPHPExcel->getActiveSheet()->setCellValue("C1", "Seo Linki");
    $objPHPExcel->getActiveSheet()->setCellValue("D1", "Kategori Resmi");
	$objPHPExcel->getActiveSheet()->setCellValue("E1", "Üst Kategori ID");
    $tur = 2;
	
    $uk = $DB->query("select * from aurunk order by id desc")->fetchAll(PDO::FETCH_ASSOC); 
    foreach($uk as $urunlerim){
	$objPHPExcel->getActiveSheet()->setCellValue("A".$tur."", "".$urunlerim['id']."");	
    $objPHPExcel->getActiveSheet()->setCellValue("B".$tur."", "".$urunlerim['baslik']."");
	$objPHPExcel->getActiveSheet()->setCellValue("C".$tur."", "".$urunlerim['seo']."");
    $objPHPExcel->getActiveSheet()->setCellValue("D".$tur."", "".$modul['url']."/images/aurunk/".$urunlerim['resim']."");
	$objPHPExcel->getActiveSheet()->setCellValue("E".$tur."", "".$urunlerim['ititle']."");
    $tur++;
    }
	
	
    $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
    $objWriter->save("exceldosya/altkategoriler.xlsx");
    header("Location: ".$modul['url']."/yonetim/exceldosya/altkategoriler.xlsx");	
	
	    $not = '<div class="alert alert-success">
		<button class="close" data-dismiss="alert"><i class="pci-cross pci-circle"></i></button>
		<strong>Tebrikler!</strong> Başarıyla Alt Kategorileri Dışa Aktardınız.
		</div>' ;

} elseif ($_POST['aktar']=='5') {
		
		
    $objPHPExcel = new PHPExcel();	
	$objPHPExcel->getProperties()->setCreator("EnAlt Kategoriler");
    $objPHPExcel->getProperties()->setTitle("EnAlt Kategoriler");
	
	// Add data
    $objPHPExcel->setActiveSheetIndex(0);
	$objPHPExcel->getActiveSheet()->setCellValue("A1", "EnAlt Kategori ID");
    $objPHPExcel->getActiveSheet()->setCellValue("B1", "EnAlt Kategori Adı");
	$objPHPExcel->getActiveSheet()->setCellValue("C1", "Seo Linki");
    $objPHPExcel->getActiveSheet()->setCellValue("D1", "Kategori Resmi");
	$objPHPExcel->getActiveSheet()->setCellValue("E1", "Üst Kategori ID");
    $tur = 2;
	
    $uk = $DB->query("select * from baurunk order by id desc")->fetchAll(PDO::FETCH_ASSOC); 
    foreach($uk as $urunlerim){
	$objPHPExcel->getActiveSheet()->setCellValue("A".$tur."", "".$urunlerim['id']."");	
    $objPHPExcel->getActiveSheet()->setCellValue("B".$tur."", "".$urunlerim['baslik']."");
	$objPHPExcel->getActiveSheet()->setCellValue("C".$tur."", "".$urunlerim['seo']."");
    $objPHPExcel->getActiveSheet()->setCellValue("D".$tur."", "".$modul['url']."/images/baurunk/".$urunlerim['resim']."");
	$objPHPExcel->getActiveSheet()->setCellValue("E".$tur."", "".$urunlerim['ititle']."");
    $tur++;
    }
	
	
    $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
    $objWriter->save("exceldosya/enaltkategoriler.xlsx");
    header("Location: ".$modul['url']."/yonetim/exceldosya/enaltkategoriler.xlsx");	
	
	    $not = '<div class="alert alert-success">
		<button class="close" data-dismiss="alert"><i class="pci-cross pci-circle"></i></button>
		<strong>Tebrikler!</strong> Başarıyla Alt Kategorileri Dışa Aktardınız.
		</div>' ;

} elseif ($_POST['aktar']=='6') {
		
	
    $objPHPExcel = new PHPExcel();	
	$objPHPExcel->getProperties()->setCreator("Ürün Özellikleri");
    $objPHPExcel->getProperties()->setTitle("Ürün Özellikleri");
	
	// Add data
    $objPHPExcel->setActiveSheetIndex(0);
	$objPHPExcel->getActiveSheet()->setCellValue("A1", "Özellik ID");
    $objPHPExcel->getActiveSheet()->setCellValue("B1", "Ürün ID");
    $objPHPExcel->getActiveSheet()->setCellValue("C1", "Özellik Adı");
	$objPHPExcel->getActiveSheet()->setCellValue("D1", "Özellik Stok");
    $tur = 2;
	
    $uk = $DB->query("select * from urun_ozellik order by id desc")->fetchAll(PDO::FETCH_ASSOC); 
    foreach($uk as $urunlerim){
	$objPHPExcel->getActiveSheet()->setCellValue("A".$tur."", "".$urunlerim['id']."");
	$objPHPExcel->getActiveSheet()->setCellValue("B".$tur."", "".$urunlerim['resim_id']."");
    $objPHPExcel->getActiveSheet()->setCellValue("C".$tur."", "".$urunlerim['resim']."");
    $objPHPExcel->getActiveSheet()->setCellValue("D".$tur."", "".$urunlerim['ustok']."");
	$tur++;
    }
	
	
    $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
    $objWriter->save("exceldosya/urunozellik.xlsx"); 
	header("Location: ".$modul['url']."/yonetim/exceldosya/urunozellik.xlsx");
	
	    $not = '<div class="alert alert-success">
		<button class="close" data-dismiss="alert"><i class="pci-cross pci-circle"></i></button>
		<strong>Tebrikler!</strong> Başarıyla Ürün Resimlerini Dışa Aktardınız.
		</div>' ;

} 
 
 
 
 
 
 
 
 
 
 
} 
 ?>

<div class="content-wrapper">
    
    <section class="content-header">
      <h1>
        Excel Dışa Aktar
      </h1>
      <ol class="breadcrumb">
        <li class="breadcrumb-item"><a href="index.html"><i class="fa fa-home"></i> Anasayfa</a></li>
       <li class="breadcrumb-item"><a href="excelal.html"> Excel</a></li>
        <li class="breadcrumb-item active">Dışa Aktar</li>
      </ol>
	  <?=$not?>
    </section>

<section class="content">
	
      <div class="row">
        <div class="col-12">
         
   <div class="box box-default">
           
            
            <div class="box-body">
            
			      <form class="form-horizontal" action="#" method="post" enctype="multipart/form-data">
				
				<div class="tab-content">
					<div class="tab-pane active show" id="home1" role="tabpanel">
				
					    </br>
					   
						  
						
			<div class="form-group">
             <h5>Dışa Aktarılacak Kısım</h5>
             <div class="controls">
                 <select class="form-control" name="aktar">
                 <option class="form-control" value="0">Seçiniz</option>
                 <option class="form-control"  <?php echo $_POST['aktar'] == '1' ? 'selected' : null; ?> value="1">Ürünler</option>
                 <option class="form-control"  <?php echo $_POST['aktar'] == '6' ? 'selected' : null; ?>  value="6">Ürün Özellikleri</option>
				 <option class="form-control"  <?php echo $_POST['aktar'] == '2' ? 'selected' : null; ?>  value="2">Ürün Diğer Resimleri</option>
				 <option class="form-control"  <?php echo $_POST['aktar'] == '3' ? 'selected' : null; ?>  value="3">Ana Kategoriler</option>
				 <option class="form-control"  <?php echo $_POST['aktar'] == '4' ? 'selected' : null; ?>  value="4">Alt Kategoriler</option>
				 <option class="form-control"  <?php echo $_POST['aktar'] == '5' ? 'selected' : null; ?>  value="5">EnAlt Kategoriler</option>
				 
			</select>
          </div>
      </div>
      
						  
						 
													
														   
														   
														   
														   
														   
														   
														   
														   
					        </div>
					        </div>
					                          				
						
						
						
						
						
						
						
						
						
						
					</div>
					
					
					
					
					
		
					
					
					
					          
						                    <button type="submit" name="exceldis" id="button3" class="btn btn-block  btn-warning">Dışa Aktar</button>						
                                    
					
					
					
					
					
					
					
				</div>
				</form>
            </div>
            
          </div>

</div>
        
      </div>
      
    </section>
    
  </div>

İptal

📁 PHP Dosya Yöneticisi

📝 excelal.php

📝 excelal.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)