insert json into mysql table in node js

Question

I've table users with following field

id,name(varchar) ,gallery(json)

gallery contains the the image path of user uploaded rows, a user can more images to his gallery and the image path of each image is stored in gallery as json

here is a sample row

id name gallery

1  blob ["test.jpg","test1.jpeg"]

Here is my code

function(req,res){
//image path after upload
var imagePath =uploadS3();

//SELECT gallery FROM user   and store to oldGallery
 var oldGallery = getCurrentGallery()
 var updatedGallery;
if(oldGallery==null){
    updatedGallery = "[\""+imagePath+"\"]"

}else{
    //concatinate the gallery row with new imagepath
      updatedGallery = JSON.parse(oldGallery).push(imagePath);
 }

   db.query("UPDATE users SET gallery=? ",[updatedGallery],function(error,result){
});
}

But the problem with JSON.parse(oldGallery).push(imagePath); it didn't worked console.log(JSON.parse(oldGallery).push(imagePath)) outputs 2 instead of the array.

madox2 · Accepted Answer · 2017-05-06 09:04:13Z

1

Array.prototype.push() returns length of the array after pushing (not the array itself). You can concatenate it to new array instead:

updatedGallery = JSON.parse(oldGallery).concat([imagePath]);

Furthermore, the type of updatedGallery in your if clause is a String and in the else clause it will be an Array. You should make it consistent and use either strings or arrays.

edited May 6, 2017 at 9:04

answered May 6, 2017 at 8:59

madox2

52.2k21 gold badges106 silver badges101 bronze badges

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

3 Comments

Jabaa Over a year ago

yeah it close to answer it outputs [ 'gallery-image-1494059004453.jpeg', 'gallery-image-1494061668890.jpeg' ] but i want replace the single quotes with double

madox2 Over a year ago

@Jabaa quotes in javascript objects are irrelevant. If it matters to you, convert it to string: JSON.stringify(JSON.parse(oldGallery).concat([imagePath]))

Jabaa Over a year ago

Now i will get the string as but i got error in mysql query

Collectives™ on Stack Overflow

insert json into mysql table in node js

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related