Just a quick note - I'm a total newbie in the world of web development, so I might be missing an obvious solution here.
My challenge is to insert a dataset into a MySQL database using nodejs/expressjs/mysql.
I've managed to establish a connection to the database and can query data from it with no problems.
This is the code snippet I'm working with:
app.post('/pyme', function(req,res){
console.log("Data being POSTED to db...");
var post = req.body;
console.log(post);
var sql_insert_pyme = 'INSERT INTO pyme(NombreComercio,NumeroTelefono) VALUES =?';
sql.query(sql_insert_pyme,post,function(err){
if(err) throw err;
});
});
The data I receive through POST request looks like this:
{ NombreComercio: 'Sebastian Avila',
NumeroTelefono: '71021714' }
I am looking for a way to simplify the post data into something like:
"'Sebastian Avila', '71021714'"
In other words, my goal is to transform the post data into:
post = "'Sebastian Avila', '71021714'"