CSV importeer script
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
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<?php
include("../config.php");
if(isset($_POST['importeer'])){
$file = $_FILES['file']['name'];
$file = addslashes ($file);
$sql = "LOAD DATA INFILE '".$file."' INTO TABLE tbl_test";
echo 'Een moment geduld aub...';
mysql_query("$sql") or die(mysql_error());
header('Location: importeersql.php');
}
else {
?>
include("../config.php");
if(isset($_POST['importeer'])){
$file = $_FILES['file']['name'];
$file = addslashes ($file);
$sql = "LOAD DATA INFILE '".$file."' INTO TABLE tbl_test";
echo 'Een moment geduld aub...';
mysql_query("$sql") or die(mysql_error());
header('Location: importeersql.php');
}
else {
?>
<form action="importeersql.php" method="post" enctype="multipart/form-data">
<input type="file" name="file">
<input type="submit" name="importeer" value="importeer">
</form>
Code (php)
1
2
3
2
3
<?php
}
?>
}
?>
loklaal krijg ik de foutmelding:
c:\wamp\bin\mysql\mysql5.0.45\data\dchain\test.sql terwijl dit na mijn mening c:\wamp\www\www\test.sql moet zijn
En op het interent krijg ik:
Access denied for user 'dchain'@'%' (using password: YES)
