upload.php
1.23 KB
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
<?php
include("../include/init.php");
if(isset($_POST)) {
$fh = fopen($_FILES['uploadedfile']['tmp_name'], 'r');
while (!feof($fh)) {
$line = fgets($fh);
if(preg_match('/^[0-9]{2}\.[0-9]{2}\.[0-9]{4}/', $line)) {
$tl = split(";", $line . fgets($fh));
$date = $tl[0];
$sum = $tl[2];
$viite = preg_replace('/VIITESIIRTO[ ]*/', '', $tl[4]);
$siirtotunnus = trim($tl[6]);
$maksaja = trim($tl[10]);
$stunnus = $db->quote($siirtotunnus);
if( !$db->fetchOne("SELECT CHECKSUM FROM TRANSACTIONS WHERE CHECKSUM = $stunnus")) {
$db->insert("TRANSACTIONS", array('PAYDATE' => $date, 'SUM' => $sum, 'REFERENCE' => $viite, 'CHECKSUM' => $siirtotunnus, 'PAYER' => $maksaja));
echo "Lisatty seuraavat tiedot:$date $sum $viite $siirtotunnus $maksaja<br>";
}
}
# $db->query("SELECT ");
}
}
$asia .= "
<form enctype='multipart/form-data' action='upload.php' method='POST'>
<input type='hidden' name='MAX_FILE_SIZE' value='100000' />
Valitse ladattava tiedosto: <input name='uploadedfile' type='file' /><br />
<input type='submit' value='Lataa' />
</form>
";
echo $asia;
?>