MAINHACK

Viewing / Editing File: excel_bill.php

<?php  
include '../settings/settings.php';  
$file=uniqid();
$file_name=$file.'.xls';
$output = '';
if(isset($_POST["export"]))
{
// $query = "SELECT * FROM client";
 $query = "select *,inovice.date as indate,inovice.type as btype from inovice left join client on inovice.client_id=client.client_id order by inovice.id desc";
//echo $query;
 $result = $con->prepare($query);
 $result->execute();
 $c=$result->rowCount();
 echo $c;
 
 if($c > 0)
 {
  $output .= '
   <table class="table" border="1">  
                                        <tr>  
                                         <th>Bill Date</th>
                                            <th>Type</th>
                                            <th>Fileable</th>
                                            <th>Bill Id</th>
                                            <th>Client Details</th>
                                            <th>Total Cost</th>
                                            </tr>
  ';
  while($row= $result->fetch(PDO::FETCH_ASSOC))
  {
 
   $output .= '
    <tr>  
                        	<td>'.date("d-m-Y",strtotime($row["indate"])).'</td>
								<td>'.$row["btype"].'</td>
								<td>'.$row["fileable"].'</td>
								<td>'.$row["bill_id"].'</td>
								<td>'.$row["client_id"].'<br>'.$row["name"].'<br>'.$row["phone"].'<br>'.$row["email"].'</td>
								<td>'.$row["total"].'</td>
								
                         
                    </tr>';
  }
  $output .= '</table>';
  header('Content-Type: application/xls');
  header('Content-Disposition: attachment; filename='.$file_name);
  echo $output;
 }
}
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: excel_bill.php

Server Info

System Features

User Info