Hjælp.. hvorfor virker det ikke?
når jeg forsøger at opdatere et produkt vil den ikke håntere filerne... altså alle $_FILES['noget']['tmp_name'] og $_FILES['noget']['name'] er tomme ??include 'inc.logincheck.php';
$query = "SELECT `id`, `date`, `name`, `uk_s_info`, `dk_s_info`, `uk_de_side`, `dk_de_side`, `s_pic`, `pic1`, `pic2`, `pic3`, `pic4` FROM `product` ORDER BY name ASC";
$results = mysql_query($query) or doCrash("Can't do SQL query - ".mysql_error());
echo"<form action=\"\" method=\"post\" onchange=\"this.product.value=this.productselect.value\">
<input type=\"hidden\" name=\"product\" value=\"\">
<select style=\"width:300px;\" name=\"productselect\">
<option value=\"##NONESELECTED##\" >Please make a selection</option>";
while ($db = mysql_fetch_assoc($results))
{
echo"<option value=\"".$db['name']."\" >".$db['name']." ".$db['date']."</option>";
}
echo"</select>
<input type=\"submit\" value=\"Select\" name=\"selectproduct\" style=\"width: 300px\"><br><br>";
if (isset($_POST['Resave'])){
$productid = $_POST['productid'];
$query3 = "SELECT `id`, `date`, `name`, `uk_s_info`, `dk_s_info`, `uk_de_side`, `dk_de_side`, `s_pic`, `pic1`, `pic2`, `pic3`, `pic4` FROM `product` WHERE `id`='".$productid."'";
$results3 = mysql_query($query3) or doCrash("Can't do SQL query - ".mysql_error());
$db3 = mysql_fetch_assoc($results3);
$olddir = $db3['name'];
$old_file['DKhtml'] = $db3['dk_de_side'];
$old_file['UKhtml'] = $db3['uk_de_side'];
$old_file['pic0'] = $db3['s_pic'];
$old_file['pic1'] = $db3['pic1'];
$old_file['pic2'] = $db3['pic2'];
$old_file['pic3'] = $db3['pic3'];
$old_file['pic4'] = $db3['pic4'];
$newdir = $_POST['name'];
echo "The product \"$newdir\" has been Updated to the side!<br>";
$from_file['DKhtml'] = $_FILES['dk_de_side']['tmp_name'];
$too_file['DKhtml'] = $newdir."/dk".$_FILES['dk_de_side']['name'];
$chk_file['DKhtml'] = $_FILES['dk_de_side']['name'];
$from_file['UKhtml'] = $_FILES['uk_de_side']['tmp_name'];
$too_file['UKhtml'] = $newdir."/uk".$_FILES['uk_de_side']['name'];
$chk_file['UKhtml'] = $_FILES['uk_de_side']['name'];
$from_file['pic0'] = $_FILES['pic0']['tmp_name'];
$too_file['pic0'] = $newdir."/".$_FILES['pic0']['name'];
$chk_file['pic0'] = $_FILES['pic0']['name'];
$from_file['pic1'] = $_FILES['pic1']['tmp_name'];
$too_file['pic1'] = $newdir."/".$_FILES['pic1']['name'];
$chk_file['pic1'] = $_FILES['pic1']['name'];
$from_file['pic2'] = $_FILES['pic2']['tmp_name'];
$too_file['pic2'] = $newdir."/".$_FILES['pic2']['name'];
$chk_file['pic2'] = $_FILES['pic2']['name'];
$from_file['pic3'] = $_FILES['pic3']['tmp_name'];
$too_file['pic3'] = $newdir."/".$_FILES['pic3']['name'];
$chk_file['pic3'] = $_FILES['pic3']['name'];
$from_file['pic4'] = $_FILES['pic4']['tmp_name'];
$too_file['pic4'] = $newdir."/".$_FILES['pic4']['name'];
$chk_file['pic4'] = $_FILES['pic4']['name'];
// connection to FTP server...
$result = ftp_login($connection, $ftp_user, $ftp_pass);
// check if connection was made
$query = "UPDATE `product` SET `date` = now(), `name` = '".$_POST['name']."', `uk_s_info` = '".$_POST['uk_s_info']."', `dk_s_info` = '".$_POST['dk_s_info']."', `uk_de_side` = '".$_FILES['uk_de_side']['name']."', `dk_de_side` = '".$_FILES['dk_de_side']['name']."', `s_pic` = '".$_FILES['pic0']['name']."', `pic1` = '".$_FILES['pic1']['name']."', `pic2` = '".$_FILES['pic2']['name']."', `pic3` = '".$_FILES['pic3']['name']."', `pic4` = '".$_FILES['pic4']['name']."' WHERE `id` = '".$productid."'";
echo "<br><table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
if (mysql_query($query))
{echo "<tr><td><li> Update to database... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> Update to database... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
if ($olddir != $newdir){
if (ftp_rename($connection, $olddir, $newdir)) // create directory
{echo "<tr><td><li> Update dir ...</td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> Update dir ... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
}
if (ftp_delete($connection, $old_file['DKhtml']))
{echo "<tr><td><li> DK-HTML file Delete... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> DK-HTML file Delete... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
if (ftp_put($connection, $too_file['DKhtml'], $from_file['DKhtml'], FTP_BINARY))
{echo "<tr><td><li> DK-HTML file Copy... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> DK-HTML file Copy... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
if ($from_file['UKhtml'] != ""){
if (ftp_delete($connection, $too_file['UKhtml']))
{echo "<tr><td><li> UK-HTML file Delete... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> UK-HTML file Delete... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
if (ftp_put($connection, $too_file['UKhtml'], $from_file['UKhtml'], FTP_BINARY))
{echo "<tr><td><li> UK-HTML file Copy... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> UK-HTML file Copy... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
}
if ($from_file['pic0'] != ""){
if (ftp_delete($connection, $too_file['pic0']))
{echo "<tr><td><li> PIC0 file Delete... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> PIC0 file Delete... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
if (ftp_put($connection, $too_file['pic0'], $from_file['pic0'], FTP_BINARY))
{echo "<tr><td><li> PIC0 file Copy... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> PIC0 file Copy... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
}
if ($from_file['pic1'] != ""){
if (ftp_delete($connection, $too_file['pic1']))
{echo "<tr><td><li> PIC1 file Delete... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> PIC1 file Delete... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
if (ftp_put($connection, $too_file['pic1'], $from_file['pic1'], FTP_BINARY))
{echo "<tr><td><li> PIC1 file Copy... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> PIC1 file Copy... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
}
if ($from_file['pic2'] != ""){
if (ftp_delete($connection, $too_file['pic2']))
{echo "<tr><td><li> PIC2 file Delete... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> PIC2 file Delete... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
if (ftp_put($connection, $too_file['pic2'], $from_file['pic2'], FTP_BINARY))
{echo "<tr><td><li> PIC2 file Copy... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> PIC2 file Copy... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
}
if ($from_file['pic3'] != ""){
if (ftp_delete($connection, $too_file['pic3']))
{echo "<tr><td><li> PIC3 file Delete... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> PIC3 file Delete... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
if (ftp_put($connection, $too_file['pic3'], $from_file['pic3'], FTP_BINARY))
{echo "<tr><td><li> PIC3 file Copy... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> PIC3 file Copy... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
}
if ($from_file['pic4'] != ""){
if (ftp_delete($connection, $too_file['pic4']))
{echo "<tr><td><li> PIC4 file Delete... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> PIC4 file Delete... </td><td width=\"10\"></td><td>Failed!</td></tr>";}
if (ftp_put($connection, $too_file['pic4'], $from_file['pic4'], FTP_BINARY))
{echo "<tr><td><li> PIC4 file Copy... </td><td width=\"10\"></td><td>OK!</td></tr>";
}
else {echo "<tr><td><li> PIC4 file Copy... </td><td width=\"10\"></td><td>Failed!</td></tr>"; echo $chk_file['pic4'];}
}
echo "</table>";
ftp_close($connection);
}
else {}
if (($_POST['product'] == "") or ($_POST['product'] == "##NONESELECTED##"))
{
echo "<font face=\"Courier New, Courier, mono\">--> NO PRODUCT HAS BEEN SELECTED!! <--</font>";
}
else {
$query2 = "SELECT `id`, `date`, `name`, `uk_s_info`, `dk_s_info`, `uk_de_side`, `dk_de_side`, `s_pic`, `pic1`, `pic2`, `pic3`, `pic4` FROM `product` WHERE `name`='".$_POST['product']."'";
$results2 = mysql_query($query2) or doCrash("Can't do SQL query - ".mysql_error());
$db2 = mysql_fetch_assoc($results2);
echo"
<form action=\"".$_SERVER["PHP_SELF"]."\" method=\"post\" enctype=\"multipart/form-data\">
<input type=\"text\" name=\"productid\" value=\"".$db2['id']."\">
Navn:<br><input value=\"".$db2['name']."\" type=\"text\" name=\"name\" style=\"width: 300px\"><br><br>
<h3> Dansk Model:</h3>
Kort info (HTML):<Br><textarea name=\"dk_s_info\" style=\"width: 300px; height:150px;\">".$db2['dk_s_info']."</textarea><br><br>
Siden m. detalier:<br><input type=\"file\" name=\"dk_de_side\" style=\"width: 300px\"> \"".$db2['dk_de_side']."\"<br><br>
<h3>Engelsk Model:</h3>
Kort info (HTML):<Br><textarea name=\"uk_s_info\" style=\"width: 300px; height:150px;\">".$db2['uk_s_info']."</textarea><br><br>
Siden m. detalier:<br><input type=\"file\" name=\"uk_de_side\" style=\"width: 300px\"> \"".$db2['uk_de_side']."\"<br><br>
<h3>Billeder mm.:</h3>
Billede til kort info:<br><INPUT NAME=\"pic0\" TYPE=\"file\" style=\"width:300px; \"> \"".$db2['s_pic']."\"<br><br>
Yderliger billeder:<br>
<INPUT NAME=\"pic1\" TYPE=\"file\" style=\"width:300px;\"> \"".$db2['pic1']."\"
<INPUT NAME=\"pic2\" TYPE=\"file\" style=\"width:300px;\"> \"".$db2['pic2']."\"
<INPUT NAME=\"pic3\" TYPE=\"file\" style=\"width:300px;\"> \"".$db2['pic3']."\"
<INPUT NAME=\"pic4\" TYPE=\"file\" style=\"width:300px;\"> \"".$db2['pic4']."\"
<br><br><input type=\"submit\" value=\"Resave\" name=\"Resave\" style=\"width: 300px\">
</form><br>";
}
?>
