bMkB9WX0

1host     : 'localhost',
2
3    user     : 'root',
4
5    password : 'root',
6
7    database : 'user'
8});
9	
10if (err) throw err;
11
12connection.query('USE user', function (err) {
13
14    if (err) throw err;
15
16    connection.query('CREATE TABLE IF NOT EXISTS user_info('
17
18        + 'email VARCHAR(30) NOT NULL,'
19
20        + 'username VARCHAR(30) NOT NULL,'
21
22        + 'PRIMARY KEY(username),'
23
24        + 'password VARCHAR(15) NOT NULL'
25
26        +  ')', function (err) {
27
28            if (err) throw err;
29
30        });
31});
32	
33res.render('users/index',{users: results });
34	
35if (err) res.json(err);
36
37res.redirect('/myusers/'+email);
38
39console.log(results);
40	
41if (err) res.json(err);
42
43 req.user=row[0];
44
45 console.log(row);
46
47 next();
48	
49res.status(err.status || 500);
50
51res.render('error', {
52
53  message: err.message,
54
55  error: err
56
57});
58	
59message: err.message,
60
61error: {}
62	
63tr
64
65  td User Email:
66
67  td
68
69    input#email(type="email", name="email")
70
71tr
72
73  td Username:
74
75  td
76
77    input#userName(type="text", name="userName")
78
79tr
80
81  td Password:
82
83  td 
84
85    input#password(type="password", name="password")
86
87tr
88
89  td
90
91    button(type="submit") Create