multiple upload og MySQL database
Jeg har 2 sider.Den første side
---------------side 1 start--------------------------------<?
$c_table = $year.$month.$day;
session_start();
$opret = array($c_table);
session_register("opret");
include("connect.php");
$sql_query = "CREATE TABLE `".$c_table."` (`id` TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY, `billed` TINYTEXT NOT NULL, `tekst` TINYTEXT NOT NULL,INDEX (`id`));";
$result = mysql_query($sql_query)or die(mysql_error());
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<form action="partyimg2.php" method="POST" enctype="multipart/form-data">
Send disse filer:<br>
<input name="userfile[]" type="file" value="find"><br>
<input name="userfile[]" type="file" value="find"><br>
<input name="userfile[]" type="file" value="find"><br>
<input name="userfile[]" type="file" value="find"><br>
<input name="userfile[]" type="file" value="find"><br>
<input name="userfile[]" type="file" value="find"><br>
Upload flere? <select name="upl">
<option value="1">Ja</option>
<option value="0">Nej</option>
</select>
<input type="submit" value="Send files">
</form>
</body>
</html>
---------------side 1 slut--------------------------
og side 2
---------------side 2 start-------------------------
<?
session_start();
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<?
$path_to_file = '/var/www/abrisoa/images/';
$files = $HTTP_POST_FILES['files'];
if (!ereg("/$", $path_to_file))
$path_to_file = $path_to_file."/";
foreach($files['name'] as $key=>$name) {
if ($files['size'][$key]) {
// clean up file name
$name = ereg_replace("[^a-z0-9._]", "",
str_replace(" ", "_",
str_replace("%20", "_", strtolower($name)
)
)
);
$location = $path_to_file.$name;
while (file_exists($location))
$location .= ".copy";
copy($files['tmp_name'][$key],$location);
unlink($files['tmp_name'][$key]);
echo "\n<br>Successfully uploaded file: $name.";
}
}
include("connect.php");
$query_insert = "INSERT INTO `".$opret."` (`id`, `billed`, `tekst`) VALUES ('', '$location', 'bla')";
$query = mysql_query($query_insert)or die(mysql_error());
while($res = $query){
echo "Upload and insertion complete";
}
?>
<body>
<? if($upl == "1"){
echo "
<form action=\"partyimg2.php\" method=\"POST\" enctype=\"multipart/form-data\">
Send disse filer:<br>
<input name=\"userfile[]\" type=\"file\" value=\"find\"><br>
<input name=\"userfile[]>\" type=\"file\" value=\"find\"><br>
<input name=\"userfile[]\" type=\"file\" value=\"find\"><br>
<input name=\"userfile[]\" type=\"file\" value=\"find\"><br>
<input name=\"userfile[]\" type=\"file\" value=\"find\"><br>
<input name=\"userfile[]\" type=\"file\" value=\"find\"><br>
Upload flere? <select name=\"upl\">
<option value=\"1\">Ja</option>
<option value=\"0\">Nej</option>
</select>
<input type=\"submit\" value=\"Send files\">
</form>";
}else{
echo "du er nu færdig med at uploaded";
}
?>
</body>
</html>
------------------side 2 slut-------------------------
Den skal altså uploade 6 billeder også sætte den sti de får på hjemmesiden ind i en MySQL datase så de kan bruges ved et simpelt SQL udtræk, også de kan håndteres som flere fotoserier.
Problemet er at det ikke virker, hverken multiple upload eller database indsættelsen.
Kan en eller flere hjælpe mig ?
mvh. Lasse Storgaard
