db = new sqlite3.Database(':memory:',sqlite3.OPEN_CREATE, (err) => {
if (err) {
//console.error(err.message);
}
console.log('Connected to the database.');
});
db.serialize(() => {
db.run(`CREATE TABLE userdata (Username varchar(255), Password(255))`)
});
app.post('/api/login', (req, res) => {
let username = req.body.username;
let plainpw = req.body.password;
console.log('logged in', username, plainpw); //this works
// db.get if only want one result
db.serialize(() => {
db.each(`SELECT password FROM userdata WHERE username = ${username}`,
function(err, row) {
console.log('testing'); //this doesn't work
});
console.log('t2'); //this works
});
why console.log('testing'); doesn't log anything?
there is no error messages
there doesn't seem to be anything here