FilesExpand file tree

 master

/

app.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

51 lines (48 loc) · 1.38 KB

 master

/

app.js

Copy path

Top

File metadata and controls

• Code
• Blame

51 lines (48 loc) · 1.38 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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'));

});