-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathserver.js
More file actions
74 lines (64 loc) · 1.77 KB
/
Copy pathserver.js
File metadata and controls
74 lines (64 loc) · 1.77 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
const express = require('express');
const bodyParser = require('body-parser');
const MongoClient = require('mongodb').MongoClient;
const ObjectID = require('mongodb').ObjectID;
const app = express();
app.use(bodyParser.urlencoded({extended: true}));
app.use(bodyParser.json());
app.set('view engine', 'ejs');
app.use(express.static('public'));
//Start Server
app.listen(3000, function(){
console.log('listening on 3000');
});
//MongoDB
var db
MongoClient.connect('mongodb://miton:mdmiton321@ds121730.mlab.com:21730/first_mongodb', (err, client) => {
if(err) return console.log(err)
db = client.db('first_mongodb')
});
// app.get('/', function(req, res) {
// res.send('Hello World');
// });
app.get('/', (req, res) => {
//res.sendFile(__dirname+'/index.html');
db.collection('user').find().sort({_id: -1}).toArray((err, results) => {
if(err) return console.log(err)
res.render('index.ejs', {users: results})
});
});
app.post('/save', (req, res) => {
var data = {
name:req.body.name,
email:req.body.email,
phone:req.body.phone,
usr_name:req.body.usr_name,
password:req.body.password
};
if(req.body.id == '')
{
// For Save
db.collection('user').save(data, (err, results) => {
if (err) return console.log(err)
res.redirect('/?type=Insert');
});
} else {
// For Update
db.collection('user').findOneAndUpdate(
{ _id:ObjectID(req.body.id) }, // query
{ $set:data }, // Set Update Data
{ upsert: true }, // Options
(err, results) => { // Call Back
if (err) return console.log(err)
res.redirect('/?type=Update')
});
}
});
app.delete('/delete', (req, res) => {
db.collection('user').findOneAndDelete(
{_id:ObjectID(req.body.id)},
(err, results) => {
if (err) return console.log(err)
res.redirect('/')
});
});