How to save data from html form to a database using javascript

I am trying to save data from an html form into a mysql database. Obviously I am new to this so I know I am doing something wrong but after doing a lot of research I still can't figure it out. I created a simple version of my form for testing purposes.

My javascript code is:

function saveAccount(){
var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "abc123",
  database: "PBSC_Parking_DB"
});

con.connect(function(err) {
  if (err) throw err;
console.log("connected");
});

var firstName = document.getElementById("firstName");
var lastName = document.getElementById("lastName");
var psw = document.getElementById("psw");
var userName = document.getElementById("userName");
var email = document.getElementById("inputText");



var sql = "INSERT INTO accounts (UserName, FirstName, LastName, Email, UserPassword) VALUES ('"+userName+ "', '"+firstName+"','"+lastName+"','"+email+"','"+psw+"')";
con.query(sql, function (err, result) {
    if (err) {
        throw err;

    }

    console.log(result.affectedRows + " record(s) updated");
  });
}

I've read that you're suppose connect to the database outside of a function but moving it outside the function does not seem to solve my problem. I've also been told that I shouldn't be using 'document.' but I'm not sure how else to pull the data from the form to be used in my sql statement.

I tried hard coding values into an INSERT statement, not using a function and just running the js file through the command prompt. This works to update my database so I know I'm doing the connection correctly... I just don't know how to make it work with the form.

note: I also tried looking up tutorials using nodejs and ejs but after following the tutorials carefully I still couldn't get them to work.

I am sharing a simple example here today that explains how easily you can save your form data in a text file or in a .txt file using JavaScript.

A web form usually has many different elements, mostly input fields. You can extract data from these elements and save it in a database like SQL Server, or simply convert it into a JSON file. You can even save your form data in a text file.

Let’s see the example first.

    
    


    

        

        

            
        
        

            
        
        

            
        
        

             id="selCountry">
                -- Choose the country --
                India
                Japan
                USA
            
        
        

             id="msg" name="msg" placeholder="Write some message ..." style="height:100px">
        

        
        

            onclick="saveFile()" />
        
    

Try it

Please do not get overwhelmed by the size of the program. The code inside the