File upload to DB using Ajax and PHP

Question

Im looking for help here. Cant figure it out where is problem here. Im trying to make multiple file upload to database using Ajax and PHP. I am getting this error:

Warning: file_get_contents(iamge.png): failed to open stream: No such
file or directory in /var/www/html/includes/forms/addProductSteps/BTR/upload.php on line 12

Can you please check code below:

index.php:

<form id="fourthStepForm" class="" action="" method="post" enctype="multipart/form-data">
  <input type="file" multiple id="imagesToUpload" name="files[]" value="">
  <div class="col-xs-3 col-md-3"><input type="submit"  onclick="fourthStep();return false" name="submit" value="Finalize" class="btn btn-primary btn-block btn-md" tabindex="5"></div>
</form>

function fourthStep(){

var formData = new FormData();
var ins = document.getElementById('imagesToUpload').files.length;
for (var x = 0; x < ins; x++) {
    formData.append("files[]", 
    document.getElementById('imagesToUpload').files[x]);
}

$.ajax({
    url: 'includes/forms/addProductSteps/BTR/upload.php',
    dataType: 'text',
    cache: false,
    contentType: false,
    processData: false,
    data: formData,
    type: 'post',
    success: function (response) {
        alert(response);
    },
    error: function (response) {
        alert(response);
    }
});
}

upload.php:

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include_once'../../../connections_multi.php';
$p_id = 1001; //for testing purpose

$no_files = count($_FILES["files"]['name']);
for ($i = 0; $i < $no_files; $i++) {
   if ($_FILES["files"]["error"][$i] > 0) {
      echo "Error: " . $_FILES["files"]["error"][$i] . "<br>";
   } else {
    $file = addslashes(file_get_contents($_FILES["files"]["name"][$i]));
    if (!($stmt = $db->prepare("INSERT INTO products.battery_lobs ( p_id,img) VALUES (?,?)"))) {
      $response = $stmt->error;
    }
    if (!$stmt->bind_param("sb", $p_id, $file )) {
      $response = $stmt->error;
    }
    if (!$stmt->execute()) {
      $response = $stmt->error;
    }else{
      $response = "true";
    }
  }
}

echo $response;

and $response i get here is "true". So data is inserted but BLOB is 0 bytes. No image.

Thanks!

xayer · Accepted Answer · 2018-05-21 17:58:35Z

1

Problem is in your upload.php file.

This line:

$file = addslashes(file_get_contents($_FILES["files"]["name"][$i]));

You need change it like this:

$file = addslashes(file_get_contents($_FILES["files"]["tmp_name"][$i]));

Then you upload file, file is saved in temporary directory and using random name, you can get it used $_FILES["files"]["tmp_name"].

answered May 21, 2018 at 17:58

xayer

4794 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Edgars Šusts Over a year ago

Thanks, error went away but looks like BLOB is still 0 bytes, no image.

xayer Over a year ago

After this: if (!$stmt->bind_param("sb", $p_id, $file )) {$response = $stmt->error;} you need add this: if (!$stmt->send_long_data(1, $file)){$response = $stmt->error;} and it should work great ;-)

xayer Over a year ago

Then try restore image from text don't forget stripslashes(); ;-)

Edgars Šusts Over a year ago

what mean that number 1 in send_long_data(1, $file). i see others put 0 or 2.

xayer Over a year ago

bool mysqli_stmt::send_long_data ( int $param_nr , string $data ). So: $p_id = 0, $file = 1, $something = 2 and ...

Collectives™ on Stack Overflow

File upload to DB using Ajax and PHP

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related