I am new to programming and have tried to create a post that allows me to send data from an ancount form to a table (mysql database). The console.log (on the node node console displays an error) and I can not understand why the post is not working.
I get the error message saying that handshake can not be queued even though a handshake has already been queued. I googled, but I did not find a way to get the post started or fix it.
I appreciate any help.
const express = require (& # 39; express & # 39;);
const mysql = required (& # 39; mysql & # 39;);
// connect
const db = mysql.createConnection ({
host: & # 39; localhost & # 39 ;,
User: & # 39; root & # 39 ;,
Password: & # 39 ;,
Database: & # 39; nodemysql & # 39;
});
// Connect
db.connect ((err) => {
if (err) {
Throwing mistakes;
}
console.log (& # 39; MySql Connected ... & # 39;);
});
const app = express ();
app.get (& # 39; / & # 39 ;, function (req, res) {// nome da minha URL req (é ve que / / / / response response response response response)
res.sendFile (path.join (__ dirname + & # 39; / public / index.html & # 39;));
})
app.get (& # 39; / log_in & # 39 ;, function (req, res) {// Nome da Minha URL
res.sendFile (path.join (__ dirname + & # 39; / public / signin.html & # 39;));
})
app.get (& # 39; / register & # 39 ;, function (req, res) {// Nome da Minha URL
res.sendFile (path.join (__ dirname + # / public / register.html & # 39;));
})
// create DB
app.get (& # 39; / createdb & # 39 ;, (req, res) => {
let sql = & # 39; CREATE DATABASE IF NOT EXISTS nodemysql & # 39;
db.query (sql, (err, result)) => {
if (err) throw errors;
console.log (result);
res.send (& # 39; database created ... & # 39;);
});
});
// create table
app.get (& # 39; / createusertable & # 39 ;, (req, res) => {
let sql = # CREATE TABLE user (id int AUTO_INCREMENT, name VARCHAR (50), last name VARCHAR (50), email VARCHAR (100), password VARCHAR (100), telephone VARCHAR (50), country VARCHAR (100), VAT number VARCHAR (9), address VARCHAR (150), PRIMARY KEY (id)) & # 39 ;;
db.query (sql, (err, result)) => {
if (err) throw errors;
console.log (result);
res.send (& # 39; created table created ... & # 39;);
});
});
db.connect (function (err) {
if (err) return console.log (err);
console.log (& # 39; conectou! & # 39;);
createTable (connection);
})
app.listen (& # 39; 3000 & # 39 ;, () => {
console.log (& # 39; server started at port 3000 & # 39;);
});
app.use (express.static (& # 39; public & # 39;))
const bodyParser = required ("body parser");
app.use (bodyParser.urlencoded ({
extended: true
}));
app.use (bodyParser.json ());
app.post (& # 39; / register & # 39 ;, function (req, res) {
console.log (req.body.user.name);
let post = {name: req.body.user.name, last name: req.body.user.lastName,
Email: req.body.user.email, Password: req.body.user.password, Phone: req.body.user.phone,
country: req.body.user.country, VAT No .: req.body.user.nif, address: req.body.user.address};
let sql = & # 39; INSERT INTO user SET? & # 39 ;;
Let query = db.query (sql, post, (err, result)) => {
if (err) throw errors;
res.redirect (303, & # 39; / & # 39;);
});
});
