Gecko [ italicatiles.com ]

Name	Size	Permission
ajax	[ DIR ]	drwxr-xr-x
app-assets	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
module	[ DIR ]	drwxr-xr-x
PhpXlsxGenerator.php	54.22 KB	-rw-r--r--
ad_contact_details.php	14.65 KB	-rw-r--r--
add_360_category.php	4.56 KB	-rw-r--r--
add_360_products.php	7.11 KB	-rw-r--r--
add_application.php	5.06 KB	-rw-r--r--
add_blogs.php	8.72 KB	-rw-r--r--
add_brands.php	6.56 KB	-rw-r--r--
add_catalogues.php	7.02 KB	-rw-r--r--
add_collections.php	12.59 KB	-rw-r--r--
add_division.php	8.29 KB	-rw-r--r--
add_effects.php	4.95 KB	-rw-r--r--
add_events.php	10.41 KB	-rw-r--r--
add_gallery.php	8.79 KB	-rw-r--r--
add_main_event.php	8.63 KB	-rw-r--r--
add_multiple_products.php	10.54 KB	-rw-r--r--
add_products.php	28.81 KB	-rw-r--r--
add_series.php	7.45 KB	-rw-r--r--
add_thickness.php	6.63 KB	-rw-r--r--
all_360_category.php	9.63 KB	-rw-r--r--
all_360_products.php	7.63 KB	-rw-r--r--
all_application.php	10.43 KB	-rw-r--r--
all_blogs.php	10.91 KB	-rw-r--r--
all_brands.php	7.07 KB	-rw-r--r--
all_catalogues.php	10.05 KB	-rw-r--r--
all_collections.php	7.01 KB	-rw-r--r--
all_division.php	7.38 KB	-rw-r--r--
all_effects.php	10.26 KB	-rw-r--r--
all_events.php	10.29 KB	-rw-r--r--
all_gallery.php	10.48 KB	-rw-r--r--
all_main_events.php	10 KB	-rw-r--r--
all_products.php	18.18 KB	-rw-r--r--
all_products_new.php	13.4 KB	-rw-r--r--
all_series.php	10.23 KB	-rw-r--r--
all_sub_collections.php	7.4 KB	-rw-r--r--
all_sub_division.php	7.76 KB	-rw-r--r--
all_thickness.php	7.64 KB	-rw-r--r--
divisions.php	486 B	-rw-r--r--
edit_360_category.php	5.04 KB	-rw-r--r--
edit_360_products.php	7.9 KB	-rw-r--r--
edit_application.php	5.88 KB	-rw-r--r--
edit_blogs.php	9.46 KB	-rw-r--r--
edit_brands.php	7.4 KB	-rw-r--r--
edit_catalogue.php	7.95 KB	-rw-r--r--
edit_collections.php	16.95 KB	-rw-r--r--
edit_gallery.php	8.85 KB	-rw-r--r--
edit_main_events.php	9.79 KB	-rw-r--r--
edit_product.php	35.18 KB	-rw-r--r--
edit_series.php	8.98 KB	-rw-r--r--
edit_sub_collections.php	17.26 KB	-rw-r--r--
edit_sub_event.php	10.73 KB	-rw-r--r--
edit_thickness.php	7.58 KB	-rw-r--r--
export_excel.php	4.21 KB	-rw-r--r--
functions.php	523 B	-rw-r--r--
index.php	3.77 KB	-rw-r--r--
login.php	6.83 KB	-rw-r--r--
logout.php	92 B	-rw-r--r--

Code Editor : export_excel.php

<?php
	include("module/obops.php");
	header("Content-Type: application/csv");

if (isset($_GET['size'])) { 
		$query = $conn->query("SELECT * FROM `tbl_product` where size_id = '".$_GET['size']."' ") or die(mysqli_errno());

} elseif (isset($_GET['finish'])) {

$query = $conn->query("SELECT * FROM `tbl_product` where finish_id = '".$_GET['finish']."' ") or die(mysqli_errno());

} else {

$query = $conn->query("SELECT * FROM `tbl_product`") or die(mysqli_errno());
	}

