/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

1 vote384 views1 answer
Create functional component react
Javascript React
0 vote389 views1 answer
React state as object
Javascript React
0 vote405 views1 answer
Custom login with facebook button react native
Javascript React
0 vote421 views1 answer
Error-too-many-re-renders-react-limits-the-number-of-renders-to-prevent
Javascript React
23 votes398 views4 answers
How to copy to clipboard in react js
Javascript React
0 vote357 views1 answer
Making all makers to show in react native map
Javascript React
13 votes395 views4 answers
React deep copy
Javascript React
48 votes364 views1 answer
Emmet not working in react nextjs
Javascript React
1 vote365 views3 answers
Add react to existing project
Javascript React
4 votes399 views1 answer
Carousel react
Javascript React