$.ajaxFileUpload 已成功将文件上传到文件夹,但无法传递要保存在数据库中的值


$.ajaxFileUpload successfully uploads file to a folder but wasn't able to pass values to be saved in the database

我在提交表单时使用ajaxfileupload。这也是为了上传图像文件。图像已成功上传,但不包括要保存到数据库的其他数据?因为它使我的表字段留空,所以我认为这些值没有传递给category_save.php。我还观察到,当我使用 $.ajax({}) 而不是 $.ajaxFileUpload 时,数据都成功传递并保存在数据库中,包括图像文件名,但实际文件根本没有上传。但是当我使用 $.ajaxFileUpload 而不是 $.ajax({}) 时,它只是反向工作,文件已上传但值未保存在数据库中。这有什么问题?这是我的代码:

product_form.php

<form method="post" name="new_category" id="product_category" enctype="multipart/form-data"> 
 <ul class="add_prod">
 <li>Category Title:<input type="text" name="category[title]" id="cat_title" value="" placeholder="Title" /> </li>
 <li>Category Description:<textarea rows="4" cols="40" name="category[description]"></textarea></li>
 <li>Category Image:<input type="file" name="image_file" id="image_file" /></li>
 </ul>  
 </form>

产品1.js

$("#product_category").submit( function(){
  event.preventDefault();  
   var data_category = $(this).serialize();
   var image = $("#image_file").val();
$.ajaxFileUpload
    (
        {
            type:"post",
            url:"../wp-content/plugins/product_form/category_save.php",
            secureuri:false,
            fileElementId:'image_file',
            dataType: "json",
            data:data_category + "&image_file=" +image,                
            success: function (data)
            {
               if(data.notify == "Success"){
               console.log(data.notify);
              }
             else{
                return false;
              }
            }  
        }
    ); 
 });

产品2.js

$("#product_category").submit( function(){
  event.preventDefault();  
   var data_category = $(this).serialize();
   var image = $("#image_file").val();
     $.ajax({
       type: "post",
       url: "../wp-content/plugins/product_form/category_save.php",
       dataType: "json",
       data:data_category + "&image_file=" +image,
       success: function(data){
           if(data.notify == "Success"){
               console.log(data.notify);
           }
           else{
               console.log(data.notify);
           }
       } 
   });
});

category_save.php

<?php 
 //establish connection
 $con = mysqli_connect("localhost","root","","ion2_emagi"); 
 //on connection failure, throw an error
 if(!$con) {  
  die('Could not connect: '.mysql_error()); 
  } 
 $output_dir = "C:/Users/Employees/Dropbox/emagi/wp-content/plugins/product_form/img/";
 $file_name = "image_file"; 
 if(isset($_FILES[$file_name]))
  {
  //Filter the file types , if you want.
  if ($_FILES[$file_name]["error"] > 0)
  {
  echo "Error: " . $_FILES["file"]["error"] . "<br>";
  }
 else
 {  
    //move the uploaded file to uploads folder;
   move_uploaded_file($_FILES["image_file"]["tmp_name"],$output_dir.     $_FILES["image_file"]["name"]);
 }
}
//get the form elements and store them in variables
$category_values = $_POST["category"]; 
$image_url = basename($_POST["image_file"]);
$image_field = "image_url";
$data = array();
//unset($view_all_info['Password2']);
  foreach($category_values as $field => $val){
 $data[] = "`".$field."` = '".$val."'";
 }
 array_push($data,"`".$image_field."` = '".$image_url."'");
 $sql = "INSERT INTO wp_product_category SET ".implode(',', $data);
 $ret = mysqli_query($con,$sql); 
if($ret){
$notification="Success";
}
 else{
 $notification="Failed";
 }
echo json_encode(array('notify'=>$notification));
mysqli_close($con);

data字段应具有以下格式:

data: { data_category: data_category,  image_file: image_file }

您正在尝试将其作为带有参数的 URL 传递。

然后,您必须在PHP中检索它,并按参数名称POST。例如:

$category_values = $_POST["data_category"];