app.get('/', function (req, res) {
res.send('Hello World!')
})
const birds = require('./birds')
// ...
app.use('/birds', birds)
const express = require('express');
const mysql = require('mysql');
// Connecting with database
const db = mysql.createConnection({
host: 'localhost', // The host you're using
user: 'yourusername', // The username you use to enter database
password: 'yourpassword' // Your password to your username
});
db.connect((error) => {
if(error) {
throw error;
}
console.log('MySQL Connected');
});
const app = express();
app.get('yourroute', (request, response) => {
let sql = 'SELECT * FROM yourtable';
let query = db.query(sql, (error, result) => {
if(error) {
throw error;
}
console.log(result) // Use the result you get back here
})
});
app.listen('3000', () => {
console.log('Server is listening on port 3000');
});
// use Express
// use Path
const express = require('express');
const path = require('path');
const app = express();
// ###Create Public folder
app.use(express.static('./public'));
app.get('/', (req, res) => {
res.sendFile(path.resolve(__dirname, './navbar-app/index.html'));
});
app.all('*', (req, res) => {
res.status(404).send('Resource not founded');
})
app.listen(5000, () => {
console.log('Server is listening on PORT: 5000');
});
app.get('/example/b', function (req, res, next) {
console.log('the response will be sent by the next function ...')
next()
}, function (req, res) {
res.send('Hello from B!')
})
app.METHOD(PATH, HANDLER)