Insert BLOB data in mariaDB using Node.js

Question

I want to insert blob data in mariaDB using node js,I am using HeidiSQL to interact with mariaDB. 'users' table have two attributes 'user_email' and 'profile_photo'.

Similar Question

I found the following similar question but its not working in my case

NodeJS mySQL Insert Blob

Here is my code:

const inputfile = "C:\\Users\\Hammad Ali\\Desktop\\bloob\\routes\\CNN.jpg";
var email = "[email protected]",
   photo = readImageFile(inputfile); 


   var query = "INSERT INTO `users` SET ?",
   values = {
     user_email: email,
     profile_photo: photo
   };
   pool.query(query, values,  function(err, res) {
  if (err) throw err;
  console.log("BLOB data inserted!"+res);
});
});

function readImageFile(file) {
  // read binary data from a file:
  const bitmap = fs.readFileSync(file);
  const buf = new Buffer.from(bitmap);
  return buf;
}

Error

If you included more code, and formatted this cleaner, that would help. What is pool? — djs
– djs, Commented Mar 28, 2020 at 6:44

djs · Accepted Answer · 2020-03-28 06:59:45Z

1

Try this:

var query = "INSERT INTO `users` (user_email, profile_photo) VALUES (?, ?)",

values = [
  email,
  photo,
];

pool.query(query, values, function(err, res) {
  if (err) throw err;
  console.log("BLOB data inserted!"+res);
});

The examples in the MariaDB docs all use arrays, so I changed values to an array to match up with what I saw here and here.

answered Mar 28, 2020 at 6:59

djs

4,0753 gold badges18 silver badges28 bronze badges

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

5 Comments

Hammad Ali Over a year ago

Thank You its working,I post it below its show some square boxes.

Hammad Ali Over a year ago

can you please help me to retrieve this data from database,decode and send response as multipart to http request

djs Over a year ago

@HammadAli Glad to help! I'd be happy to help out with the DB retrieval and response cycle. See how far you can get, then ask another question when you get stuck and tag me in the comments and I'll have a look if no one else gets there first.

Hammad Ali Over a year ago

I need help in the following question.

Hammad Ali Over a year ago

stackoverflow.com/questions/60906248/…

Collectives™ on Stack Overflow

Insert BLOB data in mariaDB using Node.js

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related