1   <?php
2  require('login.php');
3  require('incs/dbconnect.php');
4  if($action =="export_tbl"):
5          
6   // Export Data Function //
7          $_datehashed=date("Ymd-hms");
8                  
9          function export_data($tablename)
10          {
11          global $dbname, $_datehashed ;
12          $dir = "/tmp";
13          $export_file = $dir . "/" . $tablename . "." . $_datehashed . "." .sql;
14 
15                  $qry = "SELECT * FROM $tablename
16           INTO OUTFILE '$export_file'
17           FIELDS TERMINATED BY ','
18           OPTIONALLY ENCLOSED BY ''
19           ESCAPED BY '\\\\'";
20                  
21                  $result = mysqlquery("$dbname","$qry");
22                          if (!empty($result)) {
23                                  // Do nothing
24 
25                                  } else {
26                                  echo mysql_error()."<BR>\n";
27                                  echo "$qry";
28                           }
29 
30          }
31                                  export_data($tablename);
32                                  $dir = "/tmp";
33                                  $export_file = $dir . "/" . $tablename . "." . $_datehashed . "." .sql;
34                                  $_gzip = "/bin/tar";
35                                  $exportdir = "./exports/";
36                                  $gz_dump = "$_gzip -czf $exportdir$tablename$_datehashed.tar.gz $export_file";
37                                  exec ("$gz_dump");
38                                  print " Current Directory : $exportdir <BR>The Export Created: $exportdir$tablename$_datehashed.tar.gz";
39                                  print "<TABLE BORDER=\"1\">\n";
40                                  print "<TR>";
41                                  print "<TH>File Name</TH>\n<TH>File Size</TH>\n";
42                                  print "</TR>";
43                                  chdir("./exports");
44                                  $getDir = ir(".");
45                                  while($entryname = readdir($getDir))
46                                  {
47                                          print "<TR>";
48                                          print "<TD>$entryname</TD>\n<TD ALIGN=\"right\">";
49                                          print(filesize($entryname));
50                                          print "</TD></TR>";
51                                  }
52                                  closedir($getDir);
53                                  print "</TABLE>";
54                                          
55  endif;
56 
57  ?>