ten einde raad
onderstaande code to sofar:
Code (php)
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
142
143
144
145
146
147
148
149
150
151
152
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
142
143
144
145
146
147
148
149
150
151
152
<?
if(!isset($_POST['option']))
{
echo $page;
}
elseif($_POST['option'] == "yes")
{
$sql = 'TRUNCATE TABLE `veolia`';
$resultaat = mysql_query($sql);
$uploaddir = './uploads/';
$uploadfile = $uploaddir . $_FILES['csvfile']['name'];
if (move_uploaded_file($_FILES['csvfile']['tmp_name'], $uploadfile))
{
print "<font face='arial'>Succesvol geupload. ";
$notice = 1;
chmod($uploadfile, 0777);
}
else
{
print "<font face='arial'>ERROR: Upload Fout. ";
$notice = 0;
}
$strdata = array();
$notice = 1;
if($notice == 1)
{
echo "\n sending Data...";
flush();
echo "</font>";
if (file_exists($uploadfile))
{
$fp = fopen($uploadfile, 'r') or die (" Cannot open the file");
$row = 1;
$handle = $fp;
while (($data = fgetcsv($handle, 10240, ";")) !== FALSE)
{
$num = count($data);
echo "<p> ".$num." fields in line ".$row.": <br /></p>\n";
$row++;
for ($c = 0; $c < $num; $c = $c + 1)
{
$data[$c] = str_replace(',', ' ', $data[$c]);
$data[$c] = str_replace(' ', ';', $data[$c]);
$str = $data[$c];
$strdata[ ] = explode(';', $str);
}
}
fclose($handle);
}
}
echo '<pre>';
print_r($strdata);
echo '</pre>';
}
?> [\code]
bovenstaande code geeft het volgende resultaat wat ik graag in een database had weggeschreven.
Array
(
[0] => Array
(
[0] => BH
)
[1] => Array
(
[0] => 31-10-2008
[1] => 22:41
)
[2] => Array
(
[0] => GPS
[1] => 1
[2] => 00:00:00
[3] => X:0
[4] => Y:0
)
[3] => Array
(
[0] => 0
)
[4] => Array
(
[0] => 0.00
)
[5] => Array
(
[0] => 0.00
)
[6] => Array
(
[0] => 26
)
[7] => Array
(
[0] => 0
[1] => 0
[2] => "NL
[3] => KPN"
)
[8] => Array
(
[0] => 0.12000
)
[9] => Array
(
[0] => DE
)
[10] => Array
(
[0] => 31-10-2008
[1] => 22:42
)
[11] => Array
(
[0] => GPS
[1] => 1
[2] => 00:00:00
[3] => X:0
[4] => Y:0
)
[12] => Array
(
[0] => Open
)
[13] => Array
enz enz enz
if(!isset($_POST['option']))
{
echo $page;
}
elseif($_POST['option'] == "yes")
{
$sql = 'TRUNCATE TABLE `veolia`';
$resultaat = mysql_query($sql);
$uploaddir = './uploads/';
$uploadfile = $uploaddir . $_FILES['csvfile']['name'];
if (move_uploaded_file($_FILES['csvfile']['tmp_name'], $uploadfile))
{
print "<font face='arial'>Succesvol geupload. ";
$notice = 1;
chmod($uploadfile, 0777);
}
else
{
print "<font face='arial'>ERROR: Upload Fout. ";
$notice = 0;
}
$strdata = array();
$notice = 1;
if($notice == 1)
{
echo "\n sending Data...";
flush();
echo "</font>";
if (file_exists($uploadfile))
{
$fp = fopen($uploadfile, 'r') or die (" Cannot open the file");
$row = 1;
$handle = $fp;
while (($data = fgetcsv($handle, 10240, ";")) !== FALSE)
{
$num = count($data);
echo "<p> ".$num." fields in line ".$row.": <br /></p>\n";
$row++;
for ($c = 0; $c < $num; $c = $c + 1)
{
$data[$c] = str_replace(',', ' ', $data[$c]);
$data[$c] = str_replace(' ', ';', $data[$c]);
$str = $data[$c];
$strdata[ ] = explode(';', $str);
}
}
fclose($handle);
}
}
echo '<pre>';
print_r($strdata);
echo '</pre>';
}
?> [\code]
bovenstaande code geeft het volgende resultaat wat ik graag in een database had weggeschreven.
Array
(
[0] => Array
(
[0] => BH
)
[1] => Array
(
[0] => 31-10-2008
[1] => 22:41
)
[2] => Array
(
[0] => GPS
[1] => 1
[2] => 00:00:00
[3] => X:0
[4] => Y:0
)
[3] => Array
(
[0] => 0
)
[4] => Array
(
[0] => 0.00
)
[5] => Array
(
[0] => 0.00
)
[6] => Array
(
[0] => 26
)
[7] => Array
(
[0] => 0
[1] => 0
[2] => "NL
[3] => KPN"
)
[8] => Array
(
[0] => 0.12000
)
[9] => Array
(
[0] => DE
)
[10] => Array
(
[0] => 31-10-2008
[1] => 22:42
)
[11] => Array
(
[0] => GPS
[1] => 1
[2] => 00:00:00
[3] => X:0
[4] => Y:0
)
[12] => Array
(
[0] => Open
)
[13] => Array
enz enz enz
Gewijzigd op 01/01/1970 01:00:00 door Bart nukem
Gewijzigd op 01/01/1970 01:00:00 door yorick17
yorick17 schreef op 11.12.2008 15:27:
gebruik bij php de php definitie en bij html de code definitie
zal ik gaan doen.... heb je misschien ook een oplossing voor mij
yorick17 schreef op 11.12.2008 15:42:
dus je wil 2 variable in een tabel veld?
ligt iets anders. voorbeeld. excel file heeft een cel met als inhoud datum en tijd. met load data infile kan ik de gehele excel (csv) file makkelijk inlezen maar dus niet de data splitsen, 1 veldnaam datum 2. veldnaam tijd