MAINHACK

Viewing / Editing File: export.php

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

$result = $con->prepare($query);
  $result->execute();
 $num = $result->rowCount();
 if($num > 0)
 {
  $output .= '
   <table class="table" border="1">  
                    <tr>  
                         <th>Date</th>
							      <th>User Committee</th>
							      <th>Designation</th>
							      <th>User ID</th>
							      <th>Name</th>
								  <th>Email</th>
								  <th>Phone</th>
								  <th>Address</th>
								  <th>Rastriya </th>
								  <th>Zilla </th>
								  <th>Tehsil </th>
								  <th>Block </th>
								  <th>Booth </th>
								  <th>City</th>
								  <th>Pincode</th>
								  <th>Status</th>
								  <th>Approve</th>
                    </tr>
  ';
  while($row = $result->fetch(PDO::FETCH_ASSOC))
  {

$committee=$row['committee']==''?'<b>COMMITTEE NOT ADDED</b>':'<b>'.$row['committee'].'</b>';

$approve=$row['approve']=='1'?'APPROVED':'NOT-APPROVED';

$output .= '
    <tr>  
                         <td>'.date('d-m-Y',strtotime($row['created_at'])).'</td>  
                         <td>'.$committee.'</td>  
                         <td>'.$row["designation"].'</td> 
                         <td>'.$row["user_id"].'</td>  
                          <td>'.$row["name"].'</td>  
                        <td>'.$row["email"].'</td>  
                         <td>'.$row["phone"].'</td>
                         <td>'.$row["address"].'</td>
                         <td>'.$row["state"].'</td>
                         <td>'.$row["zilla"].'</td>
                         <td>'.$row["tehsil"].'</td>
                         <td>'.$row["block"].'</td>
                         <td>'.$row["booth"].'</td>
                         <td>'.$row["city"].'</td>
                         <td>'.$row["pincode"].'</td>
                          <td>'.$row["status"].'</td>
                         <td>'.$approve.'</td>
                        
                    </tr>';
  }
  $output .= '</table>';
  header('Content-Type: application/xls');
  header('Content-Disposition: attachment; filename='.$file_name);
  echo $output;
 }
}
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: export.php

Server Info

System Features

User Info