/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 vote363 views1 answer
React live chat widget
Javascript React
1 vote346 views1 answer
React render html variable
Javascript React
8 votes370 views3 answers
Shadown reAct native
Javascript React
0 vote337 views1 answer
React enzyme
Javascript React
0 vote391 views1 answer
Cloudinary react
Javascript React
0 vote387 views1 answer
Hide and show on button click in react js functional component
Javascript React
12 votes380 views2 answers
How to integrate redux dev tool to react application
Javascript React
0 vote358 views1 answer
React native elements bottom sheet close on back button press
Javascript React
1 vote352 views2 answers
React native select simulator
Javascript React
0 vote382 views1 answer
React native scrollview full height
Javascript React