1#@!#!123s

file_get_contents 1#@!#!123s
: / home / u247928417 / domains / riddi.in / public_html / admin / reports /
Filename : download-category-details.php
back
<?php
include ("../session/session.php");
include ("../config/config.php");
//xls download function start here
  function cleanData($str)
  {
    $str = preg_replace("/\t/", "\\t", $str);
    $str = preg_replace("/\r?\n/", "\\n", $str);
    if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';
  }

  // filename for download
  $filename = $_REQUEST['cname'].'-'. date('d-m-Y') . ".xls";

  header("Content-Disposition: attachment; filename=\"$filename\"");
  header("Content-Type: application/vnd.ms-excel");
 //xls download function end here
 

 ?>

 
 <table class="table table-striped table-bordered" style="border:2px solid #ccc;padding:5px;" border="1">
  <tr class="sales">
   
    <td style="background-color:#333;color:#fff;"><strong>Category Name</strong></td>
    <td style="background-color:#333;color:#fff;"><strong>Status</strong></td>
    <td style="background-color:#333;color:#fff;"><strong>Created</strong></td>
    <td style="background-color:#333;color:#fff;"><strong>Product Code</strong></td>
    <td style="background-color:#333;color:#fff;"><strong>Product Ean Code</strong></td>
    <td style="background-color:#333;color:#fff;"><strong>Product Name</strong></td>
    <td style="background-color:#333;color:#fff;"><strong>Product Type</strong></td>
    <td style="background-color:#333;color:#fff;"><strong>Product Status</strong></td>
    <td style="background-color:#333;color:#fff;"><strong>Product Short Desc</strong></td>
    <td style="background-color:#333;color:#fff;"><strong>Code</strong></td>
	<td style="background-color:#333;color:#fff;"><strong>Price</strong></td>
	<td style="background-color:#333;color:#fff;"><strong>Product Weight</strong></td>
 
  </tr>
  
 <?php 
 //distinct year
$sel_dis_year= "SELECT * 
FROM  `interface_categories` t1
LEFT JOIN  `interface_procategories` t2 ON t1.`category_id` = t2.`sub_category_id` 
LEFT JOIN  `interface_product` t3 ON t2.`product_id` = t3.`product_id` 
LEFT JOIN  `interface_price` t4 ON t3.`product_id` = t4.`product_id` 
WHERE t2.`sub_category_id`='".$_REQUEST['sub_menu_id']."' and product_price!='0' and product_price!=''";
$result_dis_year =mysqli_query($conn,$sel_dis_year) or die(mysqli_error());
while($data=mysqli_fetch_assoc($result_dis_year)){


?>
  
  <tr>
   
		<td><?php echo $data['category_name'];?></td>
		<td><?php echo $data['cat_status'];?></td>
		<td><?php echo $data['created'];?></td>
		<td><?php echo $data['product_code'];?></td>
		<td><?php echo $data['ean_code'];?></td>
		<td><?php echo $data['product_name'];?></td>
		<td><?php echo $data['product_type'];?></td>
		<td><?php echo $data['product_status'];?></td>
		<td><?php echo $data['product_s_desc'];?></td>
		<td><?php echo $data['code'];?></td>
		<td><?php echo $data['product_price'];?></td>
		<td><?php echo $data['product_pec_weight'];?></td>
  
   
  
  </tr>
 
 <?php }?> 

</table>