project/index.php at master · FMFluke/project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
<?php


if (isset($_POST["convert"])) {
   $filetoname = basename($_FILES['xlsxfile']['name']);
   if($filetoname==""){$alert = "Select a file";}else{
   $ext = substr($filetoname,-4);
   if($ext!="xlsx"){$alert = "Invalid file type.
$result=0;Select an .xlsx file.";}else{
    $throttle=$_POST['throttle'];
    //$throttle=preg_replace("/[^0-9]/","",$throttle);
   $result = @move_uploaded_file($_FILES['xlsxfile']['tmp_name'], $filetoname); // upload it
    $file=$filetoname;
    $throttle=$_POST["throttle"];
require_once 'xlsx2csv.php';

$newcsvfile  = str_replace(".xlsx",".csv",$file);
$newcsvfile ="csv/$newcsvfile";
header('Location: index.php?download='.$newcsvfile.'');}; };};


if(isset($_GET['file'])&&file_exists($_GET['file'])) { $downloadfile=$_GET['file'];
header('Content-disposition: attachment; filename='.$downloadfile.'');
header("Content-length: " . filesize($downloadfile));
header('Content-type: application/csv');
readfile(''.$downloadfile.'');
die();
} ;
 $file="";
 $alert="";
 $redir="";
if(isset($_GET['download'])){  $file = $_GET['download'];
$alert = "Your download will start in <span id='timer'>5</span>
 seconds<br/>or click <a href=$file>this link</a> to start download now:";
 $redir= '<meta http-equiv="refresh" content="5;url=index.php?file='.$file.'">'; };

echo '<!DOCTYPE HTML>
<html>
  <head>
  <meta http-equiv="content-type" content="text/html;charset=utf-8">
  '.$redir.'
  <title>XLSX2CSV Demo</title>
  <style type="text/css">
  body{
  text-align:center;
  }
  #container{
  width:800px;
  margin:0 auto;
  margin-top:50px;
  text-align:left;
  }
  p {
  font-weight:800;
  margin-bottom:5px;
  }
  .alert{
  color:rgb(204,0,0);
  }
  .button {
    font-weight:800;
    padding:3px;
    border: 1px solid rgb(0,0,153);
    background: rgb(204,255,255);
    margin-top:15px;
    cursor:pointer;
}
  .button:hover {
    border: 1px solid rgb(0,0,102);
    background: rgb(153,204,255);

}
   #timer{
   display:inline;
   }

   #xlsxfile{
   width:150px;
   }

  </style>

   <script type="text/javascript">
  function message(){
  document.getElementById("msg").innerHTML="Processing<blink>...</blink>";

  }  ;


/**
* Countdown timer from http://forum.codecall.net/topic/51639-how-to-create-a-countdown-timer-in-javascript/
*/
var Timer;
var TotalSeconds;
function CreateTimer(TimerID, Time) {
    Timer = document.getElementById(\'TimerID\');
    TotalSeconds = Time;
    UpdateTimer() ;
    setTimeout("Tick()", 1000);
} ;

function Tick() {
    TotalSeconds -= 1;
    UpdateTimer() ;
    setTimeout("Tick()", 1000);
} ;

function UpdateTimer() {
    document.getElementById(\'timer\').innerHTML = TotalSeconds;

}  ;
 function init(){setTimeout("document.getElementById(\'msg\').innerHTML=\'\'",5500);CreateTimer("timer",5);};
  window.onload=init;


  </script>
  </head>
  <body >
<div id="container">
<h1>Upload File Demo</h1>
<h3 class="alert" id="msg">'.$alert.'</h3>
<form action="#" method="post" enctype="multipart/form-data">
    Select file to upload:
    <br>
    <input type="file" name="xlsxfile" size="40" />
    <input type="hidden" name="convert">
<br />
    <b>Table Name</b>
    <br>
    <input type="text" name="table" required>
    <br>
    <input type="text" name="throttle" id="throttle" value="0" onkeyup="this.value=this.value.replace(/[^\d]/,\'\')"  size="5"> # of rows to convert (0 = no limit) <br />
    <input type="submit" class="button" name = "upload"  onClick="message()"  value="Convert to CSV" />
</form>
</div>
</body>
</html>';


?>