MAINHACK

Viewing / Editing File: export2.php

<?php  
//export.php  
include '../../settings/settings.php';
$file=uniqid();
$file_name=$file.'.xls';
//$connect = mysqli_connect("localhost", "bharatsa_db", "hackit_321", "bharatsa_db");
$output = '';
if(isset($_POST["export"]))
{
// $query = "SELECT * FROM client";
 $query = "select * from franchise  order by id desc";

$result = $con->prepare($query);
 $result->execute();
 $num = $result->rowCount();
 if($num> 0)
 {
  $output .= '
   <table class="table" border="1">  
                    <tr>  
                    <th>Registration Date</th>
                    <th>franchise ID</th>     
                    <th>Company Name</th>
                    <th>Contact Person</th>
                    <th>Email </th>
                    <th> Phone</th>
                    <th>Address</th>
                    </tr>
  ';
while ($row = $result->fetch(PDO::FETCH_ASSOC)){  
   $output .= '
    <tr>  
                         <td>'.date("d-m-Y",strtotime($row["date_of_register"])).'</td>  
                         <td>'.$row["franchise_id"].'</td>  
                         <td>'.$row["company_name"].'</td>  
                         <td>'.$row["name"].'</td>
                          <td>'.$row["email"].'</td>
                       <td>'.$row["phone1"].'</td>
                         <td>'.$row["address"].'</td>
                         
                    </tr>';
  }
  $output .= '</table>';
  header('Content-Type: application/xls');
  header('Content-Disposition: attachment; filename='.$file_name);
  echo $output;
 
}
}
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: export2.php

Server Info

System Features

User Info