Avatar billede zorkmontana Nybegynder
17. oktober 2004 - 04:35 Der er 5 kommentarer og
1 løsning

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>";
}

?>
Avatar billede olebole Juniormester
17. oktober 2004 - 05:32 #1
<ole>

Har du checket, de er tomme? Prøv at skrive:
  echo "The product \"$newdir\" has been Updated to the side!<br>";
  echo "<xmp>";
  var_dump($_FILES);
  echo "</xmp>\n";

/mvh
</bole>
Avatar billede erikjacobsen Ekspert
17. oktober 2004 - 08:53 #2
Du skal enten have een <form> ... </form> eller 2 - dvs huske at
afslutte den første <form> med </form>.

Når der er noget, der ikke virker, så tag et smut forbi
    http://validator.w3.org/
Den kan spare dig for en masse bøvl.
Avatar billede olebole Juniormester
17. oktober 2004 - 19:59 #3
Uaaakkk .... det havde jeg ikke set!  =8-O
Ja, du skal naturligvis afslutte dine forms. 'Nestede' forms er et ikke eksisterende begreb i HTML - og vil altid udløse fejl af forskellig slags  ;o)
Avatar billede zorkmontana Nybegynder
27. oktober 2004 - 08:49 #4
sorry ... skulle lige have tjekket op på det hele... men jeps jeg havde glemt af afslutte min form takker..!
du skulle nok have nogle point erikjacobsen
Avatar billede erikjacobsen Ekspert
27. oktober 2004 - 10:56 #5
I princippet ja, men jeg samler slet ikke på point.
Avatar billede zorkmontana Nybegynder
29. oktober 2004 - 19:02 #6
oki det er iorden...
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester