-
Notifications
You must be signed in to change notification settings - Fork 117
Expand file tree
/
Copy pathapp.js
More file actions
51 lines (48 loc) · 1.38 KB
/
Copy pathapp.js
File metadata and controls
51 lines (48 loc) · 1.38 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
//module dependencies
var express = require('express')
, http = require('http')
, mysql = require('mysql')
, path = require('path');
var app = express();
// all environments
app.set('port', process.env.PORT || 3002);
app.set('views', __dirname + '/views');
app.set('view engine', 'jade');
app.use(express.favicon());
app.use(express.logger('dev'));
app.use(express.bodyParser());
app.use(express.methodOverride());
app.use(app.router);
app.use(express.static(path.join(__dirname, 'public')));
app.get('/', function( req, res) {
res.render('index');
});
//connect to mysql database
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : 'yourpasswordgoeshere',
database : 'nodejsmysql'
});
connection.connect();
app.get('/users', function (req, res) {
connection.query('select * from nodejs', function(err, docs) {
res.render('users', {users: docs});
});
});
// Add a new User
app.get("/users/new", function (req, res) {
res.render("new");
});
// Save the Newly created User
app.post("/users", function (req, res) {
var fname=req.body.fname,
lname=req.body.lname;
connection.query('INSERT INTO nodejs (fname, lname) VALUES (? , ?);', [fname, lname], function(err, docs) {
if (err) res.json(err);
res.redirect('users');
});
});
http.createServer(app).listen(app.get('port'), function(){
console.log('Express server listening on port ' + app.get('port'));
});