Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ```javascript
- const express = require('express');
- const mysql = require('mysql');
- const db = mysql.createConnection({
- host: 'localhost',
- user: 'root',
- password: '',
- database: 'test'
- })
- db.connect((err) => {
- if (err) throw err;
- });
- const app = express();
- process.on('uncaughtException', function() {
- console.log('error loh gan')
- });
- app.get('/api/nama/:id', function (req, res) {
- let id = req.params.id;
- let sql = 'select * from User order by name';
- let query = db.query(sql, function (err, result) {
- if (err) {
- throw err;
- console.log(err);
- };
- res.send(result);
- });
- });
- app.get('*',function(req,res){
- res.send('no one');
- })
- app.listen(3000, () => {
- console.log('app runing on port 300 ...')
- })
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement