MAINHACK

Viewing / Editing File: excel_user.php

<?php  
include '../../settings/settings.php';  
$file=uniqid();
$file_name=$file.'.xls';
$output = '';
if(isset($_POST["export"]))
{
// $query = "SELECT * FROM client";
 $query = "select * from user order by id desc";
//echo $query;
 $result = $con->prepare($query);
 $result->execute();
 $c=$result->rowCount();

if($c > 0)
 {
  $output .= '
   <table class="table" border="1">  
                    <tr>  
								   <th>Date</th>
                                <th>Name </th>
                                <th>Email</th>
                                <th>Phone</th>
                                <th>City</th>
                                <th>Address</th>
                                <th>Status</th>
                                <th>Exam Given</th>
                                <th>Packages</th>
  ';
  while($row= $result->fetch(PDO::FETCH_ASSOC))
  {
  $s1=$show->readwithdata('result','user_id',$row['user_id']);
    $n1=$s1->rowCount();
    $s11=$show->readwithdata('user_package','user_id',$row['user_id']);
    $n11=$s11->rowCount(); 
   $output .= '
    <tr>  
                       <td>'.date("d-m-Y",strtotime($row["date_of_creation"])).'</td>  
                        <td>'.$row["name"].'</td>  
                        <td>'.$row["email"].'</td>  
                        <td>'.$row["phone"].'</td>  
                        <td>'.$row["city"].'</td>  
                        <td>'.$row["address"].'</td>  
                        <td>'.$row["status"].'</td>  
                        <td>'.$n1.'</td>  
                         <td>'.$n11.'</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_user.php

Server Info

System Features

User Info