/Javascript/React/Connect react with database server

Connect react with database server

const express = require('express');
const bodyParser = require('body-parser');
var connection  = require('express-myconnection'); 
var mysql = require('mysql');

const app = express(); 
app.use(bodyParser.json());

app.use(

        connection(mysql,{

            host: 'localhost', //'localhost',
            user: 'userEHX',
            password : 'hMmx56FN4GHpMXOl',
            port : 3306, //port mysql
            database:'sampledb'

        },'pool')); //or single

       app.post('/add_book',(req,res)=>{

        let {book_name,author,} = req.body;


        if(!book_name) return res.status(400).json('Book Name cant be blank');
        if(!author) return res.status(400).json('Author cant be blank');

        var data={book_name:book_name,
                  author:author};


         var query = connection.query("INSERT INTO books set ? ",data, 
        function(err, rows)
        {

          if (err){
            //If error
              res.status(400).json('Sorry!!Unable To Add'));
              console.log("Error inserting : %s ",err );
             }
         else
          //If success
          res.status(200).json('Book Added Successfully!!')

        });


        });


         app.listen(3000, ()=> {
      console.log(`app is running on port 3000`);
});

Source: stackoverflow.com

Similar codes

0 vote206 views2 answers
Which one is better arrow functions or using bind in react?
Javascript React
0 vote228 views1 answer
React check if array contains value
Javascript React
1 vote249 views2 answers
Npm youtube-react
Javascript React
17 votes210 views5 answers
How to run react native app
Javascript React
0 vote206 views1 answer
React Hook useEffect has missing dependencies: 'cart' and 'user._id'. Either include them or remove the dependency array react-hooks/exhaustive-deps
Javascript React
1 vote265 views1 answer
How to set limit in map in react hook
Javascript React
0 vote212 views1 answer
Error code ELIFECYCLE REACTJs
Javascript React
0 vote201 views1 answer
Filter-vs-map-reactjs-and-jsx
Javascript React
0 vote218 views1 answer
Npm react-dom
Javascript React
0 vote206 views1 answer
Refresh page by hand in react
Javascript React