create server and connect to db and frontend code example

Example: create server and connect to db and frontend

// create directory

//npm init -y
//npm i express --save
//npm i mysql --save
//create public directory
//create server.js

// <---- In the server js file --->

'use strict';

const express = require('express');
const app = express();
app.use(express.static('public'));// to connect with frontend html
app.use(express.json());//body parse

const mysql = require('mysql');
// First you need to create a connection to the database
// Be sure to replace 'user' and 'password' with the correct values
const con = mysql.createConnection({
  host: 'localhost',
  user: 'user',
  password: 'password',
});

con.connect((err) => {
  if(err){
  	console.log(err.toString());
    return;
  }
  console.log('Connected mysql');
});

app.get('/', (req,res){
  	res.sendFile('index.html');
});

app.listen(3000);