Savet zasto ovo ne radi?
31.07.2006. u 10:19 · pre 246 meseci
#1
Evo koda pa ako je neko imao slican problem neka da savet zasto ne radi?
Problem je pri load data infile nece da upise u MySQL zapis iz fajla koji uploadujem.
Tabela test sadrzi samo jednu kolonu koja se zove naziv
Unapred hvala
Poz.
Problem je pri load data infile nece da upise u MySQL zapis iz fajla koji uploadujem.
Tabela test sadrzi samo jednu kolonu koja se zove naziv
Code:
<? include 'dblogin.php'; ?>
<html>
<head>
<title>Test</title>
</head>
<body>
<form method="post" enctype="multipart/form-data" action="<? $PHP_SELF ?>">
<input type="file" name="filetoupload" /><br /><br /><input type="submit" value="Upload / Install" />
</form>
<?php
if(isset($_FILES['filetoupload']['tmp_name'])){
$uploaddir = "tmp/";
move_uploaded_file($_FILES['filetoupload']['tmp_name'],$uploaddir.$_FILES['filetoupload']['name']);
$filename = $_FILES['filetoupload']['name'];
$file = "tmp/".$filename;
$root = $_SERVER['DOCUMENT_ROOT']."/".$file;
mysql_query("load data infile '".$root."' into table test fields terminated by ';'");
}
$Qarhiva = mysql_query("select naziv from test order by naziv");
while($result = mysql_fetch_assoc($Qarhiva)){
echo $result['naziv']."<br>";
}
?>
</body>
</html>
<? include 'dblogin.php'; ?>
<html>
<head>
<title>Test</title>
</head>
<body>
<form method="post" enctype="multipart/form-data" action="<? $PHP_SELF ?>">
<input type="file" name="filetoupload" /><br /><br /><input type="submit" value="Upload / Install" />
</form>
<?php
if(isset($_FILES['filetoupload']['tmp_name'])){
$uploaddir = "tmp/";
move_uploaded_file($_FILES['filetoupload']['tmp_name'],$uploaddir.$_FILES['filetoupload']['name']);
$filename = $_FILES['filetoupload']['name'];
$file = "tmp/".$filename;
$root = $_SERVER['DOCUMENT_ROOT']."/".$file;
mysql_query("load data infile '".$root."' into table test fields terminated by ';'");
}
$Qarhiva = mysql_query("select naziv from test order by naziv");
while($result = mysql_fetch_assoc($Qarhiva)){
echo $result['naziv']."<br>";
}
?>
</body>
</html>
Unapred hvala
Poz.
Potpis
There's no place like 127.0.0.1