Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var express = require('express')
- var app = express()
- var port = 3000
- var mysql = require('mysql')
- var bodyParser = require('body-parser')
- app.set('view engine', 'ejs')
- app.set('views', 'views')
- app.use(express.static('public'))
- app.use(bodyParser.urlencoded({ extended: false }))
- app.use(bodyParser.json())
- var connection = mysql.createConnection({
- host : 'localhost',
- user : 'root',
- password : 'root',
- database : 'voorbeeld'
- })
- var users = [{
- naam: 'mo',
- id: 0
- },
- {
- naam: 'bob',
- id: 1
- }
- ]
- app.get('/', (req, res) => {
- res.render('index', {
- users: users
- })
- })
- app.get('/users/:id', function(req, res) {
- res.render('users', {
- user: users[req.params.id]
- })
- })
- app.get('/database/users', function (req, res) {
- connection.query('SELECT * FROM users', function (err, result) {
- if (err) {
- console.log(err)
- }
- res.render('databaseusers', {
- users: result
- })
- })
- })
- app.post('/database/users', function (req, res) {
- var obj = {
- naam: req.body.naam
- }
- connection.query('INSERT INTO users SET ?', obj, function (err, result) {
- if (err) {
- console.log(err)
- }
- console.log(result)
- })
- res.redirect('/database/users')
- })
- app.listen(port, function () {
- console.log(`Connected to ${port}`)
- })
- // app.get('/', function (req, res) {
- // res.render('home/home', {
- // users: users,
- // })
- // })
- // app.get('/users/:id', function (req, res) {
- // res.render('users', {
- // user: users[req.params.id]
- // })
- // })
- // app.get('/database/users', function (req, res) {
- // connection.query('SELECT * FROM users', function(err, result) {
- // if (err) {
- // console.log(err)
- // return
- // }
- // console.log(result)
- // res.render('databaseusers', {
- // users: result
- // })
- // })
- // })
- // app.post('/database/users', function (req, res) {
- // console.log(req.body.naam)
- // var obj = {
- // naam: req.body.naam
- // }
- // connection.query('INSERT INTO users SET ?', obj, function(err, result) {
- // if (err) {
- // console.log(err)
- // return
- // }
- // console.log(result)
- // res.redirect('/database/users')
- // })
- // })
- // app.get('/:animal/:number', function (req, res) {
- // var animals = {
- // cow: 'moo',
- // pig: 'oink',
- // dog: 'meow',
- // cat: 'woof',
- // goldfish: '...'
- // }
- // var derp = req.params.animal
- // var sound = animals[derp]
- // var num = Number(req.params.number)
- // var ok = ''
- // for (var i = 0; i <= num; i++) {
- // ok += sound + ' '
- // }
- // res.send('lel ' + derp + ' ' + 'says ' + sound + ' ' + ok)
- // })
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement