MAINHACK

Viewing / Editing File: excel_project.php

<?php  
include '../settings/settings.php';  
$file=uniqid();
$file_name=$file.'.xls';
$output = '';
if(isset($_POST["export"]))
{
// $query = "SELECT * FROM client";
 $query = "select * from project order by 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>Project Date</th>
                                        <th>Project Type</th>
                                        <th>Title</th>
                                        <th>Contact Person</th>
                                        <th>Proposed Cost</th>
                                        <th>Final Cost</th>
                                        <th>Note</th>
                                        <th>Renewal Date</th>
                                        <th>Description</th>
                                            </tr>
  ';
  while($row= $result->fetch(PDO::FETCH_ASSOC))
  {
 
   $output .= '
    <tr>  
                        	<td>'.date("d-m-Y",strtotime($row["date"])).'</td>
								<td>'.$row["project_type"].'</td>
								<td>'.$row["title"].'</td>
								<td>'.$row["customer_id"].'<br>'.$row["customer_name"].'<br>'.$row["customer_phone"].'</td>
								<td>'.$row["proposed_cost"].'</td>
								<td>'.$row["final_cost"].'</td>
								<td>'.$row['note'].'</td>
                         	<td>'.date("d-m-Y",strtotime($row["renewal_date"])).'</td>
 								<td>'.$row['description'].'</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_project.php

Server Info

System Features

User Info