Skip to content

Instantly share code, notes, and snippets.

@malikkurosaki
Created June 8, 2019 12:15
Show Gist options
  • Save malikkurosaki/0960b4df10fdd369c74f135f85bf61bf to your computer and use it in GitHub Desktop.
Save malikkurosaki/0960b4df10fdd369c74f135f85bf61bf to your computer and use it in GitHub Desktop.
update node api
const express = require('express');
const mysql = require('mysql');
const parser = require('body-parser');
const app = express();

process.on('uncaughtException',()=>{
    console.log('error loh mas');
})

app.use(parser.json());
app.use(parser.urlencoded({extended:true}));

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

db.connect((err)=>{
    if(err)throw err;
});


app.get('/api',(req,res)=>{
    res.send('apa kabar');
})

app.post('/api/tambah',(req,res)=>{
    var name = req.body.name;
    res.send(name)
})

app.get('/api/user',(req,res)=>{
    let sql = 'select * from User';
    let query = db.query(sql,(err,result)=>{
        res.send(result);
    });
})

app.get('*',(req,res)=>{

    res.send('disana senang disini senang');
})

app.listen(3000,()=>{
    console.log('app run on port 3000...')
})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment