download csv php mysql

1CREATE TABLE `users` (
2  `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
3  `username` varchar(80) NOT NULL,
4  `name` varchar(50) NOT NULL,
5  `gender` varchar(10) NOT NULL,
6  `email` varchar(70) NOT NULL
7) ENGINE=InnoDB DEFAULT CHARSET=latin1;
8
9=========================================================
10// this config.php
11<?php
12$host = "localhost"; /* Host name */
13$user = "root"; /* User */
14$password = ""; /* Password */
15$dbname = "tutorial"; /* Database name */
16
17$con = mysqli_connect($host, $user, $password,$dbname);
18// Check connection
19if (!$con) {
20 die("Connection failed: " . mysqli_connect_error());
21}
22
23
24=================================================================
25// prints contents of db to a table with an export button
26<?php 
27include "config.php"; // Database connection file
28?>
29
30<div class="container">
31 
32 <form method='post' action='download.php'>
33  <input type='submit' value='Export' name='Export'>
34 
35  <table border='1' style='border-collapse:collapse;'>
36    <tr>
37     <th>ID</th>
38     <th>Username</th>
39     <th>Name</th>
40     <th>Gender</th>
41     <th>Email</th>
42    </tr>
43    <?php 
44     $query = "SELECT * FROM users ORDER BY id asc";
45     $result = mysqli_query($con,$query);
46     $user_arr = array();
47     while($row = mysqli_fetch_array($result)){
48      $id = $row['id'];
49      $uname = $row['username'];
50      $name = $row['name'];
51      $gender = $row['gender'];
52      $email = $row['email'];
53      $user_arr[] = array($id,$uname,$name,$gender,$email);
54   ?>
55      <tr>
56       <td><?php echo $id; ?></td>
57       <td><?php echo $uname; ?></td>
58       <td><?php echo $name; ?></td>
59       <td><?php echo $gender; ?></td>
60       <td><?php echo $email; ?></td>
61      </tr>
62   <?php
63    }
64   ?>
65   </table>
66   <?php 
67    $serialize_user_arr = serialize($user_arr);
68   ?>
69  <textarea name='export_data' style='display: none;'><?php echo $serialize_user_arr; ?></textarea>
70 </form>
71</div>
72    
73    
74    
75    =============================================================
76  //Create a new download.php file -- code below//  
77    
78    <?php
79$filename = 'users.csv';
80$export_data = unserialize($_POST['export_data']);
81
82// file creation
83$file = fopen($filename,"w");
84
85foreach ($export_data as $line){
86 fputcsv($file,$line);
87}
88
89fclose($file);
90
91// download
92header("Content-Description: File Transfer");
93header("Content-Disposition: attachment; filename=".$filename);
94header("Content-Type: application/csv; "); 
95
96readfile($filename);
97
98// deleting file
99unlink($filename);
100exit();