NodeJS SQL Insert Query isn't working, why?

[G1K777]

Hello,

i want to create a login system.

My code isn't adding anything into the Table, it also doesn't throw any errors.

try{
  conn = await conn_sql.getConnection();
  await conn.query(`INSERNT INTO user (username,password) VALUES ('${data.username}','${data.password}')`);
}catch(err){
  throw err;
}finally{
  if(conn) return conn.end();
}

 

[keskparane]

how do you spell INSERT?

[reniat]

I know you're just getting started with a login, and I 100% approve of starting with the bare minimum and working your way up, but I do want to just point out that if you are just storing passwords in the database in plaintext like that, you are not making a secure login. That may not matter at all to you, which is fine, just figured i'd point it out in case this grows into something where security might have an impact.

[vorticalbox]

7 hours ago, reniat said:

I know you're just getting started with a login, and I 100% approve of starting with the bare minimum and working your way up, but I do want to just point out that if you are just storing passwords in the database in plaintext like that, you are not making a secure login. That may not matter at all to you, which is fine, just figured i'd point it out in case this grows into something where security might have an impact.

This assumes that this data.password isn't hashed before being put into this function.

 

8 hours ago, G1K777 said:

Hello,

i want to create a login system.

My code isn't adding anything into the Table, it also doesn't throw any errors.

try{
  conn = await conn_sql.getConnection();
  await conn.query(`INSERNT INTO user (username,password) VALUES ('${data.username}','${data.password}')`);
}catch(err){
  throw err;
}finally{
  if(conn) return conn.end();
}

 

other then the spelling on INSERT you should check the module you are using actually returns a promise you can await on.
 

[G1K777]

10 hours ago, keskparane said:

how do you spell INSERT?

Thank you, you know how it is.. when you code from 7pm till 7am and start making simple mistakes that you don't see.

[reniat]

2 hours ago, G1K777 said:

when you code from 7pm till 7am and start making simple mistakes that you don't see.

This is why overworking engineers doesn't lead to good code. Sleep is good for code quality  

[keskparane]

2 hours ago, G1K777 said:

Thank you, you know how it is.. when you code from 7pm till 7am and start making simple mistakes that you don't see.

amen

[G1K777]

How can i prevent all forms from default submission? I want to use AJAX on all forms.
I was trying and trying things but Javascript doesn't look like they like to make coding easier...

Why i can't just do the following? (doesn't work, it still submits the form.)

let form = document.getElementsByTagName("form");
form.addEventListener("submit", function(event){
	event.preventDefault()
});