php - 使用 jquery ajax 模式表单上传文件并保存文件名失败

Question

我尝试上传文件然后将文件名保存到mysql，方法与upload & save file to mysql相同。但我的问题还是出现了。错误消息是上传的文件未定义。

HTML:

<form id="flowlist">
   <div class="form-group">
     <label for="idcar" class="control-label">ID CAR</label>
     <input type="text" name="idcar" id="idcar" class="text_field form-control" required>
  </div>
   <div class="form-group">
      <label for="upload">Upload Minute Of Meeting</label>
      <input type="hidden" name="MAX_FILE_SIZE" value="20000000">
      <input id="upload" name="uploadedfile" type="file">
      <input type="hidden" id="filenm" name="filenm" required>
      <input type="hidden" name="action" value="updateflow">
   </div>
</form>

JS 脚本(cms.js):

dialog = $( "#flow" ).dialog({
         buttons: {
            "Update Data":function() {
                  var params=$('#flowlist').serialize();
                  $.ajax({
                     type:"post",
                     url:"doserver.php",
                     data:params,
                     cache :false,
                     async :false,
                     success : function() {
                        $('input').val("");
                        $('textarea').val("");
                        table.row('.selected').draw(false);
                        location.reload();
                        return this;
                     },
                     error : function() {
                        alert("Data failed to input.");
                     }

PHP 代码(doserver.php):

case 'updateflow':
   /* catch variable parameter */
   $idcar = mysqli_real_escape_string($dbc,$_POST['idcar']);
   $file= mysqli_real_escape_string($dbc,$_POST['filenm']);

   $target_path = "mom/";
   $target_path = $target_path . basename( $_FILES['uploadedfile']['name']);
   if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) 
   {
      echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded";
      /* UPDATE */
      $sql ="UPDATE monitor SET Mom = '".$file."'";
      $sql.=" WHERE id_car LIKE '".$idcar."'";
      $res =mysqli_query($dbc,$sql) or die(_ERROR30.":".mysqli_error($dbc));
   }
      else { echo "There was an error uploading the file, please try again!"; }
break;

<小时/>

编辑

添加 enctype="multipart/form-data"

<form id="flowlist" enctype="multipart/form-data">
</form>

然后对ajax函数进行一些更改:

"Update Data":function() {
   var formData = new FormData(this);
   $.ajax({
      type:"post",
      url:"doserver.php",
      processData:false,
      contentType:false,
      data:formData,
   ....
});

我没有错误，但 idcar 未更新且文件未上传。

Answer 1

如果您使用 jquery 更好，请使用 $('#flowlist')[0] 而不是 this。我已经使用以下方法解决了这个问题:

"Update Data":function() {
   if(window.FormData !== undefined)
   {
      var formData = new FormData($('#flowlist')[0]);
      $.ajax({
         type:"post",
         url:"doserver.php",
         processData:false,
         contentType:false,
         mimeType:"multipart/form-data",
         data:formData,
         ...
      });
   }
}