while($fetch = $query->fetch_array()){

$sel_collection="SELECT * from tbl_collection where `collection_id` = '".$fetch['collection_id']."'";
    $collection = mysqli_query($conn,$sel_collection);
    $collection_name = mysqli_fetch_assoc($collection);

$sel_size="SELECT * from tbl_collection where `collection_id` = '".$fetch['size_id']."'";
    $size = mysqli_query($conn,$sel_size);
    $size_name = mysqli_fetch_assoc($size);

$sel_finish="SELECT * from tbl_collection where `collection_id` = '".$fetch['finish_id']."'";
    $finish = mysqli_query($conn,$sel_finish);
    $finish_name = mysqli_fetch_assoc($finish);

$name = 'product_list_'.$collection_name['collection_name'].'_'.$size_name['collection_name'];

header("Content-Disposition: attachment; filename=$name.csv");  
	}
	header("Pragma: no-cache"); 
	header("Expires: 0");
 
 ?>
		<table style="border: 1px solid #000;">

<thead style="border: 1px solid #000;">
				<tr>
					<th style="border: 1px solid #000;">Product Name</th>
          <th style="border: 1px solid #000;">Collection</th>
          <th style="border: 1px solid #000;">Size</th>
          <th style="border: 1px solid #000;">Finish</th>
          <th style="border: 1px solid #000;">Thickness</th>
          <th style="border: 1px solid #000;">Preview</th>
          <th style="border: 1px solid #000;">Main Tile</th>
				</tr>
			</thead>

<?php 
 	                      
  	if (isset($_GET['size'])) { 
			$query = $conn->query("SELECT * FROM `tbl_product` where size_id = '".$_GET['size']."' ") or die(mysqli_errno());

} elseif (isset($_GET['finish'])) {

$query = $conn->query("SELECT * FROM `tbl_product` where finish_id = '".$_GET['finish']."' ") or die(mysqli_errno());

} else {

$query = $conn->query("SELECT * FROM `tbl_product`") or die(mysqli_errno());
		}

while($fetch = $query->fetch_array()){

$sel_collection="SELECT * from tbl_collection where `collection_id` = '".$fetch['collection_id']."'";
	  	$collection = mysqli_query($conn,$sel_collection);
	  	$collection_name = mysqli_fetch_assoc($collection);

$sel_size="SELECT * from tbl_collection where `collection_id` = '".$fetch['size_id']."'";
	  	$size = mysqli_query($conn,$sel_size);
	  	$size_name = mysqli_fetch_assoc($size);

$sel_finish="SELECT * from tbl_collection where `collection_id` = '".$fetch['finish_id']."'";
	  	$finish = mysqli_query($conn,$sel_finish);
	  	$finish_name = mysqli_fetch_assoc($finish);
 
	?>
				<tr style="border: 1px solid #000;">
					<td style="border: 1px solid #000;"><?= $fetch['prod_name']; ?></td>
					<td style="border: 1px solid #000;"><?= $collection_name['collection_name']; ?></td>
					<td style="border: 1px solid #000;"><?= $size_name['collection_name']; ?></td>
					<td style="border: 1px solid #000;"><?= $finish_name['collection_name']; ?></td>
					<td style="border: 1px solid #000;"><?= $fetch['thickness']; ?></td>

<?php if ($fetch['prod_image'] == 0 || $fetch['prod_image'] == '') { ?>

<?php } else { ?>

<?php } ?>

<?php if ($fetch['prod_image2'] == 0 || $fetch['prod_image2'] == '') { ?>

<?php } else { ?>

<?php } ?>
				</tr>
	
<?php } ?>

</tbody>
 
		</table>

${this.title}

Code Editor : export_excel.php