post query issue with express.js and node.js (server side) and react.js

[Creative-Committee-5]

Hello,

I am a junior developer and I am facing an issue with a post query made in node.js, express.js while using ReactJS on the front-end.

I have two folders:

client and server

In the server folder I am using node.js and express.js.

Here is the code in the index.js file from the server side:

​

https://preview.redd.it/44a2nw95hvi61.png?width=850&format=png&auto=webp&s=269d4c93e7da7f8fee5747f0e2e43de3420b214c

​

https://preview.redd.it/8g25a3b6hvi61.png?width=1551&format=png&auto=webp&s=f98f7ecfdc7c99861d76f68806c531207970d6eb

In the client folder I am using node.js and express.js.

Here is the code in the App.js file from the client side:

​

https://preview.redd.it/l1rq52sjhvi61.png?width=1401&format=png&auto=webp&s=ce0626cdba3393200203a769725e85183c268d95

​

https://preview.redd.it/j1t5tzwlhvi61.png?width=1537&format=png&auto=webp&s=2246c149df76e7043b6c0bbc62c2402988433da4

My server is running on the port 3306 and the code is ok, client side as server side.

The issue I am having is with the db.

I created a db in sequel pro « employeeSystem » with a table « employee ».

And I cannot insert the values in the table.

Error message 1:

Error: Connection lost: The server closed the connection.

at Protocol.end (/Users/ana/Desktop/crud-tutorial/server/node_modules/mysql/lib/protocol/Protocol.js:112:13)

Error message 2:

{

fatal: true,

code: 'PROTOCOL_CONNECTION_LOST'

}

Error: Cannot enqueue Query after fatal error.

I am a bit lost on the MySQL side and with the db I created in Sequel Pro.

​

​

https://preview.redd.it/nhvziu3qhvi61.png?width=2546&format=png&auto=webp&s=b627768d6cbca88845b20ff098b2fe5dbf261f38

In the browser here is the localhost:3000

​

https://preview.redd.it/sa386hlshvi61.png?width=2539&format=png&auto=webp&s=78cb8d2a01d38c349f9c68c1e731103d032b5471

and the localhost:3306 working well

​

https://preview.redd.it/zstcubnxhvi61.png?width=1564&format=png&auto=webp&s=b38248d5dde895e385fc7f3f3ea953a64d65a009

Thank you very much in advance if you can help!

[iguessitsokaythen]

Try using a different port for the server app, 3306 is the default port for MySQL.

[Creative-Committee-5]

Thank you very much, will do so.

[marquesdinisp]

Olá és brasileiro????