CRUD API with MySQL

-

 index.js:



const express=require('express');
const con=require('./config12')
const app=express();

app.use(express.json());

app.get("/", (req, resp)=>{
    con.query("select * from user", (err, result)=>{
        if(err){
            resp.send("error")
        }else{
            resp.send(result)
        }
    })
});

app.post('/', (req, resp)=>{
     const data=req.body;
    con.query('Insert into users3 SET?', data,(error, result, fields)=>{
        if(error) error;
        resp.send(result)
    })
});

app.put('/:id', (req, resp)=>{
   const data=[req.body.name, req.body.password, req.params.id];
   con.query("Update users SET name=?, password=? where id =? ", data, (err, result, fields)=>{
    if(err) throw error;
    resp.send(result)
   })
});

app.delete('/:id', (req, resp)=>{
    con.query("Delete from users3 WHERE id="+req.params.id, (error, result)=>{
        if(error) throw error;
        resp.send(result)
    })
})
app.listen(5000)




config.js:

const mysql=require('mysql')
const con=mysql.createConnection({
    host:'localhost',
    user:'root',
    password:'',
    database:'test'
});

con.connect((err)=>{
    if(err){
        console.warn("error in connection");
    }

})

module.exports=con;



Comments

Post a Comment

Popular posts from this blog

Send Data Child to Parent Component - React Js

-
 App.js: import React from "react" ; import './App.css' import { Student } from "./Components/Student" ; function App () {   function alertFunc ( data )   {     alert ( data )   }   const name = "Krishan Dev"   return (     <div className = "App" >     < Student data = { name } alert1 = { alertFunc } />         </div>   ) } export default App ; ---------------------------- Student.js import React from 'react' export const Student = ( props ) => {   const data = "Bhavesh"   return (     <div>       <h6> { props . data } </h6>       <button onClick = { props . alert1 ( data ) } > Click Me </button>     </div>   ) }
Read more

Hide , Show and Toggle in ReactJs

-
 App.js: import React , { useState } from 'react' ; import './App.css' function App () {   const [ show , setShow ]= useState ( true ) return (   <div>     {       show ? <h1> Hello Bhavesh </h1> : null     }     { /* <button onClick={()=>setShow(false)}>Hide</button>     <button onClick={()=>setShow(true)}>Show</button> */ } <button onClick = { () => setShow (! show ) } > Toggle </button>   </div> ) } export default App ;
Read more

Importance Of Web Content In SEO.

-
Content is one of the most important Google ranking factors. One of the benefits of publishing good content is that it will increase the number of people who find your website through search engines.  Content provides information and this information can be used to educate search engines about your website. Content also provides a great opportunity for internal links.
Read more