php - 文件上传并保存

Question

再次回来

所以我稍微移动了代码，现在只收到不成功的消息。请告诉我哪里做错了，哪里做错了。

editemployee.php 页面上的我的表单

<h1>Warnings</h1>
<div class="article" style="width:535px">
 <form enctype="multipart/form-data" action="includes/add.php" method="POST"> 
 <table>
  <tr>
  <td>Warning letter:</td>
  <td> <input type="file" name="warning1"></td>
  </tr>
   <tr>
  <td>Warning letter:</td>
  <td><input type="file" name="warning2"></td>
  </tr>
   <tr>
  <td>Warning letter Final:</td>
  <td><input type="file" name="warning3"></td>
  </tr>
   <tr>
  <td></td>
  <td><input type="submit" value="Add"> </td>
  </tr>
  </table>

 </form>

 </div>

现在我已按照建议将处理代码移至其自己的名为 add.php 的文件

<?php 
  //This is the directory where images will be saved 
$target = "files/empdocs"; 
$target1 = $target . basename( $_FILES['warning1']['name']); 
$target2 = $target . basename( $_FILES['warning2']['name']);
$target3 = $target . basename( $_FILES['warning3']['name']);

 //This gets all the other information from the form 

 $warning1=($_FILES['warning1']['name']); 
 $warning2=($_FILES['warning2']['name']);
 $warning3=($_FILES['warning3']['name']); 

 // Connects to your Database 
 mysql_connect("localhost", "username", "password") or die(mysql_error()) ; 
 mysql_select_db("database") or die(mysql_error()) ; 

  //Writes the information to the database 
 mysql_query("INSERT INTO ref_employees VALUES ('$warning1', '$warning2', '$warning3')") ;
  //Writes the file to the server 
if (move_uploaded_file($_FILES['warning1']['tmp_name'], $target1)
&& move_uploaded_file($_FILES['warning2']['tmp_name'], $target2)
&& move_uploaded_file($_FILES['warning3']['tmp_name'], $target3)) {

 //Tells you if its all ok 
 echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
 } 
 else { 

 //Gives and error if its not 
 echo "Sorry, there was a problem uploading your file."; 
 } 
 ?>

Answer 1

你有:

mysql_query("INSERT INTO ref_employees VALUES ('$warning1', '$warning2', '$warningfinal') WHERE 'idnumber' = $idnumber") ; 

WHERE 不应出现在 INSERT 语句中!