PHP: Unable to insert a doc file into mysql database

Question

I am troubling to insert doc file into db with other data.

here is my all code: jQuery: new_req.php

passdata = "<passdata><fdata>" +
                "<jobtitle>" + jobtitle + "</jobtitle>" +
                "<action>" + "add_new_req" + "</action>" +
            "</fdata></passdata>";


$.ajax({
            type:"POST",
            url:"model_req.php",
            data:"data=" + encodeURIComponent(passdata),
            success: function(data,textStatus,jqXHR){
            if(data.indexOf("ERROR")>=0){
                 alert(data);
            }
            },
            error: function(jqXHR,textStatus,errorThrown){
            alert("some error occured->" + jqXHR.responseJSON);
            }
            })

HTML:

<form name="inputform" id="inputform" class="form-horizontal col-md-12" method="post"
style="height: 550px; width: 900px" enctype="multipart/form-data">

 <label class="control-label col-sm-2" for="pwd">Attachment</label>
 <input type="hidden" name="MAX_FILE_SIZE" value="2000000">
 <div class="col-sm-3">
   <input name="userfile" type="file" id="userfile" >
 </div>

both html and Jquery code on same page i.e new_req.php

model_req.php file:

$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

Here I got userfile undefined, I tried

if(isset[$_FILES['userfile']['name']])

but still got error.

what to do? How I manage to insert a data with file attachment at same time? Help?

usualy you don't save the file in the db but the location of that file on your server hdd , but if you want to save it to the db consider using a blob type field — madalinivascu, Mar 29 '17 at 09:05
yeah, I used medium blob as datatype, but I got different error. — Mangesh Kolape, Mar 29 '17 at 09:06
You're never sending down the `$_FILE['userfile']` in the AJAX request, only the text content of `passdata`... Since you don't have an `action` attribute defined on your `
`, it'll automatically be submitted to `new_req.php`. — BenM, Mar 29 '17 at 09:06
ajax is for passing other data(name, education, jobtitle etc) to model_req.php file and depend on action tag I perform the operation — Mangesh Kolape, Mar 29 '17 at 09:22

PHP: Unable to insert a doc file into mysql database

0 Answers0