/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 vote199 views1 answer
Border radius not working ios react native
Javascript React
1 vote211 views1 answer
React native flatlist pull to refresh
Javascript React
17 votes219 views3 answers
Reducer react
Javascript React
18 votes224 views3 answers
How to setup tailwind for reactjs
Javascript React
0 vote197 views1 answer
React chat sheet
Javascript React
0 vote204 views1 answer
Create-react-app height issues with flex
Javascript React
0 vote205 views1 answer
Get api data from localhost in react native
Javascript React
3 votes202 views1 answer
React js image path src from local folder
Javascript React
6 votes239 views3 answers
Apply required attribute on input using ternary operator using react js
Javascript React
111 votes246 views6 answers
Install bootstrap in react
Javascript React