1#@!#!123s

file_get_contents 1#@!#!123s
: / home / u247928417 / domains / fruitbagan.com / public_html / admin / reports /
Filename : view-brandlist.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 = "Brand-list-" . date('d-m-Y') . ".xls";

  header("Content-Disposition: attachment; filename=\"$filename\"");
  header("Content-Type: application/vnd.ms-excel");
 //xls download function end here
 
 
$sel_discount= "SELECT DISTINCT (`brand_name`) as brand_name,manufactured_id
FROM  `interface_manufactured` ";
$disc_result =mysqli_query($conn,$sel_discount) or die(mysqli_error());

 ?>


<table class="table table-striped table-bordered" border="0">
                                                <thead>
                                                    <tr>
                                                       
                                                        <th> Brand ID </th>
                                                        <th> Brand Name </th>
                                                    </tr>
                                                </thead>

                                                <tbody>
                                                    <?php while ($fetch_discount= mysqli_fetch_assoc($disc_result)) {?>
                                                            <tr>
                                                               
                                                                <td><b><?php echo $fetch_discount['manufactured_id']; ?></b></td>
                                                                <td><b><?php echo $fetch_discount['brand_name']; ?></b></td>
                                                            </tr>
                                                            <?php } ?>
                                                </tbody>

                                            </table